It was probably highlighting the last line in the SQL statement. Ah well, you live and learn.
Adrian -----Original Message----- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: 24 April 2006 20:33 To: CF-Newbie Subject: Re: Converting a session var to a number I got it to work it was another field WHY DOES CF DO THAT????? It will highlight a non-related field if there is an error >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# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1808 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
