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

[Tom Schneider]

Thanks a lot it works.
regards tom

On 12/21/07, Manuel Rego Casasnovas <mrego at igalia.com> wrote:
>
>
> 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
>
> _______________________________________________
> TYPO3-project-formidable mailing list
> TYPO3-project-formidable at lists.netfielders.de
>
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable
>