PDA

View Full Version : Exporting data using Lianja SQL extensions



barrymavin
2012-10-31, 05:29
With the introduction of Virtual Tables in Beta10, if you have a need to query data from any native lianja or other third party data source and export it into HTML, JSON or XML you can do it in one command like this.



select * from mytable where accno="xzy" into html filename.htm
select * from mytable where accno="xzy" into json filename.json
select * from mytable where accno="xzy" into html filename.xml


If you need to output this into a WebView you can do this in one command like this.



select * from mytable where accno="xzy" into html console
select * from mytable where accno="xzy" into json console
select * from mytable where accno="xzy" into html console


Quite a time saver.