Difference between revisions of "EXECPYSP()"

From Lianjapedia
Jump to: navigation, search
(Created page with "==Purpose== Function to execute a pysp script ==Syntax== EXECPYSP(<expC1> [, <expC2>]) ==See Also== DO, EXECJAVASCRIPT(), EXECPHP(), EXECPYTHON(), EXECRSP(...")
 
(See Also)
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[DO]], [[EXECJAVASCRIPT()]], [[EXECPHP()]], [[EXECPYTHON()]], [[EXECRSP()]], [[EXECSCRIPT()]], [[JavaScript Server Pages]], [[SPAWN]], [[Visual FoxPro Server Pages|Lianja/VFP Server Pages]]  
+
[[DO]], [[EXECJAVASCRIPT()]], [[EXECPHP()]], [[EXECPYTHON()]], [[EXECRSP()]], [[EXECSCRIPT()]], [[EXECJSSP()]],  [[JavaScript Server Pages]], [[SPAWN]], [[Visual FoxPro Server Pages|Lianja/VFP Server Pages]]
  
 
==Description==
 
==Description==

Revision as of 00:40, 19 April 2021

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>