list of numbers into a date, even though I wanted it as a string! I
found it was when I did multiple QofQs. I was able to reduce the number
of QofQs by changing some of the initial SQL code and it went away.
how annoying!
---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts
Tim Blair wrote:
> > I had the same problem. It appears that even though CF
> > variables are untyped, the underlying java expects properly
> > formatted dates (java is a strongly typed language).
>
> Yes, all java vars need to be typed, but it seems strange that CF seems
> to think that the string is a date, tries converting it and fails.
>
> > You can use the ParseDateTime() function to convert your date
> > into a timestamp.
>
> Unfortunately the problem was that I *didn't* want it to be a date, just
> a string that happened to be formatted to look like a date...
>
> Ho hum, I got around the problem, but it just seems strange that the
> problem should occur on one installation and not others... :o\
>
> Tim.
>
> -------------------------------------------------------
> Try the ColdFusion Coding Contest! Current contest:
> Maze Solver - http://tech.badpen.com/cfcontest/
> -------------------------------------------------------
> RAWNET LTD - Internet, New Media and ebusiness Gurus.
> WE'VE MOVED - for our new address, please visit our
> website at http://www.rawnet.com/ or call us any time
> on 0800 294 24 24.
> -------------------------------------------------------
> This message may contain information which is legally
> privileged and/or confidential. If you are not the
> intended recipient, you are hereby notified that any
> unauthorised disclosure, copying, distribution or use
> of this information is strictly prohibited. Such
> notification notwithstanding, any comments, opinions,
> information or conclusions expressed in this message
> are those of the originator, not of rawnet limited,
> unless otherwise explicitly and independently indicated
> by an authorised representative of rawnet limited.
> -------------------------------------------------------
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
