[Zope] SQL Problem

[Philip Beardmore]

Hi JCC,

That is exactly what I was looking for - Assigning a default value works
great!

I previously tried to do this using the syntax provided by zope help:
title:string="default value"

but had no luck.

Thanks :->
Phil

----- Original Message -----
From: J Cameron Cooper <zope-l at jcameroncooper.com>
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 
> Method. 
> Alternately, I believe the DTML sqlvar tags can also be given a 
> default 
> behavior.
> 
>        	--jcc
> -- 
> "Building Websites with Plone"
> http://plonebook.packtpub.com
>