Looks like you might need to revise the procedure to CAST the calculated
value back to Numeric(10,2) before returning it?
Carl
On 2/16/2011 2:30 PM, James Skemp wrote:
> Thanks Mike.
>
> Opened up the procedure and gave it a look. It looks like there's some
> multiplication and division going on, which is resulting in a change.
> Relevant part for one of the returned values:
>
> MemberPrice =
> (case when qp.productid is null then p.MemberPrice
> else
> case when qp.MemberPrice is null then
> p.MemberPrice*((100-qp.memberdiscountpercent)/100)
> else qp.MemberPrice
> end
> end)
>
> Running this query on ColdFusion 7.('current') against MS SQL returns (again,
> cfdump of the cfquery, and the same thing as SQL Studio returns):
>
> 0.00000000
>
> On CF 8, we instead get:
>
> 0E-8
>
> So, updated CF 8 SQL Driver perhaps? Either way, unless there's an
> Administrator change, this does mean we'll have to evaluate code since, right
> or wrong, CF 7 doesn't make this change.
>
> Thanks!
>
> ~James
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342350
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
