Ben Mueller wrote: > <cfquery> > SELECT firstname > FROM user > WHERE email = <cfqueryparam cfsqltype="varchar" value=#form.email#> > </cfquery> > > MS SQL Server caches the execution plan. Then, I add a "lastname" column to > the user table. I don't change the query at all. I re-hit the query while > the execution plan is cached. It breaks?
Probably not if you add a column, only if you delete one and keep referencing it: <cfquery> CREATE TABLE user (A, B, C) </cfquery> <cffunction name="test> <cfquery> SELECT * FROM user WHERE A = <cfqueryparam cfsqltype="varchar" value=#form.email#> </cfquery> </cffunction> <cfset test()> <cfquery> ALTER TABLE user DROP COLUMN C </cfquery> <cfset test()> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4