Recital Web Tutorial
From Recital Documentation Wiki
Revision as of 13:02, 22 June 2011 by Yvonnemilne (Talk | contribs)
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 (by default, /opt/recital/webroot/recital).
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 (CTOD()) 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/example_form.htm
