Faulty recordset

Her is a screen shot of a wizard built recordset. Notice the faulty Paramid_cme This happen just by opening the recordset from the pallet. Other times if I make a change to the recordset it will just create a new one which will be ignored because the old one is read last.

This is an issue that occurs when using the underscore character in your column names.

Here is why the issue occurs:

When DataAssist Creates the recordset parameters, it uses the column name for the parameter.

the php variable name for the parameter gets written as:
$<parametername>_<recordsetname>

so for a column named user_id in the users table:
$paramuser_id_WADAusers

when Dreamweaver reads this it expect everything after the first underscore to be the recordset name, it sees the peramter name as:
paramuser

and the recordset name as
id_WADAusers


there are 2 workarounds for this issue:
1) Adopt the camelCase naming convention

2) Edit the code for the variable nams to remove the underscores, change:
$paramuser_id_WADAusers

to:
$paramuserid_WADAusers