I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM. One of
the properties of my object is a start date. Everything inserts and updates to
the MySQL database without a problem. This issue that I am having is when I try
to perform any CF date functions on the stored date.
If
Nevermind. Stupid mistake. I was looping over a number of records and it turns
out that one of the records had a null value set which was what caused the
error. Had nothing to do with MySQL dates at all. Ugh.
I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM.
One of the
can you perform any date functions on it at all ?
Try running it through CreateDate() or CreateODBCDate() first and see if
that helps
On Sun, Jan 22, 2012 at 8:48 PM, Dean Lawrence dean...@gmail.com wrote:
I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM. One
of the
I love CF but dates are definitely my Achilles heel.
I've dumped qEvents.TheDate and its formatted like {ts '2011-06-07
00:00:00.0'}
I've dumped dayview and its formatted like {ts '2011-06-07 00:00:00'}
I would have thought that as time stamps CF would see these the same despite
the 0
Kevin,
Try this.
select *
from qEvents
where DateDiff(d, qEvents.TheDate, #dayview#) = 0
--
Russ Michaels
www.bluethunderinternet.com : Business hosting services solutions
www.cfmldeveloper.com: Free ColdFusion developer hosting
Quotes around #dayview# ?
cfquery name=ForToday dbtype=query
select *
from qEvents
where qEvents.TheDate = '#dayview#'
-Original Message-
From: Kevin Parker [mailto:tras...@internode.on.net]
Sent: 22 May 2011 03:16
To: cf-talk
Subject: Baffing date problem
I
-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Sunday, 22 May 2011 12:24
To: cf-talk
Subject: Re: Baffing date problem
Kevin,
Try this.
select *
from qEvents
where DateDiff(d, qEvents.TheDate, #dayview#) = 0
--
Russ Michaels
...@fasttrackonline.co.uk]
Sent: Sunday, 22 May 2011 12:33
To: cf-talk
Subject: RE: Baffing date problem
Quotes around #dayview# ?
cfquery name=ForToday dbtype=query
select *
from qEvents
where qEvents.TheDate = '#dayview#'
-Original Message-
From: Kevin Parker
...@internode.on.net]
Sent: Saturday, May 21, 2011 10:16 PM
To: cf-talk
Subject: Baffing date problem
I love CF but dates are definitely my Achilles heel.
I've dumped qEvents.TheDate and its formatted like {ts '2011-06-07
00:00:00.0'}
I've dumped dayview and its formatted like {ts '2011-06-07
you need to make the same format on both sides of the SQL where clause
so try:
cfset dayview = #createODBCDate(createdate(year, month, thisday))#
On 22/05/2011 12:15, Kevin Parker wrote:
I love CF but dates are definitely my Achilles heel.
I've dumped qEvents.TheDate and its formatted
527
++
http://au.linkedin.com/in/krparker
-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
Sent: Sunday, 22 May 2011 12:41
To: cf-talk
Subject: RE: Baffing date problem
First id try something like:
Where qEvents.theDate = cfqueryparam cfsqltype
Hi Calude, thanks for the relies, however the data is being transferred from ms
excel and sometimes comes in the EU format and sometimes in the US format. i
suppose the only way we can do this is to force the users to put it into eu
format and run it through your tag to see if it is a valid
But this is not really 100% proof, since some dates may be valid in US
format, although they were meant in EU format.
Take 10/11/2008 for instance.
So the date may be valid and still not be the good one.
To be 100% sure, you could consider a date pick up system.
hmmm very good point, thanks,
For instance: http://www.garrett.nildram.co.uk/calendar/scw.htm a javascript
which works nicely for me. Needs a couple of hours to figure it out.
-Original Message-
From: Azadi Saryev [mailto:[EMAIL PROTECTED]
Sent: Monday, January 28, 2008 10:41 AM
To: CF-Talk
Subject: Re: date
Richard White wrote:
But this is not really 100% proof, since some dates may be valid in US
format, although they were meant in EU format.
Take 10/11/2008 for instance.
So the date may be valid and still not be the good one.
To be 100% sure, you could consider a date pick up system.
date pick up system - is that a fancy way to say car? :-)
hmm.. come to think of it, date picker does not sound much better...
conjures images of some random number system...
hmm... maybe it's just me...
---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
Claude Schneegans wrote:
i
i believe Claude meant a date picker
That's it! Date picker! ;-)
You can pick your friends and you can pick your date, but you can't pick
your date's friends.
Bachelor number 2, if you were a fruit, what fruit would you be?
--
s. isaac dealey ^ new epoch
isn't it time for a
i believe Claude meant a date picker
That's it! Date picker! ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
Oohh, Oohh, Oooh, I know, I know
Dennis Rodman...
Bachelor number 2, if you were a fruit, what fruit would you be?
--
William E. Seiter
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
Web Developer
Oohh, Oohh, Oooh, I know, I know
Dennis Rodman...
Bachelor number 2, if you were a fruit, what fruit would you be?
Now that you mention it, the hair does make him look a bit fruity... in
a totally heterosexual way (Clerks II). Don't ask. My mind is a strange
place. :P
--
s. isaac
:) thanks again this is very straight forward and at the moment is solving our
problems. sometimes we dont know what format the user is going to pass the date
in so we first check with input mask US and if it says invalid date then we
pass in input mask EU and if it works then fine and if not
so we first check with input mask US and if it says invalid date then
we pass in input mask EU and if it works
Good point.
But this is not really 100% proof, since some dates may be valid in US
format, although they were meant in EU format.
Take 10/11/2008 for instance.
So the date may be
Hi Claude, i just bought this component, it seems fairly straight forward,
thanks very much this has been an ongoing issue for some time!!! will let you
know if i have any questions if you dont mind
thanks again for all your help claude
richard
thanks again for all your help claude
You're welcome, and congratulation for you wise shopping ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
07/24/1978 is an invalid date format
Ok, now I see what your problem is:
If you're using LSdateFormat, the function (and here is the difference
with dateFaormat)
expect a date. Since 07/24/1978 is not a date, but a string, CF will
try to convert it to a date,
but according the English (UK)
Hi claude,
thanks for this, i am starting to understand the problem now, i will however
take a look at your function as the lsdateformat is starting to give me
nightmares!!!
thanks claude
richard
~|
Adobe® ColdFusion® 8
= lsDateFormat(parseDateTime(d))
Format explicitly:
cfset dateDisplay = dateFormat(parseDateTime(d),dd/mm/)
Regards
Kevan
-Original Message-
From: Kevan Stannard [mailto:[EMAIL PROTECTED]
Sent: Saturday, 26 January 2008 2:28 PM
To: 'cf-talk@houseoffusion.com'
Subject: RE: date problem
Hi
/dd format
lsParseDateTime() can not handle dates in /mm/dd format, which is why
you get an error.
Kevan
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 January 2008 1:18 AM
To: CF-Talk
Subject: date problem
Hi,
i have been playing around
Hi,
none of these suggestions are working we have the set locale setup in the
application page, we have even tried to put it in the onrequest function
cfset SetLocale(English (UK))
then we are simply trying to run this following code to test it and it is not
working:
cfset dateV =
On Monday 21 Jan 2008, Azadi Saryev wrote:
if it is same for dateformat() and lsdateformat(), why would they return
different results then?
Because those functions do different things.
--
Tom Chiverton
Helping to seamlessly mesh real-time mindshares
on: http://thefalken.livejournal.com
thanks very much for your replies and discussions i will try this and see if it
works
thanks again
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
yes, obviously.
---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
Tom Chiverton wrote:
On Monday 21 Jan 2008, Azadi Saryev wrote:
if it is same for dateformat() and lsdateformat(), why would they return
different results then?
Because those functions do different things.
Hi,
i have been playing around with date formats for ages and still encountering
problems. i am in the uk and have set the following code when someone logs in:
cfset SetLocale(English (UK))
i have dates stored in a mysql db which is in the format /mm/dd
when i try to get data out of the
hi,
i have just tried it by using dateformat instead of lsdateformat and it worked
fine. i dont understand, does anyone know what the lsdateformat really does and
why the lsdateformat would now work but the dateformat did
thanks
i have just tried it by using dateformat instead of lsdateformat and
it worked fine.
Again, WHERE does is work, and WHERE doesn'it ?
If it is in an UPDATE or INSERT SQL statement, it may work, or not,
depending of the way CF will interpret the data as a date.
In SQL, you should always use
i have dates stored in a mysql db which is in the format /mm/dd
First of all, unless your date field has text type and you store the
date as a string, the db format is not /mm/dd.
It is some floating value specific to the database. Some early db
systems would store it as a string
Hi Claude,
we use mysql 5.0 and it does store the date as /mm/dd.
we run a query to get the date out.
then its just the following piece of code that doesnt work:
cfset dateOfBirth = lsdateformat(queryName.dateofbirth,dd/mm/)
it 'spits' out the error stated above 'invalid date format
then its just the following piece of code that doesnt work:
cfset dateOfBirth = lsdateformat(queryName.dateofbirth,dd/mm/)
it 'spits' out the error stated above 'invalid date format 01/16/1990'
it is saved in the db as 1990/01/16, im not telling it to put
it in the format
we use mysql 5.0 and it does store the date as /mm/dd.
This this actually how your database will *display* the date, but
internally, it is stored as a 3 bytes integer value.
(see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html )
But are you sure the field is defined as a
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 20, 2008 3:03 PM
To: CF-Talk
Subject: Re: date problem
But are you sure the field is defined as a *date* type, or as a string?
Anyway, CF should be able to recognize the format even
I think that the dateFormat() functions will consider any string
passed as a
numerical representation of the date unless it's quoted.
All CF function will take ANYTHING, strings, numerics or dates (which
are float values anyway),
if it can be converted to a date, CF will convert it prior
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 20, 2008 6:21 PM
To: CF-Talk
Subject: Re: date problem
I think that the dateFormat() functions will consider any string
passed as a
numerical representation of the date unless it's quoted
if it is same for dateformat() and lsdateformat(), why would they return
different results then?
---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
Jim Davis wrote:
This is what I was remembering - from the docs for lsdateformat and
dateformat:
When passing date/time value as a
So it definitely seems like CF treats the input differently somehow.
Not really.
CF is a typeless language.
It is SGML compliant and HTML compatible.
So by definition, EVERYTHING is passed as a string in attributes, even
if there is no quotation mark.
For function calls, it is a bit
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 20, 2008 10:48 PM
To: CF-Talk
Subject: Re: date problem
So it definitely seems like CF treats the input differently
somehow.
Not really.
CF is a typeless language.
It is SGML
so I assume it differs somehow.
Well, there is actually a difference:
If you pass the date as a date to dateformat(), ie:
dateFormat(now()...), there is no ambiguity.
It will always work.
However, if you pass it as a string, CF will have to convert it, and if
you work with dates in ISO format,
Donald,
Did you upgrade your database from MySQL4 to MySQL5 as part of your upgrade to
CF8?
If so, you might check your submitDate field in your tblRegistration and see if
the default still exists in the table (assuming you were using a default value
to set the current date in that table).
I am still using MySQL4 for the database.
Both tables are identical besides the table name.
When the data is inserted into the registration table, I use the current date
in ColdFusion to put into the SQL query.
When the user confirms their account, I pull their customer data by ID and
simply
Hello,
Recently I've noticed a weird problem.
During registration, I keep customer information in a registration (temporary)
table until they confirm their account via email.
Once the account is confirmed, I copy their data from the registration table
into the customer table.
The SQL is
ColdFusion will throw an error when if you supply -00-00 as the value
for any date functions, cfqueryparam, cfargument with a type of date, etc.
because -00-00 is not a valid date (neither is 02-30-2007).
HTH,
Aaron
P.S. I had this same problem and Sean Corfield alerted me to the fact
I'm not supplying -00-00 exactly.
The proper date shows up in the temporary table.
But when copied to the customer table through the above SQL statement, it
receives -00-00 (null).
~|
ColdFusion 8 - Build next
Is there any chance something like this can happen if a websites SSL security
certificate expires?
That is one thing that happened during the time this problem occurred.
But out of about 40 customer fields (two others were also even dates), that one
date field was the only one that kept
AJ Mercer wrote:
could there be a database trigger on the table that is manipulating the
date?
Nothing. It's a straight insert.
It *has* to be something related to the two different server locations,
but I'll be darned if I can figure it out.
For now, I'm just going to have to use DateAdd to
did you get an answer to this?
- Original Message
From: Les Mizzell [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, June 10, 2007 7:43:28 PM
Subject: Re: A Date Problem that's got me tearing out my hair!
I have worked with this all weekend, and can find no rhyme
Post the dates a day in advance.
Problem solved! ;]
Sorry, I know, I know... had to do it...
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
Les Mizzell wrote:
What in the hell could be causing this?
hard to diagnose w/out knowing what you're doing to the datetime objects but it
appears to be a simple tz issue. what tz is the Guernsey actually in? is the
Guernsey server a cf one? if so, are you manipulating the datetime on that
PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, June 10, 2007 9:39:03 PM
Subject: Re: A Date Problem that's got me tearing out my hair!
did you get an answer to this?
- Original Message
From: Les Mizzell [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday
[mailto:[EMAIL PROTECTED]
Sent: Sunday, June 10, 2007 10:43 PM
To: CF-Talk
Subject: Re: A Date Problem that's got me tearing out my hair!
I have worked with this all weekend, and can find no rhyme or reason at
all for what's happening here.
I enter into my forms:
start date: 6/1/2007
end date: 6/10
It sounds like maybe it's attempting to convert the time you entered to a
local time to the server.
That was my first thought. BUT - right now (8:40 AM) it's 6/11/2007 both
here and there. I've run test all hours and it happens regardless.
Still, this *has* to have something to do with it,
could there be a database trigger on the table that is manipulating the
date?
This has happened to me - and it was only on the production server, not test
and dev; that had me pulling my hair out!!
On 6/11/07, Les Mizzell [EMAIL PROTECTED] wrote:
It sounds like maybe it's attempting to
I have worked with this all weekend, and can find no rhyme or reason at
all for what's happening here.
I enter into my forms:
start date: 6/1/2007
end date: 6/10/2007
and what gets returned is:
start date: 5/31/2007
end date: 6/09/2007
I'm completely stumped!
What in the hell could be causing
I've got a site that's hosted in Guernsey (Island in English channel)
with a form with date input fields. Pretty darned simple.
input id=depDATE
name=depDATE
type=text
value=#dateformat(now(),'mm/dd/')# /
This form uses a web service to write to a MySQL database
Because now() is server time...
Very simple problem
On 6/9/07, Les Mizzell [EMAIL PROTECTED] wrote:
I've got a site that's hosted in Guernsey (Island in English channel)
with a form with date input fields. Pretty darned simple.
input id=depDATE
name=depDATE
type=text
Andrew Scott wrote:
Because now() is server time...
Not actually. The value DEFAULTS to now(), but anything can be entered
and it still ends on storing as 1 day earlier even when a different date
is entered.
What I *haven't* tested yet is to see if there's a particular hour that
this
Well if you debug this you might just see that as I said is true.
input id=depDATE
name=depDATE
type=text
value=#dateformat(now(),'mm/dd/')# /
If you always expect the default as mm/dd/yyy, and someone enters dd/mm/
you may end up with an invalid date, and your
If you always expect the default as mm/dd/yyy, and someone enters dd/mm/
you may end up with an invalid date, and your code might be trapping and
returning a default now(). There could be many reasons, for what is
happening.
I've got trapping that's being sure the date format is entered
I have an app that allows a user to enter certain dates about a candidate,
and not all dates are required. So, what is happening is, if someone enters
the Date Elected, and leaves the other two date fields blank, the date
1/1/1900 is entered by default. The form is a Flash Form and I am using the
you could use an imaginary date and cfparams on the page..
cfparam name=DateElected default=#dateformat('01/01/','mm/dd/')#/
but it looks like your dateformat() and passing null values to it is
causing the issue..
this way, you pass an imaginary date to the database..
unless you really
Bruce,
I would break down the date. Allowing the user to enter 11/11/2007 is
asking for a lot of validation.
You probably should have a month, day and year input field for each date
range. This makes it easier to validate.
1/1/1900 is a behavior of SQL Server smalldate field when you send it
That is what I want, nulls. If no date is selected, then I do not want
anything there.
Bruce Sorge
I'm a mawg: half man, half dog. I'm my own best friend!
On 1/24/07, Greg Morphis [EMAIL PROTECTED] wrote:
you could use an imaginary date and cfparams on the page..
cfparam name=DateElected
That is what I want, nulls. If no date is selected, then I do not want
anything there.
I would suggest using the CFQUERYPARAM tag and using its NULL attribute.
If not that then you will be forced to do a CFIF myDate eq
''NULLcfelse#myDate#/cfif
Rich Kroll
I am not allowing the user to manually input the date. I am using the
CFINPUT Type=DateField which creates a flash calendar, the user clicks on
the date and voila! Date is entered. Problem is that if any of the others
are not filled out, my database fields are getting populated with 1/1/1900
Yeah, guess I am gonna have to use the CFIF option. SP's are not allowed on
the DB2 server for the city. We are getting our own SQL Server and CF Server
soon though, so I get to re-write the app using SP's.
Bruce
On 1/24/07, Richard Kroll [EMAIL PROTECTED] wrote:
That is what I want, nulls.
yeah definitely use cfqueryparams when in your query..
cfqueryparam cfsqltype=cf_sql_date value=#form.foodate# null=yes /
On 1/24/07, Richard Kroll [EMAIL PROTECTED] wrote:
That is what I want, nulls. If no date is selected, then I do not want
anything there.
I would suggest using the
Based on the query you provided:
UPDATE tblCouncilMember
SET Fname = '#Arguments.Fname#',
Lname = '#Arguments.Lname#',
Address = '#Arguments.Address#',
City = '#Arguments.City#',
Yeah, guess I am gonna have to use the CFIF option. SP's are not
allowed
on
the DB2 server for the city. We are getting our own SQL Server and CF
Server
soon though, so I get to re-write the app using SP's.
As I understand it, using the CFQUERYPARAM tag is on the ColdFusion side
and simply
OK, I in the Update query in the CFC, I just did this:
cfif LEN(Arguments.DateElected)
DateElected = '#Arguments.DateElected#'
/cfif
and so on. Worked like a champ. I was just hoping there was another way, or
better yet, a good explanation why this was happening.
Bruce
OH. I guess I misunderstood the use of CFQUERYPARAM. I only use it on SP's.
Bruce
On 1/24/07, Richard Kroll [EMAIL PROTECTED] wrote:
Yeah, guess I am gonna have to use the CFIF option. SP's are not
allowed
on
the DB2 server for the city. We are getting our own SQL Server and CF
Server
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: 04 January 2007 20:14
To: CF-Talk
Subject: Interesting Date Problem
Form field requesting a birth date.
Person enters 1/22/45
Coldfusion returns 1/22/2045
How can I insure it returns 1/22/1945 without forcing
Form field requesting a birth date.
Person enters 1/22/45
Coldfusion returns 1/22/2045
How can I insure it returns 1/22/1945 without forcing the year entry
as four digits- 1/22/1945 vs. 1/22/45
~|
Create robust enterprise,
at http://www.reedexpo.com
-Original Message-
From: Les Mizzell
To: CF-Talk
Sent: Thu Jan 04 20:13:42 2007
Subject: Interesting Date Problem
Form field requesting a birth date.
Person enters 1/22/45
Coldfusion returns 1/22/2045
How can I insure it returns 1/22/1945 without forcing the year
gonna need more to go on, i think.
using CFMX 7, the following code outputs 1945:
cfoutput#createDate(45, 1, 22)#/cfoutput
On 1/4/07, Les Mizzell [EMAIL PROTECTED] wrote:
Form field requesting a birth date.
Person enters 1/22/45
Coldfusion returns 1/22/2045
How can I insure it returns
Les Mizzell wrote:
Form field requesting a birth date.
Person enters 1/22/45
Coldfusion returns 1/22/2045
How can I insure it returns 1/22/1945 without forcing the year entry
as four digits- 1/22/1945 vs. 1/22/45
And if they enter 1/22/05, does that mean 1905 or 2005? I would force
Les, wht not break it up? Use three separate pulldowns (month, day year)
and then combine the values before you write the data to the db.
~Che
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 04, 2007 3:14 PM
To: CF-Talk
Subject: Interesting Date
off-hand I'd say use DateFormat with a mask that included so that
the year will be taken as a 4 digit year. But without seeing your code
that is giving you trouble, I can't guarantee that this will work. It
could be what you're already doing! :o)
Post some code, that might help.
Cheers,
I have to agree with Jim here. Folks need to join the 21st century with
the rest of the world. Get used to *always* entering the full four-digit
year in a date field. Saving two keystrokes just doesn't make sense...
and assumptions about data *are* bad. :o'
Cheers,
Chris
Jim Wright wrote:
: Thursday, January 04, 2007 12:14 PM
To: CF-Talk
Subject: Interesting Date Problem
Form field requesting a birth date.
Person enters 1/22/45
Coldfusion returns 1/22/2045
How can I insure it returns 1/22/1945 without forcing the year entry
as four digits- 1/22/1945 vs. 1/22/45
Thanks !
it works great and it's much simpler than my artisanal trick :)
On Thu, 27 Jan 2005 19:18:43 -0400, Larry White [EMAIL PROTECTED] wrote:
Use This:
cfset ModDate = lundi 17 janvier 2005 10 h 53 CET
cfset x = SetLocale(French (Standard))
cfset faqdate=
Use This:
cfset ModDate = lundi 17 janvier 2005 10 h 53 CET
cfset x = SetLocale(French (Standard))
cfset faqdate= DateFormat(LsParseDAteTime(ModDate),dd/mm/)
cfoutput#faqdate#/cfoutput
Hi everyone,
I'm upgrading a site from Coldfusion 5 to MX but I have a date bug.
In Coldfusion 5, I got
Hi everyone,
I'm upgrading a site from Coldfusion 5 to MX but I have a date bug.
In Coldfusion 5, I got the last modified date of a file and converted
it with DateFormat like this :
cfset faqPath = GetTemplatepath()
cfset faqPath = left(faqPath,len(faqPath)-9) wel\
cfdirectory
I'm trying to convert this date/time info from the filed #datetime#: 20031201 03:38 PM into something CF can display correctly.
I'm using CreateDate for 20031201. How do I also get the time 03:38 PM separated?
In other words I would like to have the #DateFormat((Datetime), mmm-dd-)# display
:32 AM
To: CF-Talk
Subject: Create date problem
I'm trying to convert this date/time info from the filed #datetime#:
20031201 03:38 PM into something CF can display correctly.
I'm using CreateDate for 20031201. How do I also get the time 03:38
PM separated?
In other words I would like to have
of this function
in previous versions of CF.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 9:32 AM
To: CF-Talk
Subject: Create date problem
I'm trying to convert this date/time info from the filed #datetime#:
20031201 03:38 PM into something
Robert,
On 12/2/2003 at 09:32, you wrote:
RO I'm trying to convert this date/time info from the filed
RO #datetime#: 20031201 03:38 PM into something CF can display
RO correctly. I'm using CreateDate for 20031201. How do I also get
RO the time 03:38 PM separated? In other words I would like to
Ryan,
Worked like a charm. Thanks and thanks to the others for the input as well.
Robert O.
-Original Message-
From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 9:51 AM
To: CF-Talk
Subject: RE: Create date problem
Try this:
cfset
yes...use the Oracle to_date() around your dates. Also, try using cfqueryparam, it
can handle the date conversions automagically.
Doug
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 9:54 PM
To: CF-Talk
Subject: Re: Date problem
Ah, Oracle - you have to love it! More and more corporations it seems are
using this DBMS!
For good reason - it is very capable.
From a development point of view, especially with a frequently absent
database administrator in between, it can be a nightmare.
Why you are using this:
ChgDate =
Tilbrook [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 9:29 AM
Subject: RE: Date problem with CFMX and Oracle
Ah, Oracle - you have to love it! More and more corporations it seems are
using this DBMS!
For good reason - it is very capable.
From a development
I am trying to do an update to my DB:
UPDATE BookInventory
SET Status = 'Checked Out',
CheckedTo = 'rayb',
ChgDate = {ts '2003-09-16 16:08:22'}
WHERE id = 2043
This worked fine before, I updated my CFMX server to 6.01 and my JDBC
drivers to 1.4, and am now getting column doesn't
Mm..is Status a reserved word?
-Gel
-Original Message-
From: Ray Bujarski [mailto:[EMAIL PROTECTED]
I am trying to do an update to my DB:
UPDATE BookInventory
SET Status = 'Checked Out',
CheckedTo = 'rayb',
ChgDate = {ts '2003-09-16 16:08:22'}
WHERE id = 2043
This worked
1 - 100 of 129 matches
Mail list logo
