You want DELETE FROM category_tbl... Regards, Matthew Walker http://www.matthewwalker.net.nz/inform2
> -----Original Message----- > From: Yager, Brian T Contractor/Sverdrup > [mailto:[EMAIL PROTECTED]] > Sent: Friday, 11 October 2002 8:09 a.m. > To: CF-Talk > Subject: Error with cfqueryparam... > > > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
