There is a prepared statement that is cached in CF somewhere (and I apologize that I don't understand the guts of this internally in CF in greater detail than that). I assume you are correctly using cfqueryparam, which is usually when you see this problem, because as far as what is passed to the db, the value of the parameters can change but the underlying prepared statement does not. I had this problem with an earlier version of Reactor because it always used select * (no idea if it still does). There are other database performance related reasons not to use select *, so that is what I personally recommend, though it means that adding new columns forces you to change your query. Otherwise, even adding an extraneous space to your query's sql code will cause the prepared statement to recompile (which is in effect changing your query and requires almost the same effort as option 1 and thus you are probably better off dropping the select *).
-- - Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:254479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
