admin pages rather than code individual queries for each table...pure
laziness. Never noticed that behavior under CF5 using ODBC.
Thanks,
Ken
On Wed, 22 Sep 2004 12:13:29 -0400, Dave Watts <[EMAIL PROTECTED]> wrote:
> > Would that have something to do with the error I get if I run
> > a query using <cfqueryparam> , make a slight change to
> > database structure and then run the query again? If I remove
> > the <cfqueryparam> it works fine and if I wait awhile before
> > running the query again it does fine.
> > Almost acts like it's caching info that is no longer correct
> > following a slight change to the table.
>
> If you're using "SELECT *" within your query, I can see that happening. When
> you build a prepared statement, the database typically caches the execution
> plan for that statement.
>
> 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]
