> 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]