DataTabSheet: Difference between revisions
Yadasampati (talk | contribs) No edit summary |
Yadasampati (talk | contribs) No edit summary |
||
| Line 2: | Line 2: | ||
db= vanisearch | db= vanisearch | ||
|from= tran,trpr,vers | |from= tran,trpr,vers | ||
|where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id | |where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}} | ||
|data= from=trpr_from,until=trpr_until,id=tran.tran_id,vref=vers_ref,text=tran_text | |data= from=trpr_from,until=trpr_until,id=tran.tran_id,vref=vers_ref,text=tran_text | ||
}} | }} | ||
Revision as of 19:14, 13 February 2023
The query SELECT trpr_from,trpr_until,tran.tran_id,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,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 |
|---|