Re: [ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005

2007-03-29 Thread Jeff Howard
ECTED] > > > -- > > *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Jeff > Howard > *Sent:* Thursday, March 29, 2007 1:26 PM > *To:* discussion@acfug.org > *Subject:* Re: [ACFUG Discuss] cfqueryparam and NULL attribute SQL >

Re: [ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005

2007-03-29 Thread Teddy Payne
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Jeff Howard *Sent:* Thursday, March 29, 2007 1:26 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005 Tom, Syntax error on my part. It is an UPDATE that I'm doing and not an

RE: [ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005

2007-03-29 Thread Troy Jones
PROTECTED] On Behalf Of Jeff Howard Sent: Thursday, March 29, 2007 1:26 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005 Tom, Syntax error on my part. It is an UPDATE that I'm doing and not an INSERT. The code I provided is the u

Re: [ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005

2007-03-29 Thread Jeff Howard
Tom, Syntax error on my part. It is an UPDATE that I'm doing and not an INSERT. The code I provided is the update statement. As far as the old code, it exists in a backup file but is not present at all in the live code. The behavior that the app is displaying is as follows: 1. If I click in

Re: [ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005

2007-03-29 Thread Tom McNeer
Jeff, Bottom line, why is isnerting the string "null" into my db instead of ??? There's nothing in the code you showed that would insert that value. Just a guess, but -- is your old code in place, the code that tried to create "null" in a string value? You're experiencing the same behavior y