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
