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:254508
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
