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
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
, 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
#', '#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
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
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
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
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
8 matches
Mail list logo