Advanced Search

Posted By

xtine777 on 11/19/19

Tagged

Versions (?)

Last Edited at 11/19/19 01:54am

Statistics

Viewed 11266 times
Favorited by 1 user(s)

TYPOSCRIPT: Use SUM() in SQL query

/ Published in: TYPO3
Save to your folder(s)
Add values from a given field in your database

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. 10 = CONTENT
  2. 10 {
  3.   table = tx_powermail_domain_model_answer
  4.   select {
  5.     pidInList = 12668
  6.     where = field = 321
  7.     selectFields = sum(value) AS sum
  8.   }
  9.   renderObj = COA
  10.   renderObj {
  11.     10 = TEXT
  12.     #10.field = value
  13.     10 {
  14.       value = {field:sum}
  15.       insertData = 1
  16.     }
  17.   }
  18. }

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.