least they should listen. Use TO_DATE(). Let's say the date comes in a
dd/mm/yyyy format:
DON'T reformat it and when you insert it do
TO_DATE('#thedate#','DD/MM/YYYY'). Do that in ALL your queries (not just
UPDATE but also INSERT). And PLEASE USE CFQUERYPARAM. (I didn't type it
in the example because I'm tired of typing it)
The actual error is that you format it as a US date and Oracle is
expecting a European date.
Pascal
> -----Original Message-----
> From: Ian Vaughan [mailto:[EMAIL PROTECTED]
> Sent: woensdag 16 juni 2004 10:55
> To: CF-Talk
> Subject: RE: CF Dates with MX 6.1 ?
>
> Still Recieving the error
>
> Error Occurred While Processing Request
>
> Error Executing Database Query.
>
> [Macromedia][Oracle JDBC Driver][Oracle]ORA-01843: not a valid month
>
> The error occurred in C:\Inetpub\wwwroot\CFIDE\PollPopup.cfm: line 130
>
> 128 : '#DNAME#',
> 129 : '#ENAME#',
> 130 : '#ARCHIVE#' )
> 131 : </cfquery>
> 132 :
> ________________________________
>
> SQL INSERT INTO POLL (POLL_ID, AUTHOR, STARTDATE, ENDDATE,
> ACTIVE, POLLTYPE, QUESTION, ANAME, BNAME, CNAME, DNAME,
> ENAME, ARCHIVE ) VALUES ('england04', '121.100.25.2',
> '06-15-2004', '06-25-2004', 'yes',
> 'Y', 'Will this poll work ?', '', '', '', '', '', 'NO' )
> DATASOURCE poll
> VENDORERRORCODE 1843
> SQLSTATE HY000
> Please try the following:
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
