if(request.log) { redirect("comframe.html?contactid=" + request.id); } dbconnect(); contact = database.cursor("SELECT * FROM Contacts WHERE contactid = " + request.id) company = database.cursor("SELECT * FROM Companies ORDER BY Companyname") //Performs an update on the contact information if the user clicks update. if(request.up) { database.execute("UPDATE Contacts SET Firstname='" + request.firstname + "', Lastname='" + request.lastname + "', Dear='" + request.dear + "', Companyname='" + request.companyname + "', Address='" + request.address + "', City='" + request.city + "', StateOrProvince='" + request.stateorprovince + "', Postalcode='" + request.postalcode + "', Country='" + request.country + "', Title='" + request.title + "', WorkPhone='" + request.workphone + "', WorkExtension='" + request.workextension + "', FaxNumber='" + request.faxnumber + "', HomePhone='" + request.homephone + "', Pager='" + request.pager + "', MobilePhone='" + request.mobilephone + "', Emailname='" + request.emailname + "', LastMeetingDate='" + request.lastmeetingdate + "', ContactTypeid='" + request.contacttypeid + "', ReferredBy='" + request.referredby + "', Notes='" + request.notes + "' WHERE contactid = " + request.id) redirect("contact.html"); } //Performs a delete if the user clicks delete. if(request.del) { database.execute("DELETE FROM Contacts WHERE contactid =" + request.id) redirect("contact.html") } ")
if(client.search1) { write("
") } if(client.search2) { write("") } write("") write("

View/Edit Contact Information
//Outputs detailed contact info. if(contact.next()) { write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("
First Name*Last Name*
TitleDear
Company Name
Address
CityCountry
State/ProvincePostal Code
Work PhoneWork Ext.
Home PhonePager
Mobile PhoneFax Number
Email
Referred ByContact Type
Last Meeting date
Notes
") write("") }

* Required Fields