Problem with dynamic lists

[mk00pa]

Hi,

I am having a problem with dynamic lists in DW CS4. I have created a recordset that links to a mysql table called users. The users table contains the columns "Name", "Shift" and "Department".

For my recordset I have only selected "Name" as values to display. When I test the recordset it displays all records. Yet the dynamic list can't display the recodset values, it is empty.

Any help on this would be appreciated.

Thanks,

Matt.

[mk00pa]

I managed to resolve this by changing the datatype in mysql from text to varchar.