do you have the dollar sign in the form? Try putting just the amount in the form - no dollar signs and see what happens
Seamus At 10:36 pm 24/05/2002 , you wrote: >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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists