Error is caused by your sql statement. You're missing the keyword "FROM" after delete.
Nick Han >>> [EMAIL PROTECTED] 10/10/02 12:08PM >>> 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 Get the mailserver that powers this list at http://www.coolfusion.com
