Re: [Hardhats-members] How to do a fileman search for EMPTY fields?
I guess I wasn't especially clear in my response. Predicate is a fancy term for operator. In this case you want Select VA FileMan Option: SEarch File Entries OUTPUT FROM WHAT FILE: TIU DOCUMENT// 19 OPTION (13279 entries) -A- SEARCH FOR OPTION FIELD: 1 MENU TEXT -A- CONDITION: NULL -B- SEARCH FOR OPTION FIELD: IF: A// MENU TEXT NULL STORE RESULTS OF SEARCH IN TEMPLATE: --- Gregory Woodhouse [EMAIL PROTECTED] wrote: Don't use equals as the condition. You're actually using NULL as a predicate, not a value. === Gregory Woodhouse [EMAIL PROTECTED] Better. Faster. Cheaper. Pick two. On Jun 19, 2005, at 8:00 PM, Kevin Toppenberg wrote: Oops, I just tried it and it doesn't work. Here is a screen log Kevin Select FM VA Filename Option: search File Entries OUTPUT FROM WHAT FILE: TIU DOCUMENT// -A- SEARCH FOR TIU DOCUMENT FIELD: enterED BY -A- CONDITION: = EQUALS -A- EQUALS NEW PERSON: NULL ?? NEW PERSON: NUll ?? NEW PERSON: NULL ?? NEW PERSON: Press RETURN to continue... --- Gregory Woodhouse [EMAIL PROTECTED] wrote: Just type NULL. === Gregory Woodhouse [EMAIL PROTECTED] Better. Faster. Cheaper. Pick two. On Jun 19, 2005, at 7:03 PM, Kevin Toppenberg wrote: I want to do a field for all records for which a particular field holds no data. Can I do this with a fileman search? If so, what would the syntax be? Thanks Kevin --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members The most profound technologies are those that disappear. --Mark Weiser Greg Woodhouse [EMAIL PROTECTED] [EMAIL PROTECTED] --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
[Hardhats-members] How to do a fileman search for EMPTY fields?
I want to do a field for all records for which a particular field holds no data. Can I do this with a fileman search? If so, what would the syntax be? Thanks Kevin __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
Re: [Hardhats-members] How to do a fileman search for EMPTY fields?
Just type NULL. === Gregory Woodhouse [EMAIL PROTECTED] Better. Faster. Cheaper. Pick two. On Jun 19, 2005, at 7:03 PM, Kevin Toppenberg wrote: I want to do a field for all records for which a particular field holds no data. Can I do this with a fileman search? If so, what would the syntax be? Thanks Kevin --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
Re: [Hardhats-members] How to do a fileman search for EMPTY fields?
That was easy. Thanks Kevin --- Gregory Woodhouse [EMAIL PROTECTED] wrote: Just type NULL. === Gregory Woodhouse [EMAIL PROTECTED] Better. Faster. Cheaper. Pick two. On Jun 19, 2005, at 7:03 PM, Kevin Toppenberg wrote: I want to do a field for all records for which a particular field holds no data. Can I do this with a fileman search? If so, what would the syntax be? Thanks Kevin --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members __ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
Re: [Hardhats-members] How to do a fileman search for EMPTY fields?
Oops, I just tried it and it doesn't work. Here is a screen log Kevin Select FM VA Filename Option: search File Entries OUTPUT FROM WHAT FILE: TIU DOCUMENT// -A- SEARCH FOR TIU DOCUMENT FIELD: enterED BY -A- CONDITION: = EQUALS -A- EQUALS NEW PERSON: NULL ?? NEW PERSON: NUll ?? NEW PERSON: NULL ?? NEW PERSON: Press RETURN to continue... --- Gregory Woodhouse [EMAIL PROTECTED] wrote: Just type NULL. === Gregory Woodhouse [EMAIL PROTECTED] Better. Faster. Cheaper. Pick two. On Jun 19, 2005, at 7:03 PM, Kevin Toppenberg wrote: I want to do a field for all records for which a particular field holds no data. Can I do this with a fileman search? If so, what would the syntax be? Thanks Kevin --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
Re: [Hardhats-members] How to do a fileman search for EMPTY fields?
Enter question mark at the CONDITION: prompt Gregory Woodhouse wrote: Don't use equals as the condition. You're actually using NULL as a predicate, not a value. === Gregory Woodhouse [EMAIL PROTECTED] Better. Faster. Cheaper. Pick two. On Jun 19, 2005, at 8:00 PM, Kevin Toppenberg wrote: Oops, I just tried it and it doesn't work. Here is a screen log Kevin Select FM VA Filename Option: search File Entries OUTPUT FROM WHAT FILE: TIU DOCUMENT// -A- SEARCH FOR TIU DOCUMENT FIELD: enterED BY -A- CONDITION: = EQUALS -A- EQUALS NEW PERSON: NULL ?? NEW PERSON: NUll ?? NEW PERSON: NULL ?? NEW PERSON: Press RETURN to continue... --- Gregory Woodhouse [EMAIL PROTECTED] wrote: Just type NULL. === Gregory Woodhouse [EMAIL PROTECTED] Better. Faster. Cheaper. Pick two. On Jun 19, 2005, at 7:03 PM, Kevin Toppenberg wrote: I want to do a field for all records for which a particular field holds no data. Can I do this with a fileman search? If so, what would the syntax be? Thanks Kevin --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members -- Greg Kreis http://www.PioneerDataSys.com You are today where your thoughts have brought you, you will be tomorrow where your thoughts take you. (James Lane Allen) --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
RE: [Hardhats-members] How to do a fileman search for EMPTY fields?
Try the @ for null ..tx/t SORT BY: DOTID// 1.4 DOT AGE START WITH DOT AGE: FIRST// @ GO TO DOT AGE: LAST// @ WITHIN DOT AGE, SORT BY: FIRST PRINT FIELD: .01 DOTID THEN PRINT FIELD: 1.4 DOT AGE THEN PRINT FIELD: -Original Message- From: [EMAIL PROTECTED] [mailto:hardhats- [EMAIL PROTECTED] On Behalf Of Kevin Toppenberg Sent: Sunday, June 19, 2005 9:00 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] How to do a fileman search for EMPTY fields? Oops, I just tried it and it doesn't work. Here is a screen log Kevin Select FM VA Filename Option: search File Entries OUTPUT FROM WHAT FILE: TIU DOCUMENT// -A- SEARCH FOR TIU DOCUMENT FIELD: enterED BY -A- CONDITION: = EQUALS -A- EQUALS NEW PERSON: NULL ?? NEW PERSON: NUll ?? NEW PERSON: NULL ?? NEW PERSON: Press RETURN to continue... --- Gregory Woodhouse [EMAIL PROTECTED] wrote: Just type NULL. === Gregory Woodhouse [EMAIL PROTECTED] Better. Faster. Cheaper. Pick two. On Jun 19, 2005, at 7:03 PM, Kevin Toppenberg wrote: I want to do a field for all records for which a particular field holds no data. Can I do this with a fileman search? If so, what would the syntax be? Thanks Kevin --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members