Hi,
Am trying to set up pt_extlist to give me a list sorted and sortable by the daysInYear (php is using %j in its strftime function)
I dont really get what i can access with the field definition
fields {
field1 {
table = table1
field = field1
isSortable = 1
}
}
Is this the pure access to one column eg. field or can i access something that
i define in the baseFromClause
Lets say this would work
baseFromClause (
SELECT
domain,
years_paid,
date_registered,
date_registered +
INTERVAL(YEAR(CURRENT_TIMESTAMP) - YEAR(date_registered)) + 0 YEAR AS
currPeriod,
date_registered +
INTERVAL(YEAR(CURRENT_TIMESTAMP) - YEAR(date_registered)) + 1 YEAR AS nextPeriod
)
It works in phpMyAdmin when i add the FROM clause which is not needed in
baseFromClause or am i wrong?
Now my question is can i define nextPeriod as a field and use as a column. What
do i have to do to use it as a column?
_______________________________________________
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english