Good point. I removed the dollarformat and now have: SET Costeach = #form.Costeach# and I get this error:
ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '$0.00' Do I need a Trim function beforhand? Robert O. -----Original Message----- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:30 AM To: CF-Talk Subject: Re: update a dollarformat field I think you don't need DollarFormat when updating only when displaying ie <cfquery name="update" datasource="purchases"> UPDATE purchases SET Costeach = #Costeach# .. Seamus At 10:09 pm 24/05/2002 , you wrote: >Hello, > >I must be missing some kind of syntax. Anyone can help please? > >I'm getting the error below when I do this update: > ><cfquery name="update" datasource="purchases"> >UPDATE purchases SET Costeach = #Dollarformat(Costeach)# > >on a field that is dollar formatted as: ><input type="text" name="costeach" value="#Dollarformat(getpo.costeach)#" > >The error is: >"An error occurred while evaluating the expression: #Dollarformat(Costeach)# >Parameter 1 of function DollarFormat which is now "$300.00" must be a number >The error occurred while processing an element with a general identifier >of (#Dollarformat(Costeach)#),..." > >Thanks, > >Robert Orlini > ______________________________________________________________________ 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
