the problem occurs when you have columns in your database that use spaces in the name.
the reson for the problem is in the way that data assist creates recordset variables and the way that Dreamweaver interpretes recordset variable names.
when data assist creates a recorset variable, it uses the WADA<column name> as the variable name. in your case:
WADACat_ID
Dreamweaver writes the code for the variable as:
<variable name>_<recordset name. in your case:
$WADACat_ID_WADAlinks
The problem comes in when you edit the recordset. Dreamweaver interprate's every thing up to the first underscore "_" as the variable name, and after the underscore as the recordset name , or:
WADACat as the variable and:
ID_WADAlinks as the recordset.
the work around is to edit the code.
Find each instance of:
$WADACat_ID_WADAlinks
and change it to:
$WADACatID_WADAlinks
it should be found 3 times.
