Here is the error I am getting [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'category_tbl where cat_key = Pa_RaM000'. SQL = "delete category_tbl where cat_key = ?" Query Parameter Value(s) - Parameter #1 = 2
Here is my code... <cfquery name="upd_cat" datasource="#dsn#" dbtype="ODBC">delete category_tbl where cat_key = <cfqueryparam value="#form.thekey#" cfsqltype="CF_SQL_NUMERIC"></cfquery> Can someone tell me what I am doing wrong please? thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
