dbconnect(); company = database.cursor("SELECT * FROM Companies ORDER BY Companyname") if(request.fillin) { // This cursor retrieves company info to help // fill in some of the contact information if requested. compinfo = database.cursor("SELECT * FROM Companies WHERE companyname = '" + request.companyname + "'") } else { if(request.firstname && request.lastname) { // inserts the contact information into the Contacts table. database.execute("INSERT INTO Contacts (Firstname, Lastname, Dear, Companyname, Address, City, StateOrProvince, Postalcode, Country, Title, WorkPhone, WorkExtension, FaxNumber, HomePhone, Pager, MobilePhone, Emailname, LastMeetingDate, ContactTypeid, ReferredBy, Notes) VALUES ('" + request.firstname + "','" + request.lastname + "','" + request.dear + "','" + request.companyname + "','" + request.address + "','" + request.city + "','" + request.stateorprovince + "','" + request.postalcode + "','" + request.country + "','" + request.title + "', '" + request.workphone + "','" + request.workextension + "','" + request.faxnumber + "','" + request.homephone + "','" + request.pager + "','" + request.mobilephone + "','" + request.emailname + "','" + request.lastmeetingdate + "','" + request.contacttypeid + "','" + request.referredby + "','" + request.notes + "')"); redirect("contact.html?newsearch=contact"); } }
New Contact Information
if(request.fillin) { // This section of code is executed when the 'Use Defaults' // button is clicked. write("
First Name*:
") write("
Last Name*:
") write("
Dear:
") write("
Title:
") if(compinfo.next()) { // company information is outputted here for the company chosen. write("
Company:
") write("
") write("
" + request.companyname) write("
-----------------") while(company.next()) { write("
" + company.companyname) } write("
") write("
Address:
") write("
City:
") write("
State:
") write("
Zip:
") write("
Country:
") write("
Work Phone:
") } } else { // This is the form used to add a contact. There is a button // that lets you use company information as default to fill in basic // contact information. When the 'Use Defaults' button is clicked, the // if section of this if/else statement is executed. write("
First Name*:
") write("
Last Name*:
") write("
") write("
Dear:
") write("
Title:
") write("
") write("
Company:
") write("
") while(company.next()) { write("
" + company.companyname) } write("
") write("
Address:
") write("
City:
") write("
State:
") write("
Zip:
") write("
Country:
") write("
Work Phone:
") }
Work Ext.:
Home Phone:
Mobile Phone:
Fax Number:
Pager:
Email:
Contact Type:
Last Meeting Date:
Referred By:
Notes:
* Required Fields