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

[Tom Schneider]

Hello Koen
Thanks a lot this will help me

regards tom

On 12/21/07, Koen Tilley <k.tilley at semaforce.be> wrote:
>
> 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
>
> _______________________________________________
> TYPO3-project-formidable mailing list
> TYPO3-project-formidable at lists.netfielders.de
>
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable
>