You need to strip HTML from all the fields? Yes the way you're writing it
looks like it might be right. The assumption is that the stripped HTML is
being placed back into the form field. You'd need to either look at the
code, the docs or try it and see.
> i already have the template
Yes, I recognize that, but just for your future reference a UDF would make
your life easier:
<cfquery name="qaddEmployee" datasource="fly">
INSERT INTO employee (firstName, FRarea)
VALUES ('#striphtml(form.firstName)#', '#striphtml(form.FRarea)#')
</cfquery>
> -----Original Message-----
> From: Dave Lyons [mailto:[EMAIL PROTECTED]
> Sent: Friday, 30 May 2003 1:56 p.m.
> To: CF-Talk
> Subject: Re: correct way to implement this
>
> i already have the template, i just dont know where to stick the tag to
> make
> sure it strips everything. By the looks of what you wrote i should just
> place them before the insert statement. I have the template in a folder
> called cf_tags
>
> would it be like this and just put a tag for each field before the
> statement?
>
> cfmodule template="../cf_tags/StripHTML.cfm"
> > textinvar = "FORM.firstName">
>
>
> <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: "Matthew Walker" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 29, 2003 9:44 PM
> Subject: RE: correct way to implement this
>
>
> > 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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
