I've got the following Problem:

I want to search for 2 words ('Telefon' and 'Terasse') in the same DB-Field ('FewoAusstattung').
Here is the example:

search.cgi?d=1&TypBetrieb=Ferienwohnung&catid=74&FewoAusstattung=Terrasse&FewoAusstattung=Telefon

There should be more than 1 results. But I don't get any results.
As a matter of fact I turned on the debug mode and I got the following:
...
...
46: SELECT ID FROM lsql_Links WHERE ( TypBetrieb LIKE '%Ferienwohnung%' AND isValidated = 'Yes' AND FewoAusstattung IN TelefoTerrass) )That looks somethiong strange for me... After the last "AND" that seems not to be a correct MySQL command!?
Where is the problem?

Please help me!

MMm.. does this work?

search.cgi?FewoAusstattung=Telefon&FewoAusstattung=Terasse&bool=AND

?

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

I've tried allready and I get:
42: SELECT * FROM lsql_Links WHERE ( isValidated = 'Yes' AND FewoAusstattung IN TerassTelefo) )
ORDER BY bStars ASC
LIMIT 0, 25It seems to be the same problem:
"AND FewoAusstattung IN TerassTelefo)"
There is ")" to much and the "TerassTelfo" looks also like a bad "string function"...

Where are the scripts located, which build the query-string?

Hi,


/admin/Links/User/Search.pm, I believe.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates