Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [TheStone] Search global - need help

Quote Reply
Re: [TheStone] Search global - need help In reply to
Hi,

ok, now I've understood what you ment with the plugin.

I am not really sure what the query-syntax is:

.../db.cgi?keyword=yamaha&db=Produkte&do=search_results&col=Produktname&mh=15&mul=1

gives me a result but if I add

../db.cgi?keyword=yamaha&db=Produkte&do=search_results&col=Produktname&mh=15&mul=1&let=y

my keyword-result-counter has 1300 results but nothing is display except a message "No results"

the same is when I use:

.../db.cgi?let=yamaha&db=Produkte&do=search_results&col=Produktname&mh=15&mul=1

SO WHAT THE HELL IS THE RIGHT SYNTAX ???

Another thing:

Am I right, that I have to do the following if I want to search for words and not for letters?:




...

my $db = $home->{cgi}->{db};
my $table = $DB->table($db);
$table->select_options("Order by $column",$limit);
my $cond = GT::SQL::Condition->new ();
if ($home->{cgi}->{mul}) {
my $words = [split /\s/,$letter]; # CHANGE TO: my $words = [split / /,$letter]; ???
$cond->{bool} = 'OR';
foreach (@$words) {
($_) and $cond->add($column,'LIKE',"%$_%");
}
...






Thanks!

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Subject Author Views Date
Thread Search global - need help ManuGermany 6190 Jan 14, 2003, 3:16 AM
Thread Re: [ManuGermany] Search global - need help
604 6063 Jan 15, 2003, 10:10 AM
Thread Re: [TheStone] Search global - need help
ManuGermany 6065 Jan 15, 2003, 11:01 AM
Thread Re: [ManuGermany] Search global - need help
604 6031 Jan 15, 2003, 11:30 AM
Thread Re: [TheStone] Search global - need help
ManuGermany 6021 Jan 16, 2003, 2:07 AM
Thread Re: [ManuGermany] Search global - need help
ManuGermany 6019 Jan 20, 2003, 12:47 AM
Thread Re: [ManuGermany] Search global - need help
ManuGermany 5974 Jan 24, 2003, 12:19 AM
Post Re: [ManuGermany] Search global - need help
ManuGermany 5937 Feb 3, 2003, 5:34 AM
Post Re: [ManuGermany] Search global - need help
Paul 5944 Feb 3, 2003, 5:43 AM