trying to insert into postgresql db
I am using an sql method to insert data into a postgresql db. The sql method keeps rejecting the data types date and time. These are recognized datatypes in postgresql. If I switch it to Int its ok. If I use like varchar will the connector convert it to the Right type for postgresql/??? Lewie
Lewis, can you post your zsql statement so we can take a look at it. We have been using postgres behind zope for close to a year and a half, and do this all the time. So, it is possible. You might also post the table schema you are using. Btw, what connector are you using? -Chris On Tuesday 07 January 2003 06:55 pm, Krause, Lewis wrote:
I am using an sql method to insert data into a postgresql db.
The sql method keeps rejecting the data types date and time.
These are recognized datatypes in postgresql. If I switch it to
Int its ok. If I use like varchar will the connector convert it to the
Right type for postgresql/???
Lewie
participants (2)
-
Chris Kratz -
Krause, Lewis