DataTabSheet: Difference between revisions
Yadasampati (talk | contribs) No edit summary |
Yadasampati (talk | contribs) No edit summary |
||
| Line 3: | Line 3: | ||
|from= tran,trpr | |from= tran,trpr | ||
|where= tran.tran_id=trpr.tran_id and prop_id = {{{1}}} | |where= tran.tran_id=trpr.tran_id and prop_id = {{{1}}} | ||
|data= id=tran.tran_id,text=concat("aap",tran_text) | |data= id=tran.tran_id,text=concat(concat("aap","noot"),tran_text) | ||
}} | }} | ||
{| class="wikitable" style="width:70%" | {| class="wikitable" style="width:70%" | ||
Revision as of 17:07, 13 February 2023
The query SELECT tran.tran_id,text=concat(concat("aap","noot"),tran_text) FROM `tran`,`trpr` WHERE tran.tran_id=trpr.tran_id and prop_id = {{{1}}} is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Template:1}' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT tran.tran_id,text=concat(concat("aap","noot"),tran_text) FROM `tran`,`trpr` WHERE tran.tran_id=trpr.tran_id and prop_id = {{{1}}} ).
| Id | Text |
|---|