Can you give us your entire SQL Statement? Are ContactName and OrderID supposed to both where clauses?
-----Original Message----- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: Monday, April 24, 2006 3:02 PM To: CF-Newbie Subject: Re: Converting a session var to a number That was there because was using a function I failed to remove them when I copied the code you It is: ContactName = '#ContactName#' WHERE OrderID = #session.OrderId# >Why do you have () around your variable? > >Mike > >-----Original Message----- >From: Torrent Girl [mailto:[EMAIL PROTECTED] >Sent: Monday, April 24, 2006 1:50 PM >To: CF-Newbie >Subject: Re: Converting a session var to a number > >ContactName = '#ContactName#' >WHERE OrderID = #(session.OrderId)# > > > >The OrderId field is a NUMBER field in Oracle. > > > > > > >5 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1805 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
