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.
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.