YadaTest: Difference between revisions
Yadasampati (talk | contribs) No edit summary |
Yadasampati (talk | contribs) No edit summary |
||
| Line 3: | Line 3: | ||
{{#get_db_data: | {{#get_db_data: | ||
db=vanisearch | db= vanisearch | ||
|from= tran=T,trpr=P | |from= tran=T,trpr=P | ||
|join on= T.tran_id = P.tran_id | |join on= T.tran_id=P.tran_id | ||
|where= T.vani_id=5 and P.prop_id =1 | |where= T.vani_id=5 and P.prop_id=1 | ||
|data=text=T.tran_text,id=T.tran_id | |data= text=T.tran_text,id=T.tran_id | ||
}} | }} | ||
{| class="wikitable" style="width:70%" | {| class="wikitable" style="width:70%" | ||
Revision as of 13:06, 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'