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
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.
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:
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,
It is true that a blank field in not NULL in the MSSQL database.
Any Direct input to the db will result in the NULL value being
changed to a blank value. This is just the way it is.
If you are having problems of null values being returned in a
search and this is the reason you are trying to
Thank you Dale. That worked perfectly. Actually, I found a previous response
of yours on the list searching the archives after I sent that message. Just
goes to show, you should always search the archives first.
Regards
T.
On 1/23/04 5:10 AM, Dale Graham [EMAIL PROTECTED] wrote:
Hi, Trevor -
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
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 NULL is not in the field
in the database, I