The trouble is that I'm selecting the date, not inserting it.
SELECT Collection_Desc, LICENSED_PRODUCTS.Collection_Type, Prod_Code,
Approved_Date, Ref_No, Licensed_Status, Submitted_Date
FROM INTRANET.LICENSED_PRODUCTS, INTRANET.LICENSED_COl_TYPE
WHERE LOC_CODE = 'FLBC'
AND ((Licensed_Status = 'ACTIVE' OR (Licensed_Status =
'PENDING'))
AND LICENSED_PRODUCTS.COLLECTION_TYPE =
LICENSED_COl_TYPE.COLLECTION_TYPE
Sometimes throws this error:
[MERANT][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC]Invalid datetime
format.
The offending field is Submitted_Date. If this field is selected for some
records the error is thrown. For others, it is not. And apparently bad
records can be selected if good records are selected first.
All of this only happens on the CFMX server. The CF4.5 server runs the
above query just fine in all cases.
Thanks Ian
-----Original Message-----
From: Larry Hoy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 11:44 AM
To: CF-Talk
Subject: CF4.5 and CFMX Oracle ODBC Drivers
use the "CreateODBCDateTime()" function. Old ODBC drivers created date and
time down to the seconds, new date times go to the 1/10 seconds.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
