[TYPO3-mvc] Extbase and individual select queries

[Kerstin Eitner]

Hi Alexander,

sometimes the solution is so simple ;)
Thank you very much!

Kind regards,
Kerstin


Am 20.09.2010 14:16, schrieb Alexander Dick:
>
> Hi Kerstin,
>
> you have to use exec_SELECTquery without the second underscore.
>
> Cheers
> Alex
>
> On Mon, 20 Sep 2010 14:12:32 +0200, Kerstin Eitner<eitner.kerstin at googlemail.com>  wrote:
>> Hi everybody,
>>
>> I read that it is possible to use the API of TYPO3 4.x to do sql queries
>> within the repository.
>> e.g. $GLOBALS['TYPO3_DB]->exec_SELECT_query
>>
>> I need that, because i just want to get some data from the tt_news table.
>>
>> So I did something like that:
>> $res = $GLOBALS['TYPO3_DB']->exec_SELECT_query(
>> 			'tt_news.uid',
>> 			'tt_news',
>> 			'uid = 1'
>> 		);
>> if ($res) {
>> 	$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
>> }
>>
>> but I get the following error "Call to undefined method
>> t3lib_DB::exec_SELECT_query()".
>>
>>
>> What am I doing wrong? Can someone please give me a hint?
>>
>> Thanks in advance,
>> Kerstin Eitner
>> _______________________________________________
>> TYPO3-project-typo3v4mvc mailing list
>> TYPO3-project-typo3v4mvc at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc
>