[TYPO3] MM relation in the FE

[mario]

hi, 
have you seen t3lib_DB::exec_SELECT_mm_query, or even
http://typo3.org/documentation/document-library/extension-manuals/bidirectional/current/
?

hope it helps
my best
mario

On Mon, 2006-03-20 at 14:40 +0100, Jérémy Lecour wrote:
> Hi,
> 
> I'm making an extension to display sdata tables in the FE.
> I've made it with the KickStarter and in the BE, everything is fine.
> 
> I've made a FE plugin to display my data but for the fields related to
> other tables, I have UIDs instead of the corresponding title.
> 
> My primary table is "students", my related table is "departements" and
> my MM-relation table is "students_departements_mm"
> 
> In the FE plugin  :
> 
> $mm_cat = array('table'=>'departements','mmtable'=>'students_departements_mm');
> $res = $this->pi_exec_query('students',0,'',$mm_cat);
> 
> It's working, I still have the correct records from "students"
> displayed, but the relation is not shown, I stille have my UIDs
> 
> With some debug stuffs I can see that the JOIN is OK, but in the
> SELECT I have only "SELECT students.* FROM ..." so it's is normal that
> I dont get my titles
> 
> 
> I've searched in the "class.tslib_pibase.php" code and it seems that
> is is impossible to get those relations with the built-in query tool
> and it is also impossible to make some multiple mm-relations, because
> the $mm_cat parameter is expected to be a 1-item-only array.
> 
> 
> I'd like to be sure that I'm not wrong telling it is not possible now
> or if I don't see all the magic that can be done with "pibase".
> 
> Thank you for your help
> --
> Jérémy Lecour : <mailto:jeremy.lecour at gmail.com>
> webdesigner, webmaster et développeur web
> Trésorier du PLUG : Provence Linux User Group
> http://www.plugfr.org/
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
> 
-- 
mario <chiari.hm at flashnet.it>