Advertisement
Advertisement
| 07.11.2008 at 07:34AM PDT, ID: 23557336 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: |
<!--#include virtual="/adovbs.inc"-->
<%
'the code below will do the insert
set adoCon = Server.CreateObject("ADODB.Connection")
MyConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("photorequest.mdb")
adoCon.mode = 3
adoCon.open MyConnString
MySQL = "INSERT INTO MASTER_Rolodex (DailyDBField,SearchDBField,ArchiveDBField, ProcessDBField, ScanDBField, EmailDBField, SourceBladeDBField, SourceAPDBField, SourceOtherDBField, YesDBField, NoDBField) VALUES " _
& "('"&request.form("Daily")&"','"&request.form("Search")&"','"&request.form("Archive")&"',"_
&"'"&request.form("Process")&"','"&request.form("Scan")&"','"&request.form("Email")&"',"_
&"'"&request.form("SourceBlade")&"','"&request.form("SourceAP")&"','"&request.form("SourceOther")&"',"_
&"'"&request.form("Yes")&"','"&request.form("No") & "')"
adoCon.execute (MySQL)
set rsMasterRolodex =adoCon.execute("SELECT * from MASTER_Rolodex where ID_no = "&request.form("ID")&" ")
%>
<html>
<head>
<title>ART Department Update Form</title>
</head>
<p align="center">
<img border="0" src="../SEARCHES/images2/combo%20blade%20logos.gif" width="184" height="41" align="middle"><p align="center">
<font color="#004080">
<font face="Arial" style="font-size: 22pt"><b>SUBMITTED PHOTO REQEUST</b><br>
</font><font face="Arial">When photo editors are finished, they should fill in the "Status" Field at
the bottom and click
UPDATE. <br>
</font></font><hr width="54%" color="#004080">
<body bgcolor="white" text="black"><form name="form" method="post" action="PhotoUpdate_entry.asp">
<div align="center">
<table border="0" cellspacing="0" width="701" height="750" id="table1" style="border: 1px solid #808080">
<tr>
<td width="153" bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #808080">
<span style="background-color: #FFFFD7"><b>
<font face="Arial" color="#247BAF"> Ordered By</font></b></span><font color="#247BAF"><span style="background-color: #FFFFD7">
</span>
</font> </td>
<td bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #808080">
<font color="#247BAF">
<input type="text" name="OrderedBy" value="<%=rsMasterRolodex("OrderedBy")%>" readonly="readonly" size="20" />
<span style="background-color: #FFFFD7"> </span></font><font face="Arial" color="#247BAF"><span style="background-color: #FFFFD7"> <b>Publication
Date</b></span></font><font color="#247BAF"><span style="background-color: #FFFFD7"> </span> <input type="text" name="PubDate" maxlength="60" value="<% = rsMasterRolodex("PubDate")%> "readonly="readonly" size="12" /> <span style="background-color: #FFFFD7"><b> </b></span><font face="Arial"><b><span style="background-color: #FFFFD7">Deadline</span></b></font></font><font face="Arial"><b><font color="#247BAF"><span style="background-color: #FFFFD7"> </span></font>
</b>
</font>
<font color="#247BAF">
<input type="checkbox" name="Daily" <%if rsMasterRolodex.fields("DailyDBField").value = "ON" then response.write("checked='checked'")%>></font></td>
</tr>
<tr>
<td width="153" bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #808080">
<b>
<font face="Arial" color="#247BAF"><span style="background-color: #FFFFD7">
Story/Slug</span></font><font color="#247BAF"><span style="background-color: #FFFFD7">
</span>
</font> </b> </td>
<td bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #808080">
<font color="#247BAF">
<input type="text" name="Story" maxlength="60" value="<% = rsMasterRolodex("Story") %>"readonly="readonly" size="20" /> <font face="Arial"><b><span style="background-color: #FFFFD7">Phone</span></b></font></font><font color="#247BAF" face="Arial"><span style="background-color: #FFFFD7"> </span> </font>
<font color="#247BAF"> <input type="text" name="Ext" maxlength="60" value="<% = rsMasterRolodex("Ext") %>"readonly="readonly" size="20" /></font></td>
</tr>
<tr>
<td width="153" bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<b>
<font face="Arial">
<span style="background-color: #FFFFD7"><font color="#247BAF"> Department</font></span></font><font color="#247BAF"><span style="background-color: #FFFFD7"><font face="Arial"> </font>
</span>
</font>
</b></td>
<td bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<font color="#247BAF">
<input type="text" name="Depart" maxlength="80" value="<% = rsMasterRolodex("Depart") %> "size="20" />
<font face="Arial"><b>Requested Service</b></font> <br>
<input type="checkbox" name="Search" <%if rsMasterRolodex.fields("SearchDBField").value = "ON" then response.write("checked='checked'")%>>
</font>
<font color="#247BAF" face="Arial">
<span style="font-size: 9pt; font-weight: 700">Search </span></font><span style="font-size: 9pt"><font color="#247BAF" face="Arial">
<input type="checkbox" name="Archive" <%if rsMasterRolodex.fields("ArchiveDBField").value = "ON" then response.write("checked='checked'")%>></font></span><font color="#247BAF" face="Arial"><span style="font-size: 9pt; font-weight: 700">Archive </span>
<span style="font-size: 9pt">
<input type="checkbox" name="Process" <%if rsMasterRolodex.fields("ProcessDBField").value = "ON" then response.write("checked='checked'")%>><b>Process</b></span><span style="font-size: 9pt; font-weight: 700"> </span><span style="font-size: 9pt">
<input type="checkbox" name="Scan" <%if rsMasterRolodex.fields("ScanDBField").value = "ON" then response.write("checked='checked'")%>><b>Scan</b>
<input type="checkbox" name="Email" <%if rsMasterRolodex.fields("EmailDBField").value = "ON" then response.write("checked='checked'")%>>
<b>E-mail</b>
</span></b></font>
</td>
</tr>
<tr>
<td width="153" bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" valign="top" height="74">
<span style="background-color: #FFFFD7"><font color="#247BAF" face="Arial"><b>
<br>
Editor</b></font></span><b><font color="#247BAF"><span style="background-color: #FFFFD7"> </span></font>
</b> </td>
<td bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" height="74">
<font color="#247BAF">
<input type="text" name="Editor" maxlength="60" value="<% = rsMasterRolodex("Editor") %>"readonly="readonly" size="21" />
<span style="font-weight: 700; background-color: #FFFFD7">
<font face="Arial">Story Search</font> </span>
<span style="background-color: #FFFFD7"> </span>
<input type="checkbox" name="SourceBlade" <%if rsMasterRolodex.fields("SourceBladeDBField").value = "ON" then response.write("checked='checked'")%>>
</font><font color="#247BAF" face="Arial">
<span style="font-size: 9pt; font-weight: 700">Blade </span>
<font color="#247BAF">
<input type="checkbox" name="SourceAP" <%if rsMasterRolodex.fields("SourceAPDBField").value = "ON" then response.write("checked='checked'")%>>
<span style="font-weight: 700; font-size: 9pt">AP</span> <input type="checkbox" name="SourceOther" <%if rsMasterRolodex.fields("SourceOtherDBField").value = "ON" then response.write("checked='checked'")%>><span style="font-size: 9pt; font-weight: 700">Other</span>
</b></font><b><font size="2" color="#247BAF"> </font>
<font face="Arial"><span style="background-color: #FFFFD7">
<font color="#247BAF">Photo to be returned</font></span><font size="2" color="#247BAF"><span style="background-color: #FFFFD7">
</span> </font>
</font></b><font color="#247BAF" face="Arial">
<input type="checkbox" name="Yes" <%if rsMasterRolodex.fields("YesDBField").value = "ON" then response.write("checked='checked'")%>></font><span style="font-size: 9pt"><b>Yes</b></span>
<input type="checkbox" name="No" <%if rsMasterRolodex.fields("NoDBField").value = "ON" then response.write("checked='checked'")%>>
<font color="#247BAF" face="Arial" style="font-size: 9pt"><b>No</b></font></td>
</tr>
<tr>
<td width="153" height="162" valign="top" bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<b>
<font face="Arial" color="#004080"><br>
<br>
</font>
<font face="Arial" color="#247BAF"><span style="background-color: #FFFFD7">
Description
</span></font>
<font face="Arial" color="#004080">
<br>
</font></b></td>
<td height="162" valign="top" bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<br>
<textarea name="Description" cols="59" rows="7"><%=rsMasterRolodex("Description")%></textarea>
</td>
</tr>
<tr>
<td width="153" valign="top" height="238" bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<b><span style="background-color: #FFFFD7">
<font face="Arial" color="#247BAF"> PHOTO<br>
PROCESSING</font></span></b><font face="Arial" color="#004080">
<br>
</font></td>
<td valign="top" height="238" bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<font face="Arial"><b><font color="#247BAF"><font size="2">SLUG </font>
</font></b><font color="#247BAF" face="Aachen">
<input name="Slug" maxlength="60" value="<% = rsMasterRolodex("Slug") %>"readonly="readonly" size="20" /></font><font color="#247BAF"><br>
<br>
<b>
<font size="2">COLOR</font> </b>
<input name="Color" maxlength="60" value="<% = rsMasterRolodex("Color") %>"readonly="readonly" size="20" />
<br>
<br>
<b>
<font size="2">PUBLICATION DATE</font></b>
<input name="Date" maxlength="60" value="<% = rsMasterRolodex("Date") %>"readonly="readonly" size="20" /><br>
<br>
<b>
<font size="2">SIZE</font></b>
<input name="Size" maxlength="60" value="<% = rsMasterRolodex("Size") %>"readonly="readonly" size="20" /><br>
<br>
<font size="2"><b>B/W</b> </font>
<input name="BW" maxlength="60" value="<% = rsMasterRolodex("BW") %>"readonly="readonly" size="20" /><br>
<b>
<br>
<font size="2">EDITION</font></b></font></font><b> </b>
<input type="text" name="Edition" maxlength="60" value="<% = rsMasterRolodex("Edition") %>"readonly="readonly" size="20" /></td>
</tr>
<tr>
<td width="153" bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<font color="#247BAF">
<b>
<font face="Arial"><span style="background-color: #FFFFD7"> Submitted</span></font><span style="background-color: #FFFFD7">
</span></b> </font>
<font color="#004080">
</font>
</td>
<td bgcolor="#FFFFD7" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<input type="text" name="Dateandtime" maxlength="60" value="<% = rsMasterRolodex("Dateandtime") %>"readonly="readonly" size="15" />
</td>
</tr>
<tr>
<td width="153" bgcolor="#FFFFD7">
<b>
<font face="Arial" color="#247BAF"><span style="background-color: #FFFFD7"> UPDATE<br>
Status </span></font><font face="Arial" color="#800000"><br>
</font></b></td>
<td bgcolor="#FFFFD7">
<input type="text" name="Status" maxlength="80" value=""/><% = rsMasterRolodex("Status") %>
<input type="submit" name="Submit" value="UPDATE" style="color: #247BAF; text-transform: uppercase; font-weight: bold">
<span style="font-size: 9pt; background-color: #FFFFFF"> <font color="#004080">
<br>
<br>
<font face="Times New Roman"><b> </b></font></font></span><span style="font-size: 9pt; background-color: #FFFFD7"><font face="Times New Roman"><b><font color="#FF0000">Note:</font></b></font></span><font face="Times New Roman" style="font-size: 11pt" color="#004080"><span style="background-color: #FFFFD7">
"xxxxx and "UPDATE Status" are editable
fields.</span></font></td>
</tr>
</table>
</div>
<p align="center">
<font face="Arial"> </font>
<font face="Arial"> </font>
</p>
<p align="center">
<input type="hidden" name="ID_no" value="<% = rsMasterRolodex("ID_no") %>">
</p>
</form>
<%
adoCon.close
Set adoCon = Nothing
%>
<!-- End form code -->
</body>
</html>
|