Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Still search problems, eq not like

Quote Reply
Still search problems, eq not like
Just try to do a search with search.cgi?ID=185, then i got all ids with 185 in it, like 185, 1851, 12185 and so on.
Till now i can find out how to do the query with something like ... where ID = '185' instead ... where ID = '%185'
I tried something like search.cgi?ID=>184&ID=<186, but this passes no informationa at all.
Searched the forum, but find only a lot of other stuff.
Quote Reply
Re: [Robert] Still search problems, eq not like In reply to
OK. FInd a way, not nice but it should be ok.
While i change the range for mh from 10|25 ... to 1|10|25... and set sorting to asc,
i can search with search.cgi?ID=185&mh=1&so=asc.
Quote Reply
Re: [Robert] Still search problems, eq not like In reply to
Nope. Im sorry. mh was only to set the maxhits per page, not the maxhits at all ...
Quote Reply
Re: [Robert] Still search problems, eq not like In reply to
Strange stuff.
While i try this:

search.cgi?ID=185&ID=<186&ID=>184 i get what i want,

if i try this:
search.cgi?ID=<186&ID=>184 i get nothing.

Last edited by:

Robert: Dec 18, 2003, 12:02 AM
Quote Reply
Re: [Robert] Still search problems, eq not like In reply to
Can I ask why you want to do that?

If you _know_ the ID, and you are searching on the ID field, why not use jump.cgi, detailed_page.cgi, or something similar? The purpose of search is to find things you *don't* know exactly what they are.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] Still search problems, eq not like In reply to
You have to know my site for seeing that; there are no URLs at all; and not every link has a detailed page, but a lot of links have much more than one detail pages. So if i could pass the things like in a normal search, users can see which other ways to go are there.

But just in this minute i have found out the way what´s to do.
I have to search with a hidden one ... name=ID value=0 then i get an sql with
GT::SQL::Driver::MYSQL::sth (13323): Executing query: SELECT * FROM Links WHERE ( isValidated = 'Yes' AND ID IN (0,185) )

I will send you the url to see it ;-)
Quote Reply
Re: [Robert] Still search problems, eq not like In reply to
Try with search.cgi?ID=185;ID-opt==

http://www.gossamer-threads.com/...orum.cgi?post=211570