This is an issue with column names that use the underscore naming convention.
The problem arises from the way that DataAssist creates parameter names in the recordsets and the way that Dreamweaver interperate's them.
Detailed Explanation:
DataAssist uses the column name as the parameter name, the naming convention used is:
Param<column name>
For instance the column name:
dummy_ID
gets a parameter named
Paramdummy_ID
when the code is written for the parameter, the naming convention is:
$<Parameter Name>_<Recordset Name>
So the Paramdummy_ID for the WADAdummy recordset would be written to code as:
$Paramdummy_ID_ WADAdummy
The problem is the way Dreamweaver interperates this parameter name when you reinspect the recordset. Dreamweaver sees everything after the first underscore character as being the recordset name.
This means that Dreamweaver sees the parameter name as:
Paramdummy
and the recordset name as:
ID_ WADAdummy
We are working on trying to fix this issue, in the mean time, you can do one of 2 things to combat the problem:
1) use the camelCase naming convention for your database column instead of underscores - This would be the simplest.
2) Edit the code directly to remove the underscores from the parameter name, for example, edit the parameter name code:
$Paramdummy_ID_ WADAdummy
to:
$ParamdummyID_ WADAdummy
