> As much as I hate "SELECT * ", I am using it in this case on
> some admin pages rather than code individual queries for each
> table...pure laziness.  Never noticed that behavior under CF5
> using ODBC.

It will only occur if you change the database structure and you're using an
existing query plan or a view, I think. Perhaps you weren't using
CFQUERYPARAM with CF 5, or perhaps for some reason SQL Server wasn't caching
the query plans.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to