delete=pmt_utils.executeSQL(db, sqlStatement)
if delete['status']!='success':
message=delete['message']
else:
message="The option '%s' has been removed from %s" % (option,table)
return message
#------------------------------------------------------------------------------
#------------------------------------------------------------------------------
pmt_utils.htmlContentType()
form = pmt_utils.getFormData()
db_name=declarations.pmt_info['db_name']
username,password=pmt_utils.getUserPass(form)
print "<HTML>"
print "<HEAD>"
pmt_utils.title("Edit Project Options")
print "</HEAD>"
pmt_utils.bodySetup()
pmt_utils.mainHeading("Project Option Manager")
pmt_utils.subHeading("Add/Delete Options")
if username!=None:
dbResult=pmt_utils.connectDB(declarations.pmt_info['browser_username'],
declarations.pmt_info['browser_password'],
declarations.pmt_info['db_name'])
}
function displaySearch() {
window.open("/search.html","Search_Help","scrollbars=yes,resizable=no,height=200,width=300");
}
</script>"""
print '<BODY LINK="white" bgcolor="#000080">'
print "<TABLE BORDER=0 CELLPADDING=1 CELLSPACING=0></TABLE>"
print "<TABLE CELLPADDING=1 CELLSPACING=0></TABLE>"
print '<center>'
print '<A HREF="/%s/html/siteInfo.html" target="siteInfo">' % db
print '<img src="/%s/icons/%s.jpg" width=125></A></center>' % (db, db)
print '<center>'
username, password = pmt_utils.getUserPass(None)
if username != None and password != None:
dbResult = pmt_utils.connectDB(declarations.pmt_info['browser_username'],
declarations.pmt_info['browser_password'],
declarations.pmt_info['db_name'])
if dbResult['status'] != 'success':
pmt_utils.alertsArea(None, dbResult['message'])
sys.exit()
else:
DB = dbResult['result']
print '<img src=/%s/icons/top.gif usemap="#top" border=0><br>' % db
#print db