> > Element ACCESSCODE is undefined in FORM.
Perhaps the fact that the form has 3 elements all named accessCode might cause that problem? > Just a note: my caps lock was stuck on and I didn't realize it. I was not > angry or frustrated :) Good to hear! As for the too few paramters thing this is odd indeed. There is clearly nothing wrong with the syntax of the SQL you are sending. Looking around it seems that using the wrong table and column names can cause this problem. Other causes are to do with explicitly typing the parameters. If the column and table names are definately correct, try using qcfqueryparam and find the appropriate cfsqltype for the access field being referenced as cf_sql_varchar clearly does not work. HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
