I'm a total Zope newcomer, and I'm attempting to create a test thing where I can enter data into a form and have that data inserted into a table in a gadfly database. I've read the ZDTML guide, the Z SQL methods guide, and the managers guide, and none of these seem to give any examples of how to do this simplest task. (I've found the documentation to be absymal -- no examples, just definitions.) I have a 'dataentry.html' that looks something like this: <form method="post" action="sqltestthing"> Color: <input name="col"> Flavor: <input name="fla"> <input type=submit> </form> And then a Z SQL Method 'sqltestthing': INSERT INTO TESTTABLE (color,flavor) VALUES (<!--sqlvar col type=nb-->,<!--sqlvar fla type=nb-->) I enter the data into the form page, and hit submit. I get back the sqltestthing page saying 'This query requires no input.' I hit submit again, and get Error, exceptions.SyntaxError: unexpected token sequence.near :: 'lavor)\012VALUES ('*',) I'm obviously doing this entirely wrong. Perhaps someone could point me to a simple example of a simple database app in action? Daniel Drucker
On Wed, 2 Jun 1999, Daniel M. Drucker wrote:
And then a Z SQL Method 'sqltestthing': INSERT INTO TESTTABLE (color,flavor) VALUES (<!--sqlvar col type=nb-->,<!--sqlvar fla type=nb-->)
try <!--#sqlvar ... _with_ the '#' ... t.
And then a Z SQL Method 'sqltestthing': INSERT INTO TESTTABLE (color,flavor) VALUES (<!--sqlvar col type=nb-->,<!--sqlvar fla type=nb-->)
try <!--#sqlvar ... _with_ the '#' ...
There is a # there... that was just a typo in my email.
participants (2)
-
Daniel M. Drucker -
tango mike