correct way to implement this

2003-05-30 Thread Dave Lyons
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

Re: correct way to implement this

2003-05-30 Thread Mike Randolph
Hello Dave, I'd think you should have an 'strippedtextoutvar' (whatever the name) defined in the module call, but I'm not familiar with that specific tag. Kind Regards, Mike Randolph At 09:38 PM 5/29/2003 -0400, you wrote: if i have the following insert statement cfquery name=qaddEmployee

RE: correct way to implement this

2003-05-30 Thread Matthew Walker
, 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

Re: correct way to implement this

2003-05-30 Thread Dave Lyons
#', '#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

RE: correct way to implement this

2003-05-30 Thread Matthew Walker
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

Re: correct way to implement this

2003-05-30 Thread Dave Lyons
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

RE: correct way to implement this

2003-05-30 Thread Matthew Walker
It put the cfmodule tags inside the cfquery tag? While not actually wrong, it's hard on the eye. I'd definitely recommend calculating the values in advance, i.e. before the query. The only difference is readability though. if i use the standard dreamweaver insert it put them into the insert

Re: correct way to implement this

2003-05-30 Thread Dave Lyons
Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 29, 2003 10:22 PM Subject: RE: correct way to implement this It put the cfmodule tags inside the cfquery tag? While not actually wrong, it's hard on the eye. I'd definitely recommend calculating the values in advance, i.e