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 date
> 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.
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
http://William.Seiter.
> >>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
"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 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.
~
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 syste
>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, thank
>>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 "va
:) 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 th
>>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])
Tha
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
explicitly:
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 Richard
We deal with the same issue here in Australia.
You may have the problem sorted
Hi Richard
We deal with the same issue here in Australia.
You may have the problem sorted out by now, but you may like to have a look
at some notes I put down a little while ago on this.
http://stannard.net.au/blog/index.cfm/2006/10/25/Date-Objects-vs-Date-String
s-in-ColdFusion
Just an extra c
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 soft
>>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,
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
then we are simply trying to run this following code to test it and it is not
working:
the error is:
07/24/1978 is an invalid date format
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
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
http://ad.doubleclick.
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
>>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
> -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 reall
>>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 diffe
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 s
> -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
>>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 pass
> -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 a
>>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
> then its just the following piece of code that doesnt work:
>
>
>
> 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 01/16/1990, i am telling it to put it in the
> format 16/01/1990
>
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:
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
>>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 Cre
>>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,
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
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
> 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 simp
Based on the query you provided:
UPDATE tblCouncilMember
SET Fname = '#Arguments.Fname#',
Lname = '#Arguments.Lname#',
Address = '#Arguments.Address#',
City = '#Arguments.City#',
yeah definitely use
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 CFQUERYPARAM tag and using its NULL attribute.
> If not that then you will be forced to do a ''>
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, null
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
automa
> 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 NULL#myDate#
Rich Kroll
~~~
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 s on the page..
> default="#dateformat('01/01
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 an
you could use an imaginary date and s on the page..
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 want nulls, then you couldnt use the dateformat there..
On 1/24/07, Bruce Sorge <
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:
>
>
>
>
> #faqdate#
>
>
> >Hi everyone,
> >
> >I'm upgrading a site from Coldfusion 5 to MX but I have a date bug.
> >In Coldfusio
Use This:
#faqdate#
>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 :
>
>
>
>filter="dspFaq.cfm">
>
>
>
>My faqDate.DatelastMod
Original Message -
From: "Peter 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 seem
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 =
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: R
> 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 doe
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject:RE: Date problem with CFMX and Oracle
Try prefixing your query element with the schema name.
CC
This is a PRIVATE
.
"Ray Bujarski"
09/16/2003 04:19 PM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: RE: Date problem with CFMX and Oracle
As mentioned before, I never had a problem b4 I upgraded. But
As mentioned before, I never had a problem b4 I upgraded. But also, my
editor doesn't highlight it as it does other reserved words.
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 4:17 PM
To: CF-Talk
Subject: RE: Date problem with
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 f
Thanks for the replies/suggestions everyone. I think I'm gonna go with the
3-fields setup for now.
Neil
- Original Message -
From: "Jennifer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 11:42 AM
Subject:
;Katrina Chapman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 6:26 AM
Subject: RE: Date problem
> Since you're using European dates I would suggest breaking up the date
> field.
>
> IE:
>
>
>
&
Since you're using European dates I would suggest breaking up the date
field.
IE:
Then you can reformat it for output to the screen at a later time.
If you do it this way you won't have to worry about what order the people
enter the data because it will always be the
I think the proper approach to this problem would be to provide an example of the
proper date format next to the input field, perhaps even pre-popluating the field with
today's date in the proper format.
Then on the page it submits to, use the IsDate() function to determine whether the
date is
esday, January 17, 2001 11:42 AM
Subject: Re: Date problem
| At 03:26 PM 1/17/01 +, you wrote:
|
| >Apologies if this has already been covered. I'm having a general problem
| >with date formats, specifically if a form field is submitted with a
2-digit
| >year then the subsequent tem
At 03:26 PM 1/17/01 +, you wrote:
>Apologies if this has already been covered. I'm having a general problem
>with date formats, specifically if a form field is submitted with a 2-digit
>year then the subsequent template receives it with the day and year digits
>switched round.
>
>ie 17/01/01
60 matches
Mail list logo