Philip Beardmore wrote:
I'm having a really annoying SQL problem which I think (or hope) can
easily be sorted but I'm not sure how to do it.
I have a ZPT which is collecting data in a form - Both text boxes and
checkboxes. The form then passes the variables on to a DTML Method
which does a few bits of error checking then calls an Z SQL Method to
insert the data.
If all of the data is completed (i.e. each textbox and checkbox is
ticked) then the form inserts the data exactly as it should. If not all
checkboxes are ticked the page returns an error - This is due to the SQL
Method trying to insert data which hasnt been passed to it.
You can provide default values to the parameters of your Z SQL Method.
Alternately, I believe the DTML sqlvar tags can also be given a default
"Building Websites with Plone"
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists -