<!--#include virtual="myconnectionstringp"-->
<%
casetype = request.querystring("casetype")
if casetype = 1 then
sqltype = "open"
elseif casetype = 2 then
sqltype = "closed"
else
sqltype = "open"
end if
%>
<body>
<table cellpadding="4" cellspacing="0" align="center">
<tr>
<% set orders1 = conn.execute("select * from orders where case_ = '"&sqltype&"'") // i know * shouldn't be used
irowcolor = 0
if not orders1.eof then
do while not orders1.eof
id3 = orders1.fields.item("id").value
'**** check shipping method ************
vmethod = trim(orders1.fields.item("method_").value)
if vmethod = "email_" then
vmethod1 = "Email"
elseif vmethod = "kit_" then
vmethod1 = "Ship Kit"
end if
'**********************************************
if irowcolor mod 2 = 0 then
rowcolor = "#8699C4"
auto1 = "auto-style4"
else
rowcolor = "#86AACE"
auto1 = "auto-style3"
end if
vform = "form"&id3
'response.write vform
%>
<form name="<%=vform%>" action="statuschangeasp.asp" method="post">
<tr style bgcolor="<%=rowcolor%>">
<td ><%=orders1.fields.item("id").value%></td>
<td >
<span id="c10_ctl">
<select onChange="document.forms['form'+id3].submit()" name="change_">
<option selected="<%=orders1.fields.item("istatus_").value%>" value="<%=orders1.fields.item("istatus_").value%>"><%=orders1.fields.item("istatus_").value%></option>
<option value="Shipped">Shipped</option>
<option value="Sent">Sent</option>
<option value="paid1">Paid PayPal</option>
<option value="paid2">Paid Check</option>
<option value="received">Received</option>
<option value="processing">Processing</option>
<option value="processed">Processed</option>
<option value="returned">Returned</option>
<option value="Pending">Pending</option>
</select>
<input name="id" type="hidden" value='<%=orders1.fields.item("id").value%>' class="auto-style4"/>
</span>
</td>
<td class="auto-style3" ><%=orders1.fields.item("tracking_").value%></td>
<td class="auto-style3" ><%=vmethod1%></td>
<td class="auto-style3" ><%=orders1.fields.item("first_").value%></td>
<td class="auto-style3" ><%=orders1.fields.item("last_").value%></td>
<td class="auto-style3" ><%=orders1.fields.item("state_").value%></td>
<td class="auto-style3" ><%=orders1.fields.item("email_").value%></td>
<td class="auto-style3" ><%=orders1.fields.item("phone_").value%></td>
<td class="auto-style3" ><%=orders1.fields.item("mod1_").value%></td>
</tr>
<%
irowcolor = irowcolor + 1
orders1.movenext
loop
else
%>
</form>
<tr>
<td class="auto-style1">There are no active orders at this time.</td>
</tr>
<% end if %>
</table>
</body>
</html>