On 10/2/07, Mike Little <[EMAIL PROTECTED]> wrote: > > hi guys, > > having a wee problem. am simply adding a new column > 'product_image_large_5' to an existing product table. > > > > when i add the column, and run our products query we get the following > error... > > [Macromedia][SQLServer JDBC Driver]Unsupported data conversion. > > am really lost as all i seem to have added is the new column??? > > mike
You are selecting * from the database table. When you made that change coldfusion didn't pick up on it It's cached somewhere. Ray Camden posted something about this somewhere and I tried it the other day, not sure if it was a fluke but seemed to work. end your query with a ";" <cfquery> select * from table where id = id; </cfquery> Granted you want your normal cfquaryparam's in there. Casey ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290021 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
