[TYPO3] RES: SQL Query

[Felipe Knaesel Koch]

It doesnt. Typo3 returns and error about table not found in TCA array or
something.

_____________________________
Felipe Knaesel Koch
Auxiliar em Assuntos de Informática
Laboratório de Computação Científica - CCT
Universidade de Blumenau - FURB
Fone: (47)3321-6073
E-mail: felipek at furb.br


-----Mensagem original-----
De: typo3-english-bounces at lists.netfielders.de
[mailto:typo3-english-bounces at lists.netfielders.de] Em nome de Peter Russ
Enviada em: quarta-feira, 9 de agosto de 2006 05:25
Para: typo3-english at lists.netfielders.de
Assunto: Re: [TYPO3] SQL Query

Felipe Knaesel Koch schrieb:
> Hi list,
> 
>  
> 
> Anyway of doing this: “SELECT re.uid reid, re.rid roid, ro.title room,
> re.event event, re.user user, co.date date, co.hid hour
> 
> FROM `tx_fkkcrr_reservations` AS re, `tx_fkkcrr_reservations_content` AS
co,
> `tx_fkkcrr_rooms` AS ro
> 
> WHERE co.reid = re.uid
> 
> AND re.rid = ro.uid;” with $GLOBALS[‘TYPO3_DB’]? (except of course
sql_query
> method).
> 
> Thanks
> _____________________________
> Felipe Knaesel Koch
> Auxiliar em Assuntos de Informática
> Laboratório de Computação Científica - CCT
> Universidade de Blumenau - FURB
> Fone: (47)3321-6073
> E-mail: felipek at furb.br
> 
>  
> 
$GLOBALS['TYPO3_DB']->exec_SELECTquery(
	're.uid reid, re.rid roid, ro.title room,re.event event, re.user
user, 
co.date date, co.hid hour',
'`tx_fkkcrr_reservations` AS re, `tx_fkkcrr_reservations_content` AS 
co,`tx_fkkcrr_rooms` AS ro',
'co.reid = re.uid AND re.rid = ro.uid'
);


Should do it.

Regs. Peter.

-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ
_______________________________________________
TYPO3-english mailing list
TYPO3-english at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english