Dreamweaver 8 recordset, selecting table

[fused]

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

[Newsgroup_User]

It is caused by a bug in the CF7.01 updater that affect access databases.
The work around is to change the database type in the CF administrator from
Access to Access with Unicode.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"fused" <webforumsuser@macromedia.com> wrote in message
news:e81l8j$q25$1@forums.macromedia.com...
> 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
>
>