YadaTest: Difference between revisions
Yadasampati (talk | contribs) No edit summary |
Yadasampati (talk | contribs) No edit summary |
||
| Line 4: | Line 4: | ||
{{#get_db_data: | {{#get_db_data: | ||
db=vanisearch | db=vanisearch | ||
|from=tran | |from= tran=T,trpr=P | ||
|where=vani_id=5 and | |join on= T.tran_id = P.tran_id | ||
|data=text=tran_text,id=tran_id | |where= T.vani_id=5 and P.prop_id =1 | ||
|data=text=T.tran_text,id=T.tran_id | |||
}} | }} | ||
{| class="wikitable" style="width:70%" | {| class="wikitable" style="width:70%" | ||
Revision as of 13:03, 13 February 2023
The query SELECT t.tran_text,t.tran_id FROM `tran` `T`,`trpr` `P` WHERE T.vani_id=5 and P.prop_id =1 is invalid (Error 1054: Unknown column 't.tran_text' in 'field list' Function: EDConnectorRdbms::fetch Query: SELECT t.tran_text,t.tran_id FROM `tran` `T`,`trpr` `P` WHERE T.vani_id=5 and P.prop_id =1 ).
| Id | Text |
|---|
Krsna says 'Me'
Krsna says 'My'
Krsna says 'Mine'