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

[Flo]

ok, now I'm stuck.

I created an extension like in the manual described, changed the uid to
my search query id, changed the marker names.

added this to the setup in my root template:

plugin.tx_wfqbe_pi1.customQuery.2 {
     WFQBE_TITEL.overrideIfEmpty = 1
     WFQBE_AUTOR.overrideIfEmpty = 1
     WFQBE_KURZBESCHREIBUNG.overrideIfEmpty = 1
 }

and it's still not clearing the fields, any idea what I could have missed?

thanks, flo

sabine deeken wrote:
> 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
>>
>>   
>