Re: Witango-Talk: Fw: Search actions and Null fields

[Charles Brown]

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