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@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
Dne Ätvrtek, 25. srpna 2005 23:52 Philip Beardmore <philip.beardmore@sunderland.ac.uk> napsal(a):
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.
<params> userid:string="" datetime:string="" course:string="" name:string="" core1:string="" core2:string="" core3:string="" core4:string="" core5:string="" choice1:string="" choice2:string="" choice3:string="" choice4:string="" </params> INSERT choices (userid, datetime, course, name, core1, core2, core3, core4, core5,choice1, choice2, choice3, choice4) VALUES ( <dtml-sqlvar userid type="string">, <dtml-sqlvar datetime type="string">, <dtml-sqlvar course type="string">, <dtml-sqlvar name type="string">, <dtml-sqlvar core1 type="string">, <dtml-sqlvar core2 type="string">, <dtml-sqlvar core3 type="string">, <dtml-sqlvar core4 type="string">, <dtml-sqlvar core5 type="string">, <dtml-sqlvar choice1 type="string">, <dtml-sqlvar choice2 type="string">, <dtml-sqlvar choice3 type="string">, <dtml-sqlvar choice4 type="string"> ) I use default parameters in <params> saction without problems. -- Jaroslav Lukesh ----------------------------------------------------------- This e-mail can not contain any viruses because I use Linux
participants (2)
-
Jaroslav Lukesh -
Philip Beardmore