[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=
e
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=
rt
all possible RDBMS types.
Charlie
--
Charlie Clark
Helmholtzstr. 20
D=1Asseldorf
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226