EXECPYSP()
From Lianjapedia
Revision as of 00:40, 19 April 2021 by Barrymavin (Talk | contribs)
Contents
Purpose
Function to execute a pysp script
Syntax
EXECPYSP(<expC1> [, <expC2>])
See Also
DO, EXECJAVASCRIPT(), EXECPHP(), EXECPYTHON(), EXECRSP(), EXECSCRIPT(), EXECJSSP(), JavaScript Server Pages, SPAWN, Lianja/VFP Server Pages
Description
The EXECJSSP() function executes the specified Python Server page (.pysp page). The name of the pysp file is specified in <expC1> along with any required parameters. The optional <expC2> is the name of the output file that the generated HTML will be sent to. If no output file is specified, it will be sent to the current output.
Example
execJSSP("test.jssp","test.html")
test.jssp
<%@ Language=JavaScript %> <html> <body> <% db = Lianja.openDatabase("southwind") rs = db.openRecordSet("select * from customers") print("<table><tr>") for i in range(rs.fields.count): print("<td>"+rs.field(i).name+"</td>") print("</tr>") rs.moveFirst(); for i in range(rs.reccount): print("<tr valign='top'>") for i in range(rs.fields.count): print("<td>"+rs.field(i).value+"</td>") print("</tr>"); rs.moveNext(); print("</table>") rs.close() db.close() %> </body> </html>