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
