% StoreName = request.queryString("StoreName") Dim adoCon 'Holds the Database Connection Object Dim rsGuestbook 'Holds the recordset for the records in the database Dim strSQL 'Holds the SQL query for the database %> <% strSQL = "SELECT StoreInfo.* FROM StoreInfo Where " & _ "Store='" & (StoreName) & "' " Set rsGuestbook = Server.CreateObject("ADODB.Recordset") rsGuestbook.Open strSQL, adoCon Do While not rsGuestbook.EOF Page = rsGuestbook("DefLoc") Response.Cookies("DefLoc") = Page Response.Cookies("DefLoc").Expires = DATE + 365 %>
|
|