ContactName = '#ContactName#' WHERE OrderID = #(session.OrderId)#
The OrderId field is a NUMBER field in Oracle. >Could you post some code? > >It shouldn't matter that you're referencing the number like this "234" in >CF. > >Adrian > >-----Original Message----- >From: Torrent Girl [mailto:[EMAIL PROTECTED] >Sent: 24 April 2006 18:30 >To: CF-Newbie >Subject: Converting a session var to a number > > >Hello All > >I have a session var that needs to be inserted in a NUMERIC field (Oracle) > >The var is a number but I am getting the following error: > >Error Executing Database Query. >ORA-01722: invalid number > > > > >I've tried using LSParseNumber >(http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functa38.htm#wp11095 >42) > >but that doesn't help. > > >What is the best way to convert a numeric string into a true number? > >Or is that possible. > >Thanks > >TGirl ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
