[TYPO3-project-formidable] Dynamically pass the cruser_id to the SQL of the datasource

Ian Solo ian at webian.it
Thu May 8 11:45:28 CEST 2008


Hello,

I have a renderlet:LISTER that get the data from this datasource:
*****************************************************************
<datasources>
	<datasource:DB name="images">
		<sql><![CDATA[
			SELECT	uid, image, title, tstamp, crdate
			FROM	tx_iangallery_gallery
			WHERE	pid = 301
			AND	cruser_id = 81
			AND	deleted=0
			AND	hidden=0
		]]></sql>
	</datasource:DB>
</datasources>
*****************************************************************

How can I dynamically pass the cruser_id of the current user logged to 
this SQL?

I have the feeling that this is a noob question :)
but I can't find an answer by myself.

Thanks in advance for your help!
ian


More information about the TYPO3-project-formidable mailing list