RE: cf mx and oracle 8i

2004-07-20 Thread Micha Schopman
Try using createODBCDateTime() to specify a dateobject, instead of to_date() Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription]

Re: cf mx and oracle 8i

2004-07-20 Thread Simon Whittaker
On Tue, 20 Jul 2004 09:51:37 +0200, Steff [EMAIL PROTECTED] wrote: Hello I have a request like insert into toolbox (idtoolbox,label,descr,language,idlinktype,idsource,creatingdate,updatingdat e,publish,delstatus,orderby) values (2,'services et catgories','','FR',0,0,to_date('2004-07-19

RE: cf mx and oracle 8i

2004-07-20 Thread Steff
I try and I obtain ORA-00932: inconsistent datatypes Can you help me? thanks steff -Message d'origine- De : Micha Schopman [mailto:[EMAIL PROTECTED] Envoy : Tuesday, July 20, 2004 10:06 AM : CF-Talk Objet : RE: cf mx and oracle 8i Try using createODBCDateTime() to specify a dateobject

Re: cf mx and oracle 8i

2004-07-20 Thread Simon Whittaker
obtain ORA-00932: inconsistent datatypes Can you help me? thanks steff -Message d'origine- De : Micha Schopman [mailto:[EMAIL PROTECTED] Envoy : Tuesday, July 20, 2004 10:06 AM : CF-Talk Objet : RE: cf mx and oracle 8i Try using createODBCDateTime() to specify a dateobject, instead

RE: cf mx and oracle 8i

2004-07-20 Thread Micha Schopman
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) -

RE: cf mx and oracle 8i

2004-07-20 Thread Steff
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

Re: cf mx and oracle 8i

2004-07-20 Thread Simon Whittaker
On Tue, 20 Jul 2004 10:32:35 +0200, Steff [EMAIL PROTECTED] wrote: I think where is the problem, I get date values with a query. The table valueis 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

RE: cf mx and oracle 8i

2004-07-20 Thread Micha Schopman
Well you can create a new date object using CreateDateTime, CreateODBCDateTime, after stripping out the wanted values with Left, Right and Mid. So for DD-MM- you could do cfset datevar = 20-07-2004 cfset tmp = createODBCDate(createDate(ListGetAt(datevar,3,-), ListGetAt(datevar,2,-),

Re: cf mx and oracle 8i

2004-07-20 Thread Jochem van Dieten
Steff wrote: insert into toolbox (idtoolbox,label,descr,language,idlinktype,idsource,creatingdate,updatingdat e,publish,delstatus,orderby) values (2,'services et cat¿½gories','','FR',0,0,to_date('2004-07-19 00:00:00.0', 'dd/mm/'),to_date('2004-07-19 00:00:00.0', 'dd/mm/'),1,0,)

RE: cf mx and oracle 8i

2004-07-20 Thread Steff
Thanks, it works well. cordialy Steff -Message d'origine- De : Simon Whittaker [mailto:[EMAIL PROTECTED] Envoy : Tuesday, July 20, 2004 10:37 AM : CF-Talk Objet : Re: cf mx and oracle 8i On Tue, 20 Jul 2004 10:32:35 +0200, Steff [EMAIL PROTECTED] wrote: I think where is the problem, I