| ........ |
3887 Jane Lane - Oceanside,
NY 11572 - Phone: 888-504-4002
Fax: 516-977-2398 - E-Mail:
|
<%
MM_local_STRING = "Driver={MySQL};SERVER=localhost;database=metaldesignsllc;uid=metal;pwd=chocko"
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
if (Request.QueryString("sday") <> "") then Recordset1__MMColParam = Request.QueryString("sday")
%>
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_local_STRING
Recordset1.Source = "SELECT * FROM sports WHERE sday = '" + Replace(Recordset1__MMColParam, "'", "''") + "' ORDER BY ID ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = -1
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<%
if NOT Recordset1.EOF then
%>
<%
Dim myCtr
myCtr = 0
%>
<%=(Recordset1.Fields.Item("sday").Value)%>
(Click On Image For A Larger Picture)
<%
dim ctr
ctr = 0
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
|
<% if ctr < 4 then
ctr = ctr + 1
myCtr = myCtr + 1
%>
&offset=<%=(myCtr - 1)%>','MyWindow','toolbar=no,location=yes,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=750,height=550,left=15,top=15'); return false;"> .gif" BORDER=0 >
<%=myCtr%>
|
<% end if
if ctr > 3 then
ctr = 0
%>
<% end if %>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
<% else %>
No examples currently available online.
<% end if %>
|
|
Design & Hosting By:
XtrTech LLC
Copyright © 2000-2003 United States Bronze Sign Co., Inc. All Rights Reserved
|
|
<%
Recordset1.Close()
%>
| |
....