This should go to the discussion list (and I redirected it there).
Is the column set to allow nulls? If not, that's your issue.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
If liberty means anything at all, it means the right to tell people
what they do not want to hear.
-- George
"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 and I just replied to an email that I received.Is the column set to allow nulls? If not, that's your
: [ACFUG
Community] Quick (and hopefully simple) question about updating a SQL Server
table"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
d.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Jeff Howard
Sent: Thursday, September 28, 2006 3:00 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Re: [ACFUG Community] Quick (and hopefully
simple) question about updating a SQL Server table
Dean H. Saxe [EM
] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff
Howard
Sent: Thursday, September 28, 2006 3:00 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Re: [ACFUG Community] Quick (and
hopefully simple) question about updating a SQL Server table
Dean H. Saxe [EMAIL PROTECTED] wrote
;", set it to NULL instead. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: Thursday, September 28, 2006 3:00 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Re: [ACFUG Community] Quick (and hopefully simple) question about updating a SQL Server tab
PROTECTED]
On Behalf Of Jeff HowardSent: Thursday, September 28, 2006
3:52 PMTo: discussion@acfug.orgSubject: Re: [ACFUG
Discuss] Re: [ACFUG Community] Quick (and hopefully simple) question about
updating a SQL Server table
That's what I did. Thanks.
UPDATETableNameSET
CFIF FORM.VendorPOAmt6 IS N
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
in is , set it to NULL
instead. From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Jeff Howard Sent:
Thursday, September 28, 2006 3:00 PM To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Re: [ACFUG Community] Quick (and
hopefully simple) question about updating a SQL Server
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
12 matches
Mail list logo