> Everyone:
>
> I recently upsized an Access db to SQL 7. I'm having extreme frustrations
> trying to write to a money column. My code is:
>
> update ShipCost set productCost_beginRange = #convert(money,
> form.productCost_beginRange)#,
> productCost_endRange = #convert(money,
> form.productCost_endRange)#,
> shipCost = #convert(money, form.shipCost)#
> where shipOptID = #form.shipOptID#
>
> I have tried (I believe) every possible way to do it, with no success. The
> error I
> get is:
>
> Error resolving parameter MONEY
>
> Cold Fusion was unable to determine the value of the parameter.
> This problem
> is very
> likely due to the fact that either:
>
> 1. You have misspelled the parameter name, or
> 2. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or
> CFTABLE tag.
>
> What do I need to do in order to update a money field? Any help would be
> GREATLY appreciated.
OK, here's what you do, you let SQL Server convert it for you, not
ColdFusion
update ShipCost
set productCost_beginRange=convert(money,#form.productCost_beginRange#),
productCost_endRange=convert(money,#form.productCost_endRange#),
shipCost=convert(money,#form.shipCost#)
where shipOptID = #form.shipOptID#
this does 2 things;
1, takes a bit (very tiny, but still a bit) of strain off of CF,
2, lets SQL Server deal with everything in one go, which it'll do without
really noticing.
Oh, and Convert is a SQL Server command, and not a CF command, so it
wouldn't really work anyway
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
