[Zope] SQL Problem
J Cameron Cooper
zope-l at jcameroncooper.com
Thu Aug 25 17:35:06 EDT 2005
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
behavior.
--jcc
--
"Building Websites with Plone"
http://plonebook.packtpub.com
More information about the Zope
mailing list