Example datanavigation jssp
From Lianjapedia
Name
example_datanavigation.jssp
Description
Example JavaScript Server Page (.jssp page) demonstrating basic data navigation.
Code
<%@ Language=JavaScript %> <html> <body> <% // Note that just as in PHP, JavaScript Server Pages can use include_once(filename) and include(filename) // The path of the filename is relative to the directory containing this script. include_once("library_example.js"); // The Lianja global object provides embedded database access db = Lianja.openDatabase("southwind"); print("<br>"); // Lianja.openDatabase() returns a Database object so now we can open a RecordSet rs = db.openRecordSet("select * from customers"); print("<br>"); print("Fieldcount="+rs.fieldcount); print("<br>"); %> <table> <% print("<tr>"); for (i=0; i<rs.fieldcount; ++i) { print("<td>"+rs.field(i).name+"</td>"); } print("</tr>"); rs.moveFirst(); for (j=0; j<rs.reccount; ++j) { print("<tr valign='top'>"); for (i=0; i<rs.fieldcount; ++i) { print("<td>"+rs.field(i).value+"</td>"); } print("</tr>"); rs.moveNext(); } rs.close(); db.close(); %> </table> </body> </html>
