[Zope] ZSQL question

[Colin Fox]

--=-JB6XQ67ZwgqVEnC5OZMX
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Hi, all.

I have a ZSQL insert function that requires an optional parameter.=20

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!

--=20
Colin Fox                                       cfox@crystalcherry.com
CF Consulting Inc.                                    GPG Fingerprint:
                    D8F0 84E7 E7CC 5C6C 9982  F1A7 A3EB 6EA3 BC97 572F

--=-JB6XQ67ZwgqVEnC5OZMX
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQA8ojnvo+tuo7yXVy8RAibOAJ0QRE4HZfN1RieefiInnTfYgy92FACguX8o
X0ZUkhjccgFD5YPjuYO/+Iw=
=NzEH
-----END PGP SIGNATURE-----

--=-JB6XQ67ZwgqVEnC5OZMX--