if i use the standard dreamweaver insert it put them into the insert
statement but i'm trying to learn all this the right way and cut down that
mess-o-code:)
----- Original Message -----
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 29, 2003 10:03 PM
Subject: RE: correct way to implement this
> 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
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
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
