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