TYPO3 Formidable - PasteBin

List bound to a db-datasource

Permalink to this snippet:

http://formidable.typo3.ug/pastebin/snippet/10.html

Jerome Schneider, 2008-03-05@15:40:43, pasted:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<formidable version="0.7.76"
	xmlns:datahandler="http://www.ameos.com/formidable/080/datahandler"
	xmlns:datasource="http://www.ameos.com/formidable/080/datasource"
	xmlns:renderer="http://www.ameos.com/formidable/080/renderer"
	xmlns:renderlet="http://www.ameos.com/formidable/080/renderlet"
	xmlns:validator="http://www.ameos.com/formidable/080/validator"
	xmlns:actionlet="http://www.ameos.com/formidable/080/actionlet">

<datahandler:VOID />
		<renderer:STANDARD />

<datasource:DB name="pages">
				<sql><![CDATA[
					SELECT uid, title, tstamp, crdate from pages WHERE pid = 25 AND deleted=0 and hidden=0
				]]></sql>
			</datasource:DB>

<datasource:DB name="fe_users">
				<sql><![CDATA[
					
					SELECT
						fe_users.uid				AS uid,
						fe_users.username			AS username,
						fe_users.tstamp				AS tstamp,
						(fe_users.crdate + 86400)	AS crdate,
						fe_users.usergroup			AS usergroup,
						fe_groups.title				AS groupname,
						fe_groups.tstamp			AS fe_groups_tstamp,
						IF(fe_groups.deleted = 0, "ACTIVE", "DELETED") AS fe_groups_status,
						pages.title					AS pagetitle
					FROM
						fe_users, fe_groups, pages
					WHERE
						fe_users.usergroup = fe_groups.uid AND
						fe_users.pid = pages.uid AND
						fe_users.pid = 76

]]></sql>
			</datasource:DB>

</datasources>

</control>

<renderlet:BOX mode="h3" html="Listing pages table" />

<renderlet:LISTER name="mylist" cachehash="true">
			<datasource use="pages" />
			<columns>
				<column name="title" type="renderlet:TEXT" listHeader="Page title" />
				<column name="crdate" type="renderlet:DATE" listHeader="CR date">
					<data>
						<datetime format="%d %B %Y" />
					</data>
				</column>
			</columns>
		</renderlet:LISTER>

<renderlet:BOX mode="h3" html="Listing fe_users+fe_groups+pages tables and relations" />

<renderlet:LISTER name="mylist2" cachehash="true">
			<datasource use="fe_users" />
			<columns>
				<column name="username" type="renderlet:TEXT" listHeader="User name" />
				<column name="pagetitle" type="renderlet:TEXT" listHeader="User Stored in" />
				<column name="crdate" type="renderlet:DATE" listHeader="User CR date">
					<data>
						<datetime format="%d %B %Y" locale="fr_FR" />
					</data>
				</column>
				<column name="groupname" type="renderlet:TEXT" listHeader="Group name" />
				<column name="fe_groups_tstamp" type="renderlet:DATE" listHeader="Group Mod date">
					<data>
						<datetime format="%d %B %Y" locale="fr_FR" />
					</data>
				</column>
				<column name="fe_groups_status" type="renderlet:TEXT" listHeader="Group status" />
			</columns>
		</renderlet:LISTER>

</elements>

</formidable>

List bound to a db-datasource

Download

Features

Documentation

Many thanks to

Latest snippets