Template

DataTabSheet: Difference between revisions

No edit summary
No edit summary
Line 10: Line 10:
! style="padding:5px; font-weight:bold"| Id
! style="padding:5px; font-weight:bold"| Id
! style="padding:5px; font-weight:bold"| Vers
! style="padding:5px; font-weight:bold"| Vers
! style="padding:5px; font-weight:bold"| Text {{#for_external_table:
! style="padding:5px; font-weight:bold"| Text {{#for_external_table:<nowiki />
{{!}}-
{{!}}-
{{!}} class="cw_0" {{!}} {{{from}}}
{{!}} class="cw_0" {{!}} {{{from}}}
{{!}} class="cw_0" {{!}} {{{until}}}
{{!}} class="cw_0" {{!}} {{{until}}}
{{!}} class="cw_50" style="text-align:right; vertical-align:top; padding:0" {{!}} {{{id}}}
{{!}} class="cw_50" style="text-align:right; vertical-align:top; padding:0" {{!}} {{{id}}}
{{!}} class="cw_150" style="vertical-align:top; padding:0" {{!}} [[https://vanisource.org/wiki/{{{vref}}}_(1972)|{{{vref}}}]]
{{!}} class="cw_150" style="vertical-align:top; padding:0" {{!}} [[{{{vref}}}{{|}}{{{vref}}}]]
{{!}} class="cw_500" style="padding:0" {{!}} {{{text}}}
{{!}} class="cw_500" style="padding:0" {{!}} {{{text}}}
}}
}}
|}
|}

Revision as of 19:33, 13 February 2023

The query SELECT trpr_from,trpr_until,tran.tran_id,replace(vers_ref," ","_"),tran_text FROM `tran`,`trpr`,`vers` WHERE tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_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 trpr_from,trpr_until,tran.tran_id,replace(vers_ref," ","_"),tran_text FROM `tran`,`trpr`,`vers` WHERE tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}} ).

from until Id Vers Text