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

[Flo]

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