[TYPO3-english] powermail + typoscript database query

[horace grant]

On Tue, Jul 12, 2011 at 3:01 PM, horace grant <horace3d at gmail.com> wrote:

> hi,
>
> i am using the extension powermail and i need to add a unique id number to
> every mail that gets sent out.
>
> what is the best and easiest way to achieve this?
>
> is it possible with typoscript to do a database query that counts the
> powermail db entries on a specific page and returns that number? so i could
> simply use this number as an id?
>
> that was my first idea but i don't quite get this "select" stuff in
> typoscript and what is possible there.
>



i think i have figured it out...

page.200 = CONTENT
page.200.table = tx_powermail_mails
page.200.select.pidInList = 12, 13
page.200.select.orderBy = uid desc
page.200.select.selectFields = uid
page.200.select.max = 1
page.200.renderObj = TEXT
page.200.renderObj.field = uid

it outputs the number i want so probably i just have to use this for
prefilling a hidden field...

plugin.tx_powermail_pi1 {
prefill.uid999 = CONTENT
...
}

cheers,
horace




> cheers,
> horace
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>