We were getting the same errors when adding / removing columns from the DB. You might want to try the following (if you're still wanting to use <cfqueryparam> and SELECT *) from Stephen Dupre at Macromedia:
"Maybe the statement cache is getting us. Try shutting off "Max Pooled Statements" (set this to 0) and see if this clears anything up."
We took this approach and it works great.
Hope this helps!
Pat
-----Original Message-----
From: George Abraham [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 1:43 PM
To: CF-Talk
Subject: Re: weird but consistent behavior
So OT, why is using Select * a bad practice? URLs anyone?
George
On Fri, 13 Aug 2004 16:42:18 +0100, Alistair Davidson
<[EMAIL PROTECTED]> wrote:
> I've heard of similar things happening on queries where you use SELECT * (see http://www.1pixelout.net/index.cfm/blog/entry/cfqueryparam.htm )
>
> Are you using select * ?
>
> If so, consider the error a slap on the wrist! ;)
>
> Cheers,
>
> Alistair
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
