value is like 19-JUL-04. Coldfusion gives me a date like '2004-07-19
00:00:00.0' to_date can't convert. So I should certainly before insert
query, modify the date to obtain the right format.
thanks
steff
-----Message d'origine-----
De : Micha Schopman [mailto:[EMAIL PROTECTED]
Envoyé : Tuesday, July 20, 2004 10:24 AM
À : CF-Talk
Objet : RE: cf mx and oracle 8i
We need more info from you, we can only guess at the moment
- Is the datetime value you are inserting between the boundaries of
the datetime type you have set with Oracle? (small datetime, large datetime,
etc)
- On which column does the error occur (take away cols, add cols,
to your command)
- What happens when you use createODBCDate()
- What happens if you insert NULL values
- Does the error occur on the datetime part?
Etc..
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
