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 t
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 co
> 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,
rom: Les Mizzell [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.
>
>
AIL PROTECTED]>
To: CF-Talk
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
Sent: Sunday, June 10, 2007 7:43:28 PM
Su
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
se
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
http://www.adobe.com/products/cold
did you get an answer to this?
- Original Message
From: Les Mizzell <[EMAIL PROTECTED]>
To: CF-Talk
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 or reason
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
> 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 entere
Well if you debug this you might just see that as I said is true.
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.
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 happens
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.
>
> name="depDATE"
> type="text"
>
I've got a site that's hosted in Guernsey (Island in English channel)
with a form with date input fields. Pretty darned simple.
This form uses a web service to write to a MySQL database in the US.
Also pretty simple:
One the Guernsey side:
On the US side:
14 matches
Mail list logo