Why don't you use CreateODBCDate() / CreateODBCDateTime()?
Along with
That never gives problems.
- Original Message -
From: "Jason Smith" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, December 21, 2004 8:17 PM
Subject: Re: Date Issues
> Th
t: Tuesday, December 21, 2004 2:18 PM
To: CF-Talk
Subject: Re: Date Issues
That is a very helpful piece of code right there
MYSQL is outputting the date - 2012-07-20 04:00:00.0 and of course the
original writer of the cf app has MM/DD/ as the output in his code.
Now I'm assuming I can just ch
gt; >
> > -----Original Message-
> > From: Jason Smith [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, December 21, 2004 1:58 PM
> > To: CF-Talk
> > Subject: RE: Date Issues
> >
> > I tried that in the beginning thinking it might have something to do
> >
ohn Burns
>Certified Advanced ColdFusion MX Developer
>AI-ES Aeronautics, Web Developer
>
>-Original Message-
>From: Jason Smith [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, December 21, 2004 1:58 PM
>To: CF-Talk
>Subject: RE: Date Issues
>
>I tried that in the beginni
>
> John Burns
> Certified Advanced ColdFusion MX Developer
> AI-ES Aeronautics, Web Developer
>
> -Original Message-
> From: Jason Smith [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 21, 2004 1:58 PM
> To: CF-Talk
> Subject: RE: Date Issues
>
> I
r 21, 2004 1:58 PM
To: CF-Talk
Subject: RE: Date Issues
I tried that in the beginning thinking it might have something to do
with it. But all that does is reverse the date 2012/07/20 what I really
can't figure out is where it could possibly be pulling that date from.
At 11:54 AM 12/21/2004, you wr
ailto:[EMAIL PROTECTED]
>Sent: Tuesday, December 21, 2004 1:48 PM
>To: CF-Talk
>Subject: Date Issues
>
>Can anyone narrow down what the problem might be:
>
>The site I'm working on was built for access, I ported it to mysql after
>making all the needed changes for date stamps
:[EMAIL PROTECTED]
Sent: Tuesday, December 21, 2004 1:48 PM
To: CF-Talk
Subject: Date Issues
Can anyone narrow down what the problem might be:
The site I'm working on was built for access, I ported it to mysql after
making all the needed changes for date stamps and anything else
incompati
Can anyone narrow down what the problem might be:
The site I'm working on was built for access, I ported it to mysql after
making all the needed changes for date stamps and anything else
incompatible I have a new issue that seems to be random. When updating an
Item via the administration applic
You're welcome. :)
If you need it immediately, I would probably try and get more familiar with
the xml portion of this process for troubleshooting purposes. You may be
surprised, it may not be an issue with CF at all.
>>Sounds really odd -- I haven't seen or heard of any problems with 4 digit
>>y
>Sounds really odd -- I haven't seen or heard of any problems with 4 digit
>years in CF 5 ... I remember there being mention in the documentation for a
>previous version of CF ( I think it was the docs for 3.0 I was reading at
>the time ) that said a 2 digit year would be interpreted as 20xx if xx
if xx <= 30
and 19xx if xx > 30.
> Are there any date issues (particularly Y2K issues of all things) with CF5
> compared to CFMX?
> Here's the situation:
> We have an app which we will be porting over to CFMX. Our QA server is
> currently on CF5. We have a search scree
Are there any date issues (particularly Y2K issues of all things) with CF5 compared to
CFMX?
Here's the situation:
We have an app which we will be porting over to CFMX. Our QA server is currently on
CF5. We have a search screen that lists patients and their date of birth (among other
t
-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 09:36
To: CF-Talk
Subject: Help:Oracle Date Issues and Error Message.
-
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax
That was it.
The ' and ' around the CreateODBCDATETIME() Function.
When I took those out it worked.
I absolutely HATE syntax errors.
When one takes all the time to get the logic etc. of the statments correct
and a little comma or an apostrophe out of place screws you over!
Bah!
AI interpretive
t: RE: Help:Oracle Date Issues and Error Message.
You could try using the Oracle function TO_DATE()
instead of createOdbcDateTime().
Also, surely James Bond's EmplID should be 007 :-)
Nick
-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 2:36
You could try using the Oracle function TO_DATE()
instead of createOdbcDateTime().
Also, surely James Bond's EmplID should be 007 :-)
Nick
-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 2:36 PM
To: CF-Talk
Subject: Help:Oracle
L PROTECTED]>
Sent: Tuesday, January 16, 2001 9:35 AM
Subject: Help:Oracle Date Issues and Error Message.
> -
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC d
-
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00917: missing comma
SQL = "INSERT INTO
Empinfo_audit(EmplID,name,deptid,effdt,enddate,dayabs,reaso
19 matches
Mail list logo
