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

[Koen Tilley]

Hello Tom,

I struggled with this problem myself. You can solve this by using the very
powerful <xmlbuilder>

This allows you to generate xml-tags dynamically.

It would give something like this:

<datasources>
<datasource:DB name="ds-pages">
<xmlbuilder>
	<userobj>
		<php><![CDATA[
			// variable that will contain the generated XML
			$aXml = array();
			$aXml["sql"] = "SELECT * FROM achievement 
			WHERE t3yearid = ".$this->_oParent->yourVariable;
			return $aXml;
		]]></php>
	</userobj>
</xmlbuilder>
</datasource:DB>
</datasources>


Hope this helps,
Koen

_________________________________________________
Koen Tilley
Semaforce bvba
Hof ter Mullenstraat 44
B-1700 DILBEEK
e-mail: k.tilley at semaforce.be


-----Original Message-----
From: typo3-project-formidable-bounces at lists.netfielders.de
[mailto:typo3-project-formidable-bounces at lists.netfielders.de] On Behalf Of
Tom Schneider
Sent: 21 December 2007 08:41
To: typo3-project-formidable at lists.netfielders.de
Subject: [TYPO3-project-formidable] <sql> with variabel

Hello
Can somebody help me i have to use sql commands like this:

<datasources>
<datasource:DB name="ds-pages">
<sql>SELECT * from achievement where t3yearid = </sql>
</datasource:DB>
</datasources>

but now in the where command i need a variable like $the_year how can i do
this?

Thanks for your help

regards tom schneider
_______________________________________________
TYPO3-project-formidable mailing list
TYPO3-project-formidable at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidabl
e