[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
>