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