DataTabSheet: Difference between revisions

Revision as of 17:51, 13 February 2023

The query SELECT tran.tran_id,tran_text,trpr_from,trpr_until 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,tran_text,trpr_from,trpr_until FROM `tran`,`trpr` WHERE tran.tran_id=trpr.tran_id and prop_id = {{{1}}} ).

Id	Text

@@ Line 3: / Line 3: @@
   |from= tran,trpr
   |where= tran.tran_id=trpr.tran_id and prop_id = {{{1}}}
-  |data= id=tran.tran_id,text=tran_text
+  |data= id=tran.tran_id,text=tran_text,from=trpr_from,until=trpr_until
 }}
 {| class="wikitable" style="width:70%"
@@ Line 9: / Line 9: @@
 ! style="padding:5px; font-weight:bold"| Text {{#for_external_table:<nowiki />
 {{!}}-
+{{!}} class="cw_0" {{!}} {{{from}}}
+{{!}} class="cw_0" {{!}} {{{until}}}
 {{!}} style="text-align:right; vertical-align:top; padding:0" {{!}} {{{id}}}
 {{!}} style="padding:0; width:500px" {{!}} {{{text}}}
 }}
 |}