Venable, John wrote: > Maybe someone can tell me what I'm doing wrong. I have a field in SQL Server > 2K that is money datatype. I am building a submission form to populate that > field and I keep getting errors about type. This is what my field insert > looks like: > > <cfif > len(trim(form.HourlyWage))>'#trim(numberFormat(form.HourlyWage,"999.99"))#'< > cfelse>NULL</cfif> > > Which throws this error: > > Disallowed implicit conversion from data type varchar to data type money, > table 'JobTech.dbo.Enrollments', column 'HourlyWage'. Use the CONVERT > function to run this query.
<cfqueryparam cfsqltype="cf_sql_money" ....> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
