[TYPO3] RES: SQL Query

[Steven Bagshaw]

Aliases are generally OK, but watch the quote marks in that 2nd parameter.
(I don't use them myself around the table names). That may be where the
problem is coming from?

Steven


"Felipe Knaesel Koch" <felipe at lcc.furb.br> wrote in message
news:mailman.24448.1155138152.4326.typo3-english at lists.netfielders.de...
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