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 Journal
Any reason to validate before the cfquery 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:
cffunction name=CleanupVar returntype=string
: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 help since I'm
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