[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