Ok this has to do with both update.php and detail.php pages and found exact problem and solution. DataAssist generates wrong code IF the table that you are pulling data has a SUFFIX (e.g. datatable_suf)
The WADAtablename recordsets created instead of puting aparameter $Paramid_WADAtablename it writes it as $Piramid_sufix_WADAtablename.
It does the same to the $Paramid2 variable and it transforms it as $Paramid_sufix2_WADAtablename while it should be written as $Paramid2_WADAtablename
Lastly it does it on the Detail.php page at the session variable
$ParamSessionid_suffix_WADAtablename instead of $ParamSessionid_WADAtablename.
This mixes up Dreamweaver (Im using CS4) and ends up the 2 recordsets with a ! mark cause dreamweaver reads the code for some reason as 2 variables and in case we got Piramid1 and 2 then it sees 4 parameters (if you double clikc in recordset/advanced parameters box)
So its partial a DataAssist "Minor" bug cause it writes wrong code for piramid parameter
and its partial for Dreamweaver i suppose but im not sure since i dont know how dreamweaver reads exactly the blocks so i can't be sure about that.
Give me an answer if I should report this as a bug and open ticket or you will address it to your tach team so it is fixed in the next 2.0.5 release of DataAssist.
You can resolve the issue by renaming the parameters as shown above.
WARNING: This bug is only presented when you got a SUFFIX at your tables. e.g. im always using suffixes for my own reasons and writing the tables as companies_cmp.
the cmp is called a suffix for the new developers out there.
Hope this post helped.
