Thanks. I will be able to use this. I also occasionally need to search
for records with "NULL" fields, though. Basicaly, I just need to
identify records with blank fields, but "is empty" is not always
available as a selection criteria, and if the is not in the field
in the database, I can't
I've had to do the same thing before... but for some reason i thought
this was a problem with t2k that was fixed with SP1, or one of the FTF's
I'm probably wrong though... It might still exist in the current
version. I do remember that it depended on what the data type of the
field was though
It is true that a blank field in not in the MSSQL database.
Any Direct input to the db will result in the value being
changed to a blank value. This is just the way it is.
If you are having problems of values being returned in a
search and this is the reason you are trying to update your db
The null value does not seem to get entered into my MSSQL database on a
Witango "insert" action for an empty form field, but it does on an
"update" action. So, for those times I really need the null value in
certain fields, I follow an insert action with an update action on the
same record, up
Hi I fought this monster too :-b
To some databases
'' is not equal to NULL
one way is to create customer field and use len()
len(column.name) > 0
Ben Johansen - http://www.pcforge.com
Authorized Witango & MDaemon Reseller
Available for Witango Developement
-Original Message-
From:
In the search action, under the criteria tab, make sure you have
"inc. empty" set to true.
Hi.
I am having problem with Search actions on SQl server 2000.
I have a resume database with lots of text fields. I want to generate a
report of users who have at least one field in the resume filled-up
Would it be easier to add an extra field to the database that is a boolean (i.e. T/F) field with a default value of F. Anytime someone either creates a new record and or updates a record, and makes an entry into the appropriate field then set it to T. That will probably help with the speed of your