This simple query works fine on MS 2005 database but fails on an MS 2008 server:
1. First test:

select suite from house_final_drawings where suite in (100,200)


Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the nvarchar value 'dddd' to data type int.

2. Second Test:
If single quotes are put around the 'IN' list items the query works on SQL 2008.


select suite from house_final_drawings where suite in ('100','200')



Any ideas why this behavior change in SQL 2008? The querys both work when run directly in SQL Studio.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:351918
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm