Python Server Page Example
Code
<%@ Language=Python %> <!DOCTYPE html> <html> <head> <meta charset='utf-8'> <meta name='viewport' content='width=device-width, initial-scale=1.0'> <link rel='stylesheet' href='../../library/bootstrap/css/bootstrap.min.css' type='text/css'/> <link rel='stylesheet' href='../../library/bootstrap-3.3.4/css/bootstrap.min.css'> <script src='../../library/jquery-1.10.2/jquery-1.10.2.min.js' type='text/javascript'></script> <script src='../../library/bootstrap-3.3.4/js/bootstrap.min.js' type='text/javascript'></script> <style> .tablecaption { background: gray; font-weight: bold; color: white; text-align:center; } </style>
</head> <body style="margin:10px;"> <% import Lianja
- open the southwind database
db = Lianja.openDatabase("southwind")
- open a recordset
rs = db.openRecordSet("select * from example")
- main table
" + rs.fields(j).name + " | ") print("|
---|---|
$%.2f | " % rs.fields(j).value)%s | " % rs.fields(j).value) print("
- Close the RecordSet
rs.close()
%> </body> </html> </code>