[Zope-DB] sqlvar tag has no type="boolean"
Joel Burton
joel@joelburton.com
Thu, 21 Mar 2002 10:34:44 -0500
Works fine for me. I'm using PG 7.2, Zope 2.5.0, zpsycopg 1.11.
What versions are you using?
Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant
> -----Original Message-----
> From: zope-db-admin@zope.org [mailto:zope-db-admin@zope.org]On Behalf Of
> Ashley
> Sent: Wednesday, March 20, 2002 3:54 PM
> To: zope-db@zope.org
> Subject: [Zope-DB] sqlvar tag has no type="boolean"
>
>
> Hi list,
>
> I'm now to zope (and sql also). I am using postgresql with
> psycopg. This is
> my first attempt to setup a Z SQL meathod to insert into my
> table. My table
> has several boolean attributes:
>
> CREATE TABLE contacts (
> contact_id integer primary key
> ,owner boolean
> ,manager boolean
> ,buyer boolean
> );
>
> I can not figure out how to get zope to insert into a boolean attribute.
> If I use sqlvar type="string", and enter true in the insert form,
> zope passes
> 'true' and postgresql chokes on the single quotes.
>
> Surely there is a work around. Any ideas?
>
>
> --
> Ashley Gould 510.482.0525
> 3020 Kansas St. ashleyg@dnai.com
> Oakland, CA 94602
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db
>