That is exactly what I was looking for - Assigning a default value works
I previously tried to do this using the syntax provided by zope help:
but had no luck.
----- Original Message -----
From: J Cameron Cooper <[EMAIL PROTECTED]>
Date: Thursday, August 25, 2005 10:35 pm
Subject: Re: [Zope] SQL Problem
> 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
> Alternately, I believe the DTML sqlvar tags can also be given a
> "Building Websites with Plone"
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists -