Difference between revisions of "Recital Web Tutorial"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
 
==Simple POST Form==
 
==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.
+
Create an input form in your preferred HTML editor, set the form method to '''post''' and the form action to an rsp file.  Save the file in a '''samples''' sub-directory of [[DB_WWWROOT]].
  
 
'''example_form.htm:'''
 
'''example_form.htm:'''
Line 59: Line 59:
 
</code>
 
</code>
  
Create an rsp wrapper file for the html file.
+
Create an rsp wrapper file for the html file in the ''samples'' directory.
  
 
'''form_example.rsp:'''
 
'''form_example.rsp:'''
Line 74: Line 74:
  
 
</code>
 
</code>
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.  Convert any data types before loading the '''post[]''' data into the table.
+
Create the form handler rsp file in the ''samples'' directory.  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.  Convert any data types before loading the '''post[]''' data into the table.
  
 
'''handle_it.rsp:'''
 
'''handle_it.rsp:'''

Revision as of 14:27, 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. Save the file in a samples sub-directory of DB_WWWROOT.

example_form.htm:

<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 an rsp wrapper file for the html file in the samples directory.

form_example.rsp:

<%@ Language=Recital %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Recital Web Sample Form</title>
</head>
<%@ include="/samples/example_form.htm" %>
</html>

Create the form handler rsp file in the samples directory. 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. Convert any data types before loading the post[] data into the table.

handle_it.rsp:

<%
_post.start_date = ctod(_post.start_date)
open database southwind
insert into example from name _post
? "Data updated"
close databases
%>
<body bgcolor="#FFFFFF" text="#000000">
</body>

Run the form:

http://myserver:8001/samples/form_example.rsp