Difference between revisions of "EXECJSSP()"

From Lianjapedia
Jump to: navigation, search
(Created page with "==Purpose== Function to execute a jssp script ==Syntax== EXECJSSP(<expC1> [, <expC2>]) ==See Also== DO, EXECJAVASCRIPT(), EXECPHP(), EXECPYTHON(), EXECRSP(...")
 
m (Yvonne.milne moved page Execjssp() to EXECJSSP())
(No difference)

Revision as of 07:33, 7 April 2017

Purpose

Function to execute a jssp script

Syntax

EXECJSSP(<expC1> [, <expC2>])

See Also

DO, EXECJAVASCRIPT(), EXECPHP(), EXECPYTHON(), EXECRSP(), EXECSCRIPT(), JavaScript Server Pages, SPAWN, Lianja/VFP Server Pages

Description

The EXECJSSP() function executes the specified JavaScript Server page (.jssp page). The name of the jssp 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=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();
	}
	print("</table>");
	rs.close();
	db.close();
%>
</body>
</html>