[Zope] ZSQL question

[Casey Duncan]

There is a trick for passing default values from forms in this case 
using marshaling:

<input type="checkbox" name="foo" value="somevalue" />
<input type="hidden" name="foo:default" value="somedefault" />

The latter line uses a zope marshaling trick. If ZPublisher sees no 
other value for "foo" besides the default one it uses the default value 
from the hidden field. Otherwise it uses the value from the checkbox.

hth,

Casey

Colin Fox wrote:
> Hi, all.
> 
> I have a ZSQL insert function that requires an optional parameter. 
> 
> The variables are coming from an HTML form, and one of the variables is
> a checkbox. Apparently, if the checkbox is unchecked, the variable
> doesn't appear.
> 
> As a small example, let's say there were two strings and a checkbox,
> labelled str1, str2 and cb. I need this:
> 
> insert into mytable(col1, col2, col3) values (str1, str2, cb)
> 
> as well as
> 
> insert into mytable(col1, col2) values (str1, str2)
> 
> if cb is None.
> 
> I can't find any examples of optional insert variables, just optional
> join parameters.
> 
> Also - is there a comprehensive ZSQL document anywhere?
> 
> Thanks!
> 
>