[Typo3-dev] Search in extension - Custom query

[Philippe Gagnon]

I figured I might want to use $this->pi_exec_query() with customs
parameters in order to create my query listing. What I want to do is
this query:

$query = "SELECT DISTINCT tx_bottinfsaa_personnel.* FROM
tx_bottinfsaa_personnel , tx_bottinfsaa_personnel_unite_mm,
tx_bottinfsaa_personnel_categorie_mm WHERE tx_bottinfsaa_personnel.uid
= tx_bottinfsaa_personnel_unite_mm.uid_local AND
tx_bottinfsaa_personnel.uid =
tx_bottinfsaa_personnel_categorie_mm.uid_local AND (".$wherecat.") AND
(".$whereuni.") ORDER BY tx_bottinfsaa_personnel.nomcomplet LIMIT
".$element1.",".$results_at_a_time."";

I will try it and post the result to see how it goes.



On Wed, 16 Feb 2005 15:22:48 -0500, Philippe Gagnon <philgag at gmail.com> wrote:
> Hi list.
> 
> In my extension, I modified the $res listing variable, using my own SQL query.
> 
> Instead of using the $this->pi_exec_query();
> I used a custom function.
> 
> The listing is as expected, but the search dosen't work anymore. I
> wondered how to connect my custom query to the
> $this->pi_list_searchBox(); function so it can search in my query.
> 
> thanks you.
> --
> Philippe Gagnon
> _______________________________________________
> Typo3-dev mailing list
> Typo3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
> 


-- 
Philippe Gagnon