Using latest fresh install of DataAssist, PHP, MySQL, and Dreamweaver CS5
I created my pages with DataAssist Wizard. All I need is the Results and Details.php pages. I can pull up the results fine. However I get this error when I click on the details button for any of the results:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit, eduHSname, eduHSloc, eduHSyears, eduHSdegree, eduHSgpa, eduHSgpaScale, ed' at line 1
The only way I can remove the error is if I open the recorset for the details page and remove all the variables, Paramid, ParamSessionid, and Paramid2. Then I delete "WHERE id = Paramid OR ( -1= Paramid2 AND id= ParamSessionid)" from the SQL statement. Then I switch to Simple View and choose id for the filter = URL Parameter id.
I'm not sure what the problem is because I have successfully used DataAssist many times. Can you tell by looking at my page (attached) what the problem is?