Hi Dominic, Dominic Watson wrote:
>>An empty string is not a number. You need to default it to 1 or do a >>conditional check and only perform the multiplication if the value is >>numeric. >> >> > > >Or, if you want LineShip to be zero when shipBase is NULL, then using Val() >should work: > ><cfset LineShip = Session.Basket.Quantity * Val(Product.ShipBase)> > > Looked at the admin section and this field -is- required. But obviously it isn't in the database itself, and a number of values are null, so I've modified the cfset per your suggestion. Thanks much!! --Ben +-------------------------------------------+ + Ben Conner [EMAIL PROTECTED] + + Web World, Inc. 888-206-6486 + + PO Box 1122 480-704-2000 + + Queen Creek, AZ 85242 + +-------------------------------------------+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303519 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
