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 > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
