[Typo3-dev] Search in extension - Custom query - SELECT DISTINCT HELP

[Philippe Gagnon]

How can I use a SELECT DISTINCT using pi_exec_query?

I'm hesitant to modify the code of this function. Could I add a parameter? 


please help!

(sorry for double posting I'm investigating this issue)


On Fri, 18 Feb 2005 11:56:02 -0500, Philippe Gagnon <philgag at gmail.com> wrote:
> 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
> 


-- 
Philippe Gagnon