Difference between revisions of "Example datanavigation rsp"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Name== ''example.rsp'' ==Description== ==Code== <code lang="recital"> <%@ Language=VFP %> <html> <body> <% // Open the database open database southwind ? "<br>" //...") |
Barrymavin (Talk | contribs) |
||
| (14 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{DISPLAYTITLE:LianjaScript Server Page Example}} | |
| − | + | Example [[Visual FoxPro Server Pages|LianjaScript Server Page (.rsp)]] demonstrating basic data navigation. | |
| − | + | ||
| − | + | ||
| − | + | ||
==Code== | ==Code== | ||
| Line 12: | Line 9: | ||
<body> | <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> | </body> | ||
</html> | </html> | ||
</code> | </code> | ||
| − | [[Category: | + | [[Category:VisualFoxProCodeExamples]] |
Latest revision as of 04:40, 29 April 2024
Example LianjaScript 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>
