Difference between revisions of "Example datanavigation rsp"

From Lianjapedia
Jump to: navigation, search
 
Line 1: Line 1:
 
{{DISPLAYTITLE:Lianja Server Page Example}}
 
{{DISPLAYTITLE:Lianja Server Page Example}}
==Name==
 
example_datanavigation.rsp
 
 
==Description==
 
 
Example [[Visual FoxPro Server Pages|Visual FoxPro Server Page (.rsp)]] demonstrating basic data navigation.
 
Example [[Visual FoxPro Server Pages|Visual FoxPro Server Page (.rsp)]] demonstrating basic data navigation.
  

Latest revision as of 23:07, 7 April 2019

Example Visual FoxPro Server Page (.rsp) demonstrating basic data navigation.

Code

<%@ Language=VFP %>
<html>
<body>
<%
    // Open the database
    open database southwind
    ? "<br>"
 
    // Open the table
    use customers
 
%>
<table>
<tr>
<%
     // Display the table headings
    for i = 1 to fcount()
        ? "<td>" + field(i) + "</td>"
    next
%>
</tr>
<%
    // Display the data in a table
    scan
        ? "<tr valign='top'>"
        for i = 1 to fcount()
            ? "<td>"
            ? &(field(i))
            ? "</td>"	
        next
        ? "</tr>"
    endscan
    // close the table and the database
    use
    close database
%>
</table>
</body>
</html>