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

[sabine deeken]

not search query id; search result query id
Flo schrieb:
> 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
>>>
>>>   
>>>       
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
>