| Wayne State University College of Lifelong Learning Interdisciplinary Studies Program, Fall, 1999 http://www.cll.wayne.edu/isp/drbowen/internet Instructor email: d.r.bowen@wayne.edu Instructor tel (WSU) (313) 577-1498 / (Home) (248) 549-8518 |
eCommerce: Using the Web to Find and Service
Customers AGS 3360 Section 986 Call Number 99882 or ISP 5500 Section 982 Call Number 90569 |
Last updated: 11/17/99
Link back to course Welcome
iHTML
for AGS 3360: eCommerce
| <imail | address="recipient email address" | |
| [from="sender's email address"] | [] indicate optional field | |
| [host="SMTP mail host name"] | use "smtp.wayne.edu" | |
| [subject="subject of message"] | ||
| [output="message if email is successful"] | goes in response to user | |
| [replyto="reply email address']> | ||
| Email message goes here. Can contain : variables. | ||
| </imail> | ||
| <iHTML | dbname="DataSource Name" | Use Team DSN |
| sql="insert into tablename (list of fieldnames) | Separate field names with commas | |
| values ('value1', 'value2', 'value3' ... 'lastvalue')" | Values can also be colon variables from form | |
| FAILURE="Error: :i_error :i_errortext :i_sqlerrortext<br>"> | Displays an error message if tag fails. Useful for debugging, but you don't want your users seeing this! |
Example iHTML file
<!ihtml>
<!-- Inserting the Current Information into the Plan Table -->
<iHTML DBNAME="new_pw"
SQL="Insert into Plan(StudentID, CoursePrefix, CourseNumber, SectionNumber,
CallNumber, Credit, Grade, Semester, Year, Location,
Department, Times, Day, Category, Transfer, DateEnt, PersonEnt, GenEd)
values (':StudentID', ':CName', ':CNo',
':SNo', ':Call', ':CCredit', ':CGrade', ':CSemester',
':CYear', ':CLocation', ':CDepartment', ':CTime',
':CDay', ':CCategory', ':CTransfer', ':CDateEnt',
':CPersonEnt', ':CGen') "
ESC="FALSE"
FAILURE="Error: :i_error :i_errortext :i_sqlerrortext<br>">
<!-- Display information on the Logout Page -->
<html>
<head>
</head>
<body bgcolor="#336699" link=red>
<font color="white" face="arial rounded mt bold"><strong>The information of
<i>:FName </i> has been stored in the database and <br>an email has been
sent to the Counsellor.</strong>
<br><br><br>
<font size="+1"><center>You have successfully Logged out of <br>
Plan of Work Page.<br>
<br><br>
<p align=left><font color="red">Warning! </font><font color="yellow">To
prevent others from viewing or using your information be sure to exit or close
your web browser. (Usually this is Netscape Navigator or Internet Explorer.)
</font></p>
</body></html><br>
<!-- Automatic Email generation -->
<iMAIL ADDRESS=":c_email"
FROM="webserver@cll.wayne.edu"
HOST="cll.wayne.edu"
SUBJECT="Plan of Work" >
:FName :LName (:StudentID) has updated on line plan of work.
</iMAIL>