[Zope] SQL Problem

[J Cameron Cooper]

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