[TYPO3-project-formidable] <sql> with variabel

[Manuel Rego Casasnovas]

Hello,

Maybe you could use an "userobj" to call a function or to write PHP code
directly.

Examples:
<datasources>
	<datasource:DB name="ds-pages">
		<sql>
		        <userobj>
		                <extension>this</extension>
		                <method>_sql</method>
		        </userobj>
		</sql>
	</datasource:DB>
</datasources>

With params:
<datasources>
	<datasource:DB name="ds-pages">
		<sql>
		        <userobj>
		                <extension>this</extension>
		                <method>_sql</method>
				<params>
					<param name="t3yearid" value="3" />
				</params>
		        </userobj>
		</sql>
	</datasource:DB>
</datasources>

Write PHP source code:
<datasources>
	<datasource:DB name="ds-pages">
		<sql>
		        <userobj>
		                <php>
					<![CDATA[
						return 'SELECT * from achievement where t3yearid="' . $t3yearid . '"';
					]]>
				</php>
		        </userobj>
		</sql>
	</datasource:DB>
</datasources>


Best regards,
   Rego

-- 
Manuel Rego Casasnovas
Computer Science Engineer
mailto:mrego at igalia.com
Tel: +34 986 10 76 10
Fax: +34 981 91 39 49
Igalia - http://www.igalia.com