<%@ LANGUAGE=JScript %> <% rExp=/ /g; rPlc="%20" Session("theURL")="../giftshop/main.asp" dbConnStr="DBQ="+Server.MapPath("/partystrips/fpdb/inventory.mdb")+";driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;"; conn=Server.CreateObject("ADODB.Connection"); res=Server.CreateObject("ADODB.Recordset"); conn2=Server.CreateObject("ADODB.Connection"); res2=Server.CreateObject("ADODB.Recordset"); conn3=Server.CreateObject("ADODB.Connection"); res3=Server.CreateObject("ADODB.Recordset"); conndyn=Server.CreateObject("ADODB.Connection"); conndyn.Open(dbConnStr); conn.Open(dbConnStr); res.Open("SELECT * FROM Products WHERE Special = 1",conn, adOpenStatic, adLockReadOnly); res.PageSize=1; dynamic_include_productID=res("ProductID") conn2.Open(dbConnStr); res2.Open("SELECT * FROM Content",conn2, adOpenStatic, adLockReadOnly); res2.PageSize=1; conn3.Open(dbConnStr); res3.Open("SELECT * FROM Popular",conn3, adOpenStatic, adLockReadOnly); res3.PageSize=1; var camefromdetail=0 %> Official Gift Shop of Tony Ranaudo; Actor, Comedian, Entertainer

 
Tony Ranaudo's
Gift Shop

 

">

Search By Keyword
  

 
*** Featured Item ***

<% rs=Server.CreateObject("ADODB.RecordSet"); rs.Open("SELECT ProductName, ProductID FROM Products ORDER BY ProductName",conn, adOpenStatic, adLockReadOnly); %>

"><%=res("ProductName")%>

<% rs=Server.CreateObject("ADODB.RecordSet"); rs.Open("SELECT DISTINCT CategoryName FROM Categorys ORDER BY CategoryName",conn, adOpenStatic, adLockReadOnly); theString=new String(rs("CategoryName")); %>

<%=res("Description")%>
Click the Image for More Details!

<% rs=Server.CreateObject("ADODB.RecordSet"); rs.Open("SELECT DISTINCT SubCategory FROM SubCategorys ORDER BY SubCategory",conn, adOpenStatic, adLockReadOnly); theString=new String(rs("SubCategory")); %>

<% if(res("OnSale")==true) { %> > <% } if(res("OnSale")==false) { %> > <% } %> "> , <%=res("ProductName")%>-- <%=res("Description")%>"> "> "> "> "> "> "> "> "> "> "> "> "> ">
<% if(res("OnSale")==true) { %>

>>>  $<%=res("SalePrice")%> 


Reg. $<%=res("Price")%> <% } if(res("OnSale")==false) { %>

$<%=res("Price")%> 

<% } %>

Quantity:

">" border="2" bgcolor="#000080" bordercolor="#000080" bordercolorlight="#D2D2D2" bordercolordark="#000000" style="background-color: #F3CF32; border: 8 ridge #FF0000; padding: 4">

<%=res2("GiftShopWelcome")%>

*Popular Item*

Store Policies

..and Guidelines

 
 Hit Counter

 Last Modified   Thursday, October 26, 2006
Copyright © 1999- 2005 Tony Ranaudo

<% conn.Close(); conn=""; conn2.Close(); conn2=""; conn3.Close(); conn3=""; %>