Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DW8 Adding a period before table name under Application Connection

Status
Not open for further replies.

CMcC

Programmer
Feb 5, 2002
196
US
Hi all -
Pretty new to the dreamweaver and coldfusion scene and am using the Dreamweaver 8 suite. I created a connection to my VFP tables (adlookup.dbf) under C:\ via ODBC system DSN. In the Coldfusion Administrator I can verify all connections and it says OK.
Then I see if Dreamweaver added the database and it did...
However, when I expand the data under 'Tables' it shows me the VFP tables but it prefixes the table name with a period.

Code:
c:.adlookup


When I select view data, it tells me that the file '.adlookup' does not exist. Can anyone tell me why it prefixes with a period?
I made sure that the CASE was the same - all lower case and the extension is also lowercase.
All suggestions are appreciated.
CMCC
 
So far I am working around this problem by dragging the table name into the main page window to make a recordset and then modifying the query to remove the period and anything else I need to do to let the query work. If you do this, make sure you use the test button.
 
Hi LordBagel - when you say:
"dragging the table name into the main page window to make a recordset and then modifying the query to remove the period and anything else" - how do you drag the table into the main window? Not sure what you mean exactly, since I use the coldfusion admin to create the connection - the table name isnt visible from the DM interface, only the connection created.
THanks for your response...
Cmcc
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top