You may want to check the data type, when whomever updated the database may
have defaulted the suite column to varchar or other text.
> 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:351919
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
