troubleshooting Question

ColdFusion CFUPDATE SQL Issue Appending Data

Avatar of bodachs
bodachs asked on
Web ServersMicrosoft ApplicationsColdFusion Language
2 Comments2 Solutions500 ViewsLast Modified:

I have a SQL Server 2005 dbase that when I do a cfupdate on my database one of the cells I use for activating a record appends the update value in addition to the original value it if I try to change it.  For example.  The default value is nvarchar(50)( n'active) Null = No

So when the first record is created it has a value of "active".

Now when I do a cfupdate and change it from active to inactive using a web drop down list it looks as follows:  active, inactive

it just adds a comma and the selected variable, and then continues to add the next value and it continues as long as I change it the string gets longer instead of overwriting the one value.  It does not pick the changes up cleanly.  Am I missing something?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros