Like this perhaps? (If you're using cf5+ you might want to use a udf striphtml() which you can insert inline - Isaac has one at cflib.org I think.)
<cfmodule template="../cf_tags/StripHTML.cfm" textinvar = "FORM.FRarea"> <cfquery name="qaddEmployee" datasource="fly"> INSERT INTO employee (firstName, FRarea) VALUES ('#form.firstName#', '#form.FRarea#') </cfquery> > -----Original Message----- > From: Dave Lyons [mailto:[EMAIL PROTECTED] > Sent: Friday, 30 May 2003 1:38 p.m. > To: CF-Talk > Subject: correct way to implement this > > if i have the following insert statement > > <cfquery name="qaddEmployee" datasource="fly"> > INSERT INTO employee (firstName) > VALUES ('#form.firstName#') > </cfquery> > > > how do i add this tag to the insert statement? > <cfmodule template="../cf_tags/StripHTML.cfm" > textinvar = "FORM.FRarea"> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4