I think this has been discussed here a few days ago. If you use select * and you add a column to the table in sql server, things might break. To fix it, either restart cf service, uncheck cache db connections on the datasource or stop using * queries.
Russ > -----Original Message----- > From: Brent Shaub [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 27, 2006 3:44 PM > To: CF-Talk > Subject: Re: select * (star) caching > > Teddy, I was hoping that'd be the answer, but it's not. Doesn't seem to > affect anything relevant to the queries. There must be something because > if I add a column to the table with a star, I got an error "value cannot > be converted to the requested type". I changed the query to add a static > value ('x' as temp) and it ran fine. Then I took out the static field, > and it ran fine. Thus, I believe it's something to do with the way CF is > caching the query. Does it matter this query is in a .cfc that is an > application-level object with a "get" function that runs a star query? > I'm thinking it's the star regardless of CF-implementation. > > Any help appreciated. > > Brent > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254515 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
