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]
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
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
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
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)
-
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
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
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,-),
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,)
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
10 matches
Mail list logo