Postgresql/Cold Fusion cfinsert date problems
От | Paul Haddon |
---|---|
Тема | Postgresql/Cold Fusion cfinsert date problems |
Дата | |
Msg-id | 20010703124234.B19866@mail.hartingdale.com.au обсуждение исходный текст |
Ответы |
Re: Postgresql/Cold Fusion cfinsert date problems
|
Список | pgsql-odbc |
I'm evaluating Postgresql on Linux as a database back end to Cold Fusion on NT, and running into a problem with dates. The test setup is: Cold Fusion 5 on Win2000; the latest ODBC driver from odbc.postgresql.org; Postgresql 7 on Linux. Cold Fusion has two methods of inserting records into the database. The first is where you wrap a standard 'insert into...' SQL command in a <cfquery..> tag. This is working correctly. The second method takes defined form variables and inserts them into a specified table. Essentially it is building the SQL command for you. eg: <cfinsert datasource="postgresql" tablename="test_table" formfields="fielda, fieldb"> The problem with this method is that the date that ends up in date fields in the table is always the servers date, regardless of what information is placed into the form field, and in what format. Is this a Cold Fusion oddity; is there some setting in Cold Fusion or the odbc driver I can modify; is there a way of formatting date variables to get around the problem? Or do I look at not using the cfinsert method altogether? Thanks Paul Haddon Technical Services Manager Hartingdale Internet
В списке pgsql-odbc по дате отправления: