Think of validation like a pair of funnels (input/output) with
business logic in the middle. Your data must pass through the funnel
successfully on input before being put into the business logic. Data
must be passed through a screen on output to ensure it doesn't
contain any malicious met
28, 2006
12:48 PM
To: discussion@acfug.org
Subject: Re: re[2]: [ACFUG
Discuss] Re: [ACFUG Community] Quick (and hopefully simple) question about
updating a SQL Server table
Thanks everyone for your help. The response was quick and
useful. Nice to know there is some place I can turn for
Any reason to validate before the as some suggested or is it just
personal preference vs doing in the SQL statement?
** Purely personal, I just like my SQL to look clean. If you have to do this
for 30 fields, I'd write a quick function:
and then call it like
http://www.acfug.org
[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006
1:06 PM
To: discussion@acfug.org
Subject: RE: re[2]: [ACFUG Discuss]
Re: [ACFUG Community] Quick (and hopefully simple) question about updating a
SQL Server table
Jeff,
Here are 3 links to a 3-part tutorial in
ColdFusion Developers
Thanks everyone for your help. The response was quick and useful. Nice to know there is some place I can turn for help since I'm the only web-dev at my company. This is pretty much what I came up with while waiting for a response. I was hoping there was something I was over looking that didn
Leave it to Allen to throw the emptry string solution. *heh* I need to walk over there and throw soemthing at you.TeddyOn 9/28/06, Mischa Uppelschoten ext 10
<[EMAIL PROTECTED]> wrote:
Try something like:if MyNewMoney EQ ""MyNewVal = "NULL"elseMyNewVal = #form.MyNewMoney#"UPDATE MyTableSE
Try something like:
if MyNewMoney EQ ""
MyNewVal = "NULL"
else
MyNewVal = #form.MyNewMoney#"
"Dean H. Saxe" <[EMAIL PROTECTED]> wrote:
This should go to the discussion list (and I redirected it there).
I apologize, this is my first attempt at trying to ask a question to the ACFUG
an