I have an html table where each cell in one column is a form with a button. I am trying to have the submit button perform the sql shown below. The database connection is to a MySQL Table. I've looked on the Zope site at: http://www.zope.org/Documentation/Guides/ZSQL/ZSQL-HTML/ZSQL.2.5.4.html and see that if an sqltemplate is used that the first lookup for the var is in the http request. The add2dun is an enum Y,N. The test works but if I use the action shown below I just get the test page with the url ..../y_add2dun/manage_test I've changed the last line to just ="<dtml-var ID>" and get the same results. In the page where the button is pressed the <dtml-var ID> is actually an integer in the source code of the html as I expected. Any help would be appreciated. I've also looked at the new sql How tos and they deal with forms that have fill in boxes which I've had no problem with the fill in boxes but thanks for the How-To's SQL: ID=y_add2dun Arguments= ID UPDATE askref SET add2dun='Y' WHERE ID="<dtml-sqlvar ID type=int>" COLUMNS in MySQL TABLE: |ID|Date|Submitter|Phone|add2dun|add2faq|responder| --------------------------------------------------- HTML IN DTML DOCUMENT( this is one cell in a table from a previous sql to display all where add2dun='N' and responder=''): <td><form method=post action=y_add2dun value="<dtml-var ID>" name="ID"> <input type ="submit" name="submit" value="ADD"></form></td> Thanx Thomas -------------------------------------------------------------------- Rock and Rule Zope Rocks -- http://www.zope.org Python Rules -- http://www.python.org -------------------------------------------------------------------- Thomas McMillan Grant Bennett Appalachian State University Computer Consultant II University Library bennettt@am.appstate.edu http://www.library.appstate.edu/webmaster/ Voice: 828 262 6587 FAX: 828 262 3001 Windows 95 is a 32-bit extension to a 16-bit patch for an 8-bit operating system that was originally coded for a 4-bit microprocessor. - Chris Dunphy Boot Magazine