Recordset problem: No columns

Hallo
I am having problems creating a recordset with my DB, while the procedure
works fine with the sample MySQL DB provided with Dreamwever. I am using PHP
MySQL (With PHPMyAdmin).
I have created a connection and it is working properly except that colums are
not showed for any table of my DB. So I can only define a query that include
all colums. If I click the test botton I get all records of the selected table.

I need the columns to appear so that I can then go ahead and filter the
recordset.
What is wrong?
Thanks for help

Hallo again!
I have a news that could help on solving the problem: as a matter of fact now
I realize that the problem occurs only for certain tables of my DB mySQL, so
something should be wrong with those tables!
Suggestions!

Hallo again!
-- a further news: the dialog box does not show columns if the selected table contains one or more columns of type ENUM!!!
Is it a bug of my version of Dreamweaver (6.0) ?

DW 6.0 had issues, but I don't know if this specifically was one of them.
Download the 6.1 updater as soon as possible.


"cpighin" <webforumsuser (AT) macromedia (DOT) com> wrote

Hallo again!
-- a further news: the dialog box does not show columns if the selected
table contains one or more columns of type ENUM!!!
Is it a bug of my version of Dreamweaver (6.0) ?

This my understanding of the problem after evaluation of Dreamweaver 8 (of
course I can be wrong and I will be happy to be denied).

It does NOT handle properly MySQL columns of type ENUM in the sense that in
such cases the connection dialog box does not show columns.

The solution to this problem is to write directly the SQL code using
appropriate attribute for the instruction SELECT (I used DOUBLE, instead of
INT).