[TYPO3-mvc] Extbase and individual select queries

[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