Question
Dreamweaver 8 recordset, selecting table
In Dreamweaver 8, when I go to set up a recordset, in the
recordset dialog box, the "table" dropdown box indicates a path to
the table in the database instead of listing all the tables in the
database.
ie C:\CFusionMX7\wwwroot\websites\mannsUpdaterServer\vehicles\mannsphotos.tblphotos
This did not happen to me in any previous Dreamweaver from UltraDev to MX2004.
What do I do to configure Dreamweaver (or possibly Coldfusion) to show the tables of the database in the table dialog box instead of the path?
The SQL should look like this:
<cfquery datasource="mannsphotos">
UPDATE tblphotos
SET Subject=
Not this:
<cfquery datasource="mannsphotos">
UPDATE C:\CFusionMX7\wwwroot\websites\mannsUpdaterServer\vehicles\mannsphotos.tblphotos
SET Subject=
Your help is greatly appreciated
Thank you,
Barry
ie C:\CFusionMX7\wwwroot\websites\mannsUpdaterServer\vehicles\mannsphotos.tblphotos
This did not happen to me in any previous Dreamweaver from UltraDev to MX2004.
What do I do to configure Dreamweaver (or possibly Coldfusion) to show the tables of the database in the table dialog box instead of the path?
The SQL should look like this:
<cfquery datasource="mannsphotos">
UPDATE tblphotos
SET Subject=
Not this:
<cfquery datasource="mannsphotos">
UPDATE C:\CFusionMX7\wwwroot\websites\mannsUpdaterServer\vehicles\mannsphotos.tblphotos
SET Subject=
Your help is greatly appreciated
Thank you,
Barry
AdChoices