Browse Stock Photos

Home > Browse

<% var PhotographerID = Request.Form("PhotographerID") + " "; PhotographerID = PhotographerID.replace(" ","") var con = Server.CreateObject("ADODB.Connection"); con.Open(zmConn); var rs = Server.CreateObject("ADODB.Recordset"); var zmSQL = "SELECT * FROM tblPhotographer WHERE Status = 1 ORDER BY FirstName, LastName" rs.Open(zmSQL, con, adOpenKeyset, adLockOptimistic); if(!rs.EOF){%>

Choose Photographer:  

<%} rs.Close(); con.Close();%> <% var con = Server.CreateObject("ADODB.Connection"); con.Open(zmConn); var rs = Server.CreateObject("ADODB.Recordset"); if(PhotographerID != "undefined" && PhotographerID != "-1"){ var zmSQL = "SELECT Icon, EventID, Title, Description,Folder,PhotographerID FROM tblEventDetails WHERE Status = 1 AND PhotographerID = " + PhotographerID + " ORDER By Title" }else{ var zmSQL = "SELECT Icon, EventID, Title, Description,Folder,PhotographerID FROM tblEventDetails WHERE Status = 1 ORDER By Title" } rs.Open(zmSQL, con, adOpenKeyset, adLockOptimistic); var pageID = 2%>