I am trying to update a table that has a field on it that in the table is set to (money), but when I go to update the table, I receive this error:
ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near '110.00'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:54). Date/Time: 08/26/02 12:07:20 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 10.30.20.25 HTTP Referrer: http://dailynews/DAC/new/Edit.cfm?ID=144 The value '110.00' is what the user would be entering into that field. Below is my cfquery that updates the table. I noticed in the CF5 app book by Forta that you have to use CONVERT to make this work, however, I can't seem to find any sample code stating how to use it the way I need it to be done. Can anyone help me with this? <cfquery datasource="FirmDaily" name="UpdateDACTable"> update DAC set BillingInitials = '#BillingInitials#', StandardRate = CONVERT(#StandardRate#, MONEY), OMRate = CONVERT(#OMRate#, MONEY) where ID = '#ID#' </cfquery> Thanks, Aimee Clark Web Developer Stinson Morrison Hecker LLP [EMAIL PROTECTED] ______________________________________________________________________ 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
