Difference between revisions of "Recital Web Tutorial"

From Recital Documentation Wiki
Jump to: navigation, search
Line 64: Line 64:
 
use example
 
use example
 
append blank
 
append blank
replace ACCOUNT_NO with _post.account_no, TITLE with _post.title, LAST_NAME with _post.last_name,;
+
replace ACCOUNT_NO with _post.account_no, TITLE with _post.title, LAST_NAME with _post.last_name,
  FIRST_NAME with _post.first_name, INITIAL with _post.initial, STREET with _post.street,;
+
  FIRST_NAME with _post.first_name, INITIAL with _post.initial, STREET with _post.street,
  CITY with _post.city, STATE with _post.state, ZIP with _post.zip, LIMIT with val(_post.limit),;
+
  CITY with _post.city, STATE with _post.state, ZIP with _post.zip, LIMIT with val(_post.limit),
  BALANCE with val(_post.balance), AVAILABLE with val(_post.available), NOTES with _post.notes,;
+
  BALANCE with val(_post.balance), AVAILABLE with val(_post.available), NOTES with _post.notes,
 
  START_DATE with ctod(_post.start_date)
 
  START_DATE with ctod(_post.start_date)
 
? "Data updated"
 
? "Data updated"

Revision as of 11:32, 11 March 2010

Simple POST Form

Create an input form in your preferred HTML editor, set the form method to post and the form action to an rsp file:

<html>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="handle_it.rsp">
<p> Account_no: 
<input type="text" name="account_no">
<br>
Title: 
<input type="text" name="title">
<br>
Last_name: 
<input type="text" name="last_name">
<br>
First_name: 
<input type="text" name="first_name">
<br>
Initial: 
<input type="text" name="initial">
<br>
Street: 
<input type="text" name="street">
<br>
City: 
<input type="text" name="city">
<br>
State: 
<input type="text" name="state">
<br>
Zip: 
<input type="text" name="zip">
<br>
Limit: 
<input type="text" name="limit">
<br>
Balance: 
<input type="text" name="balance">
<br>
Available: 
<input type="text" name="available">
<br>
Notes: 
<input type="text" name="notes">
<br>
Start_date: 
<input type="text" name="start_date">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>

Create the form handler rsp file. This is coded in Recital and the form data can be accessed from the _post[] dynamic array. Any ? display commands will be sent to the browser client.

<%
open database southwind
use example
append blank
replace ACCOUNT_NO with _post.account_no, TITLE with _post.title, LAST_NAME with _post.last_name,
 FIRST_NAME with _post.first_name, INITIAL with _post.initial, STREET with _post.street,
 CITY with _post.city, STATE with _post.state, ZIP with _post.zip, LIMIT with val(_post.limit),
 BALANCE with val(_post.balance), AVAILABLE with val(_post.available), NOTES with _post.notes,
 START_DATE with ctod(_post.start_date)
? "Data updated"
close data
%>
<body bgcolor="#FFFFFF" text="#000000">
</body>