MySQL Error

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?

After posting my message, I tried going back to work around the problem. I still received the error. Why it worked once and not again I do not know. So then I noticed that when I go back into the details recordset, the "selected" option is choosen instead of "All". So I changed my SELECT statement manually to SELECT * from application. This seems to be working now. Still though, I should not have to be doing this as a work around. I never had too before. Thanks for any help.

the problem is caused by the column name "limit" in your table.

limit is a reserved word in SQL and should be avoided as a column name.

a full list of SQL reserved words can be found here:
reserved-words.html