Basically my situation is I have a column in the MEMBERS table for the Active Users 3.5 mod. It cotains "1"s "0"s and nulls (null being true in this case).
Now, for the new version of the mod I need to get rid of those nulls and replace them with "1"s because they were causing a few ugly bugs.
This is what I tried, but it didn't work.
[UPDATE] MEMBERS M_AUHIDE#'1'#M_AUHIDE = '' [END]
That generates a 13|Type Mismach error, yet everything I'm working with is strings.
I also tried this with no Where statment, like it sais can be done in the dbs spec. That resulted in an UPDATE FORUM_MEMBERS SET M_AUHIDE = '' WHERE
Is there some way to get rid of those nulls that I'm missing?
Topic Locked
Posted - 06 April 2002 : 06:36:02
*