RE: cf mx and oracle 8i
Try using createODBCDateTime() to specify a dateobject, instead of to_date() 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]
Re: cf mx and oracle 8i
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 > 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,) > > I obtain this error > > Error Executing Database Query. > [Macromedia][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match > format string I may be wrong but try taking out the time string from the date and also ensuring that the format of the date matches ie: to_date('19/07/2004', 'dd/mm/') HTH Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cf mx and oracle 8i
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, instead of to_date() 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]
Re: cf mx and oracle 8i
Steff, You need to use to_date as this is used by Oracle to convert your date from a string into the correct format. Have you tried the re-ordering I suggested? to_date('19/07/2004', 'dd/mm/') Cheers Simon On Tue, 20 Jul 2004 10:20:05 +0200, Steff <[EMAIL PROTECTED]> wrote: > 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, instead of > to_date() > > 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]
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]
RE: cf mx and oracle 8i
I think where is the problem, I get date values with a query. The table 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]
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 get date values with a query. The table > 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. That is right - try something like the following: to_date('#dateformat(date_from_query,"DD/MM/")#','DD/MM/') Should work okay for you Cheers Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cf mx and oracle 8i
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 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]
Re: cf mx and oracle 8i
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,) Use cfqueryparam. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cf mx and oracle 8i
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 get date values with a query. The table > 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. That is right - try something like the following: to_date('#dateformat(date_from_query,"DD/MM/")#','DD/MM/') Should work okay for you Cheers Simon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]