Hi,
Long time CF programmer now using CFMX7 but new to
Dreamweaver MX2004. I have a site set up for development on a local
machine with the following:
Local - c:\ambassador
Remote - c:\inetpub\wwwroot\ambassador\
Testing - same
URL prefix -
http://localhost/ambassador
I have my Access database in
c:\inetpub\wwwroot\database\ambassador.mdb and have it set up with
DNS name ambassador. It verifies correctly and I have been using it
outside of DW for quite a while in my CF templates in Homesite.
My problem is when I look in the Application Databases list
the tables all are listed as
C:\inetpub\wwwroot\database\ambassador.tablename. If I create a
recordset in Bindings, the tables are also listed like this in the
table dropdown for the recordset.
Also, after creating a recordset and looking at the code in
the template the query shows
SELECT FIRSTNAME, LASTNAME FROM
c:\inetpub\wwwroot\database\ambassador.lender
Why don't the tables show as just their name without the full
pathname as shown in the documentation? It's impossible to actually
see which table is which with the pathname displayed.
Thanks,
Doug
1
Reply
AdChoices