date time problem

I have a form with a hidden field like below, and I keep getting an error when tring to insert cfset date = Now() input type=hidden NAME=lastModified VALUE=#dateFormat(date, mm/dd/)# INSERT #dateAdd(d, 0, #lastModified#)# CF_SIGNATURE NAME=Douglas L. Brown

Re: date time problem

quotes properly. Hope this helps Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message - From: Douglas L. Brown To: CF-Talk Sent: Friday, November 09, 2001 12:45 PM Subject: date time problem I have a form

Re: date time problem

, 2001 11:05 AM Subject: Re: date time problem It looks like that you are adding no days to lastmodified which should be the same as lastModified. So I would simply insert lastModified. If it's a datatype mismatch (i.e. you're inserting a string into and datetime field, or vice versa) then just

RE: date time problem

Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 1:46 PM To: CF-Talk Subject: date time problem I have a form with a hidden field like below, and I keep getting an error when tring to insert cfset date = Now() input type=hidden NAME=lastModified VALUE

Re: date time problem

Dont workColdfusion error Invalid parser construct mm Doug - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 09, 2001 11:17 AM Subject: RE: date time problem try doubling your quotes. since you're populating

Re: date time problem

-Talk Sent: Friday, November 09, 2001 12:45 PM Subject: date time problem I have a form with a hidden field like below, and I keep getting an error when tring to insert cfset date = Now() input type=hidden NAME=lastModified VALUE=#dateFormat(date, mm/dd/)# INSERT

Re: date time problem

AM Subject: Re: date time problem Have you considered forgoing passing that variable via the form and just put #dateFormat(date, mm/dd/)# in the insert statement? Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message

Re: date time problem

couldn't do more. Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message - From: Douglas L. Brown To: CF-Talk Sent: Friday, November 09, 2001 1:48 PM Subject: Re: date time problem Dude I am going to lose it! I still

Re: date time problem

#', #ext_2# '#dateFormat(date, mm/dd/)#' ) /CFQUERY - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 09, 2001 11:05 AM Subject: Re: date time problem It looks like that you are adding no days to lastmodified

RE: date time problem

AM Subject: Re: date time problem Have you considered forgoing passing that variable via the form and just put #dateFormat(date, mm/dd/)# in the insert statement? Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message

RE: date time problem

:33 AM Subject: Re: date time problem Have you considered forgoing passing that variable via the form and just put #dateFormat(date, mm/dd/)# in the insert statement? Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original

RE: date time problem

#', #ext_2# '#dateFormat(date, mm/dd/)#' ) /CFQUERY - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 09, 2001 11:05 AM Subject: Re: date time problem It looks like that you are adding no days

Re: date time problem

missing comma after #ext_2# Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message - From: Douglas L. Brown To: CF-Talk Sent: Friday, November 09, 2001 1:53 PM Subject: Re: date time problem Here is the whole

RE: date time problem

: date time problem Here is the whole insert query, I tried it with and without the single quotes. CFSET date = Now() CFQUERY DATASOURCE=#application.dsn# NAME=new_cust_insert INSERT INTO customer VALUES ( '#custNum#', '#f_name

Re: date time problem

:48 AM Subject: RE: date time problem You are missing a damn COMMA after '#ext_2#' , '#dateformat(date, mm/dd/)#' See how simple it is to do when you post the entire line of code? -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09

Re: date time problem

: date time problem Well it fixed that problem, but now it is a right truncation error. Shit!!! The little problems are the ones that drive me the most nuts CF_RUBBERROOM Doug - Original Message - From: Adkins, Randy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED

Re: date time problem

[EMAIL PROTECTED] Sent: Friday, November 09, 2001 11:55 AM Subject: RE: date time problem Erm, have you tried using #CreateODBCDate(dateformat)#? C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] -Original Message- From: Douglas L. Brown

RE: date time problem

time problem Same thing, right truncation. Funny thing is I have form I use for updating the same table, and everything works great. The code is identical except for it's an update and not a insert. hmm ~~ Get the mailserver

Re: date time problem

-5211 x-134 - Original Message - From: Douglas L. Brown To: CF-Talk Sent: Friday, November 09, 2001 1:53 PM Subject: Re: date time problem Here is the whole insert query, I tried it with and without the single quotes. CFSET date = Now() CFQUERY DATASOURCE

RE: date time problem

Hi there, Would using CFQUERYPARAM in your query, and setting the SQL Type to Date help? I've had this problem with queries before in WHERE clauses. In Oracle I would have suggested using the Oracle ToDate() function. Otherwise CreateODBCDateTime() usually takes care of these issues with

Re: date time problem

If you tell your database to default the field to Now() then it will be updated whenever a new record is inserted - OR when an existing record is updated, so long as you include the field name in your CFUPDATE or CFQUERY. ~~ Structure your

Re: date time problem

PM Subject: Re: date time problem If you tell your database to default the field to Now() then it will be updated whenever a new record is inserted - OR when an existing record is updated, so long as you include the field name in your CFUPDATE or CFQUERY