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 template receives it with the day and year digits >switched round. > >ie 17/01/01

Re: Date problem

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

RE: Date problem

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

RE: Date problem

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

Re: Date problem

;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: > > > &

Re: Date problem

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:

Re: Date Problem

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 <

Re: Date Problem

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

Re: Date Problem

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

RE: Date Problem

> 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 ~~~

Re: Date Problem

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

Re: Date Problem

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

Re: Date Problem

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 ''>

RE: Date Problem

Based on the query you provided: UPDATE tblCouncilMember SET Fname = '#Arguments.Fname#', Lname = '#Arguments.Lname#', Address = '#Arguments.Address#', City = '#Arguments.City#',

RE: Date Problem

> 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

Re: Date Problem

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

Re: date problem

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

Re: date problem

>>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

Re: date problem

>>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

Re: date problem

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

RE: date problem

> 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 >

Re: date problem

>>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

RE: date problem

> -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

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. 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

RE: date problem

> -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

Re: date problem

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

Re: date problem

>>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

RE: date problem

> -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

Re: date problem

>>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

Re: date problem

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

Re: date problem

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.

Re: date problem

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

Re: date problem

>>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)

Re: date problem

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

RE: date problem

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

RE: date problem

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

Re: date problem

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

Re: date problem

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

Re: date problem

>>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

Re: date problem

:) 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

Re: date problem

>>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

Re: date problem

>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

RE: date problem

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

Re: date problem

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

Re: date problem

"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: >

Re: date problem

> >>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

Re: date problem

>>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. ~

RE: date problem

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.

Re: date problem

> 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.

Re: date problem

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

RE: Date problem with CFMX and Oracle

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

RE: Date problem with CFMX and Oracle

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

RE: Date problem with CFMX and Oracle

. "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

RE: Date problem with CFMX and Oracle

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

Re: Date problem with CFMX and Oracle

> 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

RE: Date problem with CFMX and Oracle

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

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 point of view, especially with a frequently absent database administrator in between, it can be a nightmare. Why you are using this: ChgDate =

Re: Date problem with CFMX and Oracle

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

Re: Date problem between Coldfusion 5 and MX

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

Re: Date problem between Coldfusion 5 and MX

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