[TYPO3-english] EXT: DB Integration (wfqbe) - Problem with search form query

[sabine deeken]

template setup

Flo schrieb:
> oh, I read the manual, but didn't looked at the hooks, my fault.
> thanks for the hint. and now where exactly do I add this:
>
> plugin.tx_wfqbe_pi1.customQuery.2 {
> 	WFQBE_TITEL.overrideIfEmpty = 1
> 	WFQBE_AUTOR.overrideIfEmpty = 1
> 	WFQBE_KURZBESCHREIBUNG.overrideIfEmpty = 1
> }
>
> 2 is the id of my search query, do I add this in the TSconfig of the
> search page?
>
> bye, flo
>
> sabine deeken wrote:
>   
>> Hi Flo,
>> there is a hook to remove empty where clauses (it's described
>> comprehensively in the extension manual).
>> with text input searchfields this works perfect (I had only problems
>> with multiple selects)
>> so better read the manual first...
>> Sabine
>>
>> Flo schrieb:
>>     
>>> Hi,
>>>
>>> I have a little problem with understanding the right way to do a search
>>> query.
>>>
>>> in the moment I have the following query:
>>>
>>> SELECT bdb_datenbank.ID, bdb_datenbank.Verlag, bdb_datenbank.Titel,
>>> bdb_datenbank.Thema, bdb_datenbank.Kurzbeschreibung, bdb_datenbank.Autor
>>> FROM bdb_datenbank WHERE bdb_datenbank.Titel LIKE '###WFQBE_TITEL###' OR
>>> bdb_datenbank.Autor LIKE '###WFQBE_AUTOR###' OR
>>> bdb_datenbank.Kurzbeschreibung LIKE '###WFQBE_KURZBESCHREIBUNG###' ORDER
>>> BY bdb_datenbank.ID ASC
>>>
>>> and in the searchform I have the 3 fields, wich search for "Autor",
>>> "Titel" and "Kurzbeschreibung".
>>> this works so far.
>>>
>>> but what I need is something like this:
>>>
>>> WHERE bdb_datenbank.Titel LIKE '%###WFQBE_TITEL###%'
>>>
>>> I need a %LIKE...% operator, if I add them before and after the marker,
>>> I would get the results I need, but if only one search field is filled
>>> out, the other 2 remains empty with 2 times "%", wich is displaying me
>>> all of my database entries (of course! ;))
>>>
>>> what is the right way to do this?
>>>
>>> best regards, flo weber
>>> _______________________________________________
>>> TYPO3-english mailing list
>>> TYPO3-english at lists.netfielders.de
>>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>>>
>>>   
>>>       
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
>