>>>Kelly is right with the cftry and cfcatch. If you change your query like this it should correct your bug I am thinking because when you write a query the database field has to be on the left. TSQL doesnt know what a session variable is.
MSSQL doesn't care if the field is on the left or the right, it's just running a comparison against the statement. It also has no idea that it was a session variable, by the time it gets to the SQL Server, ColdFusion has parsed it out into a SQL string, and that's all that gets passed into the database. -- Alan Rother Manager, Phoenix Cold Fusion User Group, www.AZCFUG.org Twitter: @AlanRother ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:341395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
