By any chance, are there any <cfqueryparam>s in the WHERE clause? I have
seen issues similar to what you describe with using 'select * from...' and
<cfqueryparam>.
On 9/27/06, Brent Shaub <[EMAIL PROTECTED]> wrote:
>
> 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:254570
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
