<%Step = CLng(Request.QueryString("Step"))%> <%If Step = 1 Then%>


<% SQL1 = "SELECT * FROM tbl_order_data WHERE OrderID = '" & Request.Cookies("OrderID") & "'" Set rstemp1 = conntemp.Execute(SQL1) %> <%If rstemp1.EOF Then%>
Your shopping cart is empty.
<%Else%>
  Items:Qty:Price:Option:
<%Do While NOT rstemp1.EOF%>
<% SQL2 = "SELECT TOP 1 * FROM tbl_product_images WHERE ProductID = " & rstemp1("ProductID") & " ORDER BY ImageID ASC" Set rstemp2 = conntemp.Execute(SQL2) %> <%If rstemp2.EOF THen%> <%Else%> <%Do While NOT rstemp2.EOF%> " border="0" alt=""> <% rstemp2.movenext Loop rstemp2.close Set rstemp2=Nothing %> <%End If%>

   <% SQL2 = "SELECT TOP 1 * FROM tbl_product_index WHERE ProductID = " & rstemp1("ProductID") & "" Set rstemp2 = conntemp.Execute(SQL2) %> <%If rstemp2.EOF Then%> <%Else%> <%=rstemp2("SeriesID")%> Series - <% rstemp2.close Set rstemp2=Nothing %> <%End If%> <% SQL2 = "SELECT TOP 1 * FROM tbl_product_data WHERE ProductID = " & rstemp1("ProductID") & " AND ItemID = " & rstemp1("ItemID") & "" Set rstemp2 = conntemp.Execute(SQL2) %> <%If rstemp2.EOF Then%> <%Else%> <%=rstemp2("ItemName")%> <% rstemp2.close Set rstemp2=Nothing %> <%End If%> 1 <%=FormatCurrency(rstemp1("ItemPrice"),2)%> ">Remove

<% rstemp1.movenext Loop %>
<% rstemp1.close Set rstemp1=Nothing %> <%End If%>
<%End If%> <%If Step = 2 Then%> <%If Request.Cookies("UserID") = "" Then%>
Login

If you are a returning customer, please enter your username and password in the space below to login.

Username:
Password:
Create An Account

If you are a new customer, please enter your Billing Information below to create an account. Required items are marked with an asterisk(*).

First Name: *
Last Name: *
Address: *
City: *
State/Province: *
Postal Code: *
Country: *
E-mail Address: *
Phone #: *
Username: *
Password: *
Confirm Password: *
<%Else%> <%Response.Redirect "https://www.studiosixtythree.com/CheckOut.asp?Step=3"%> <%End If%> <%End If%> <%If Step = 3 Then%> <%If Request.Cookies("UserID") = "" Then%> <%Response.Redirect "https://www.studiosixtythree.com/CheckOut.asp?Step=2"%> <%Else%>
<% SQL1 = "SELECT SUM(ItemPrice) AS TotalCharge FROM tbl_order_data WHERE OrderID = '" & Request.Cookies("OrderID") & "'" Set rstemp1 = conntemp.Execute(SQL1) %> <%If rstemp1("TotalCharge") = 0 Then%>
Order Information

<% SQL2 = "SELECT TOP 1 * FROM tbl_user_index WHERE UserID = " & Request.Cookies("UserID") & "" Set rstemp2 = conntemp.Execute(SQL2) %> <%If rstemp2.EOF Then%> <%Else%> <%Do While NOT rstemp2.EOF%>

"> "> ">
Total Charge:<%=FormatCurrency(rstemp1("TotalCharge"),2)%>
Deliver To:<%=rstemp2("FirstName")%><%=" "%><%=rstemp2("LastName")%>
License Agreement: I accept the Terms & Conditions
<% rstemp2.movenext Loop rstemp2.close Set rstemp2=Nothing %> <%End If%> <%Else%>
Card Information

<% SQL2 = "SELECT TOP 1 * FROM tbl_user_index WHERE UserID = " & Request.Cookies("UserID") & "" Set rstemp2 = conntemp.Execute(SQL2) %> <%If rstemp2.EOF Then%> <%Else%> <%Do While NOT rstemp2.EOF%>

">
Total Charge:<%=FormatCurrency(rstemp1("TotalCharge"),2)%>
First Name:">
Last Name:">
Card Type:
Card Number:
Exp Date: /
Card Code:
License Agreement: I accept the Terms & Conditions
<% rstemp2.movenext Loop rstemp2.close Set rstemp2=Nothing %> <%End If%> <%End If%> <% rstemp1.close Set rstemp1=Nothing %>

<%End If%> <%End If%>