<% searchword = Request("storename") Dim objConn Dim objRec Dim strConn StoreSQL = "SELECT ord_num,title,qty,discount From salesdetail,titles where stor_id=(SELECT stor_id FROM stores WHERE stor_name ='"& searchword & "') AND titles.title_id=salesdetail.title_id;" Set objConn = Server.CreateObject("ADODB.Connection") Set objRec = Server.CreateObject("ADODB.Recordset") objConn.Open strConnect %>
Search :     
Simple Query
Ordering Column Data
Author Loops
Stores Loops
Simple Dbase Query
Complex Dbase Query
Sales in Stores
Current Server Time
Master Detail
HotList Project
Publishers&Titles Hot List
PlayList Using File
PlayList Using DBase


Main Link Page

LAB 14: SERVER TIME/DATE

CURRENT SERVER TIME-----<% =Time %>
CURRENT SERVER DATE-----<% =Date %>
C++ Tutorial ASP Tutorial Java Tutorial XML Tutorial
Visual Basic And More Javascript doc Flash Tutorial
DeVry University Bronx Community College My Library
Send comments to Support@rrasaq.com