RE: [mv] op=ne

[Victor Nolton <ven@pragakhan.com>]

I tried !~ in one of my "tries". I used su=yes to make sure y and yes 
were acceptable.

In the end I got fed up with searches that should of worked (in 
theory) and added another column called Available and just did that. 
I couldn't (at the time) change the soldout column to a yes or no 
cause of the way some usertags and various things worked.

Ven


>I think the search that you are using is testing the whole column to see if
>it isn't equal to 'y', therefore it is returning rows with 'yes' and 'no' as
>these both qualify as being not equal to 'y'. Try using the !~ operator
>instead. Alternatively use your existing search and make sure that your data
>column contains only 'y' or 'n'. See the Coordinated and joined searching
>page in the documentation for a cpmplete list of operators.
>
>Regards
>
>James
>
>
>-----Original Message-----
>From: Victor Nolton [mailto:ven@pragakhan.com]
>Sent: 09 May 2001 20:43
>To: Minivend List
>Subject: [mv] op=ne
>
>
>Not sure if anyone is still alive on this list :)
>
>I have a column in my database called SOLDOUT, if the item is sold
>out they put in a "yes" or a "y".
>
>I've been trying to setup a scan to search for a substring, not case
>sensitive for any items that do no contain "y"
>
>like
>http://www.mydomain.com/cgi-bin/mystore/scan/sf=SOLDOUT/su=yes/cs=no/se=y/op
>=ne
>
>this still returns all matches for "y"
>
>I've officially tried 30 combinations and no luck. I'd list all the
>combos I've tried but I think it would be repetative.
>
>I need to basically know how to just list the items that are NOT sold out.
>
>Suggestions?
>
>Ven
>--
>
>http://www.vensnews.com
>
>Victor "Ven" Nolton __________________________ http://www.VensNews.com
>http://PragaKhan.com  http://LordsofAcid.com  http://DarlingNikkie.com
>
>          All HTML Encoded email will be ignored. Learn Standards.
>
>_______________________________________________
>Minivend-users mailing list
>Minivend-users@minivend.com
>http://www.minivend.com/mailman/listinfo/minivend-users
>_______________________________________________
>Minivend-users mailing list
>Minivend-users@minivend.com
>http://www.minivend.com/mailman/listinfo/minivend-users

-- 

http://www.vensnews.com

Victor "Ven" Nolton __________________________ http://www.VensNews.com
http://PragaKhan.com  http://LordsofAcid.com  http://DarlingNikkie.com

         All HTML Encoded email will be ignored. Learn Standards.

_______________________________________________
Minivend-users mailing list
Minivend-users@minivend.com
http://www.minivend.com/mailman/listinfo/minivend-users