Very Strange,
I use select * from all the time when I need all the columns and never have
a run into this problem. I would be asking this thought how about a sample
of the code in question, are you using cachedwithin? If so then you need to
remove that or find a way to rerun the cached query.
It is very vauge on the question, and after using all versions of cf from
2.0 - 7.02 this is the first time I have seen this problem, but also what DB
are you using, as suggested you might need to flush the DB Connection.
On 9/28/06, Scott Stroz <[EMAIL PROTECTED]> wrote:
>
> 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:254581
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
