[Zope] SQL Problem

[Jaroslav Lukesh]

Dne čtvrtek, 25. srpna 2005 23:52 Philip Beardmore 
<philip.beardmore at 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