[Zope-DB] Types between zsql methods and postgresql types
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: . 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.