If you are having problems of <null> values being returned in a search and this is the reason you are trying to update your db with <null> values, you do not need to go do an update routine to set the values to <null>
Simply, when searching and not wanting to return <null> or blank values do the following...
In the search action, under the criteria tab, make sure you have "inc. empty" set to true.
This will return just the results you want. The blank or <null> values will now not be returned.
I do this all the time and it is much simpler. This way, I could care less if the values are blank or <null>.
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, updating the selected fields with an "Ifempty" for the value, like this: <@IFEMPTY "<@ARG tele1>"><@ELSE><@ARG tele1></@IF> I know this is a redundant hit on the database, but works for me.
Witty Tango wrote:
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. And exclude the ones that nothing in their resume. When I choose "Is not Null", somehow it does not understand it. If I go and make an entry in a field, save it. Then delete it. Now it understands the "Is not Null".
Any ideas? Any better ways to do it? I tried using != '' It gives me an error message saying that I cannot do that with text fields.
Help me guys.
- Witty Tango.
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
-- ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
