Bad data. You have at least one data record with a value that is either null or not an integer.
On Tue, Apr 19, 2011 at 10:04 PM, Richard Steele <[email protected]> wrote: > > Ok, I have a page that loads most of the time. However, occasionally it gives > an error: > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested > type. > > In verbose debugging the query that fails should be no problem whatsoever and > in fact in runs fine in SQL but only 70% of the time when the page is > refreshed. > > We are on CF8 Enterprise with two instances. > > What could be happening? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:343860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
