[ACFUG Discuss] Cfunited Express Pics

2007-03-29 Thread Debbie Gregory
http://www.cacfug.org/a/archives/2007.cfm There are pics on this site of our own John Mason and Charlie Arehart presenting at CFUnited Express along with a synopsis of the event. - To unsubscribe from this list, manage your p

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

2007-03-29 Thread Jeff Howard
Right, there is definitely a band-aid approach. I was hoping to discover or be shown exactly why this is happening. I'm going to use the band-aid approach for now using this: equiptype= That's only midly ugly. I guess it might be better to use and CFIF statement instead in the case that ther

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

2007-03-29 Thread Teddy Payne
I am not sure why the behavior of the cfgrid is getting the value when it queries the data source. Did you check to make sure that the specified column does not have a default value of some type? If 2005 is actually able to send the string "null" to the cfgrid, then that is indeed a behavior that

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

2007-03-29 Thread Troy Jones
While I am not terribly versed in MSSQL, it sounds like it may be treating the word "NULL" as a varchar or text value? Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] O

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

[ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005

2007-03-29 Thread Jeff Howard
Hey all, I'm working on an asset tracking system and once again I've found myself using the CFGRID to be able to edit serveral items at once and then save. In the past week we've migrated to SQL Server 2005. I am having an issue with saving NULL values to the db. I just read Charlie's blog from