[Zope-DB] Types between zsql methods and postgresql types

Charlie Clark charlie@begeistert.org
Wed, 04 Sep 2002 10:10:47 +0000

On 2002-09-04 at 03:33:59 [+0000], you wrote:
> It's the part where I have to identify the types: I've got postgresql
> identifying a column's datatype as "money", but zope's zsql methods don't
> have this type, nor do they seem to have the "boolean" type. The error
> message I got says: [1]. I don't know how to cast one type to another, or
> even where I'd do it. Anyone have any pointers on how to do this?

It sounds very much like you are using <dtml-sqlvar> in your ZSQL to insert=
the values. You might try <dtml-sqlvar variable type=3D"string"> which I us=
when inserting DateTime objects. Alternatively you could try straight 
<dtml-var> instead where you don't need a type. <dtml-sqlvar> can be nice 
because it will check for valid sql values but it is a problem trying suppo=
all possible RDBMS types.

Charlie Clark
Helmholtzstr. 20
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226