This topic is locked

Search for null field

12/21/2003 11:02:26 PM
ASPRunnerPro General questions
author

how can i search for the field that is null?!!

Sergey Kornilov admin 1/1/2004

Hi,
currently is not possible. I'm working on adding this functionality to ASPRunner.
Best regards,

Sergey Kornilov

500984 3/26/2004

Has this problem been solved for the latest professional release? Thanks again!

Sergey Kornilov admin 3/26/2004

No,
I still don't know what is the best way to implement it.

500082 5/21/2004

I did this a rather crude way, i'm sure someone with a bit of knowledge can improve it for me...
I altered one of the drop down options that i didn't use, could have added a new one i suppose, but for this example i'll use 'Equals'
<OPTION VALUE="Equals">Is Null</option> in the list page
And in the aspfunctions page altered the string to
Case "Equals" StrWhere = "is null"
They have to enter a value in the search box, but it's not used, so anything will do.
i'm sure someone can do it better, but it's all new to me, but this seemed to work as a quick fix.
I'm sure admin will improve upon it ;-) or it may inspire you to greater things :-)

Sergey Kornilov admin 5/24/2004

Scruffy,
thank you for the interesting idea!
I'll try to implement this in one of the following versions of ASPRunner.

hanb 7/8/2004

I had to check for an field with no data, The field containing email addresses.

an search for emailfield less than 0 did give me all records with no data in it.