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 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#',
'#l_name#',
'#address_1#',
'#address_2#',
'#city#',
'#state#',
'#zip_code#',
'#phone_1#',
#ext_1#,
'#phone_2#',
#ext_2#
'#dateFormat(date, "mm/dd/yyyy")#' )
</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 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 make sure you're using/not
> using single 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 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/yyyy")#">
>
>
> INSERT
>
> #dateAdd( "d", "0", "#lastModified#" )#
>
>
>
> <CF_SIGNATURE
> NAME="Douglas L. Brown"
> EMAIL="[EMAIL PROTECTED]"
> PHONE="714.538.6611"
> WEB="http://www.carnivorepc.com";>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
