[Zope] Having submit only problems with SQL methods

TMGB bennettt@am.appstate.edu
Tue, 21 Sep 1999 15:56:38 -0400


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