RE: [mv] op=ne

[James Lloyd <james.lloyd@amberdatacomm.co.uk>]

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