Thanks. Dumb ol' me never looked to see that convert() wasn't a CF command.
Worked like a charm. Thanks.
===================
Joel Firestone - Developer
Delmarva Online
http://www.dmv.com/
"Philip Arnold - ASP" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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.
------------------------------------------------------------------------------
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.
