<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim MM_pompier_STRING MM_pompier_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database/pompier.mdb") %> <% Dim rs_pups Dim rs_pups_numRows Set rs_pups = Server.CreateObject("ADODB.Recordset") rs_pups.ActiveConnection = MM_conn_pompier04_STRING rs_pups.Source = "SELECT * FROM Sage03 ORDER BY Sequence ASC" rs_pups.CursorType = 0 rs_pups.CursorLocation = 2 rs_pups.LockType = 1 rs_pups.Open() rs_pups_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = 7 Repeat1__index = 0 rs_pups_numRows = rs_pups_numRows + Repeat1__numRows %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim rs_pups_total Dim rs_pups_first Dim rs_pups_last ' set the record count rs_pups_total = rs_pups.RecordCount ' set the number of rows displayed on this page If (rs_pups_numRows < 0) Then rs_pups_numRows = rs_pups_total Elseif (rs_pups_numRows = 0) Then rs_pups_numRows = 1 End If ' set the first and last displayed record rs_pups_first = 1 rs_pups_last = rs_pups_first + rs_pups_numRows - 1 ' if we have the correct record count, check the other stats If (rs_pups_total <> -1) Then If (rs_pups_first > rs_pups_total) Then rs_pups_first = rs_pups_total End If If (rs_pups_last > rs_pups_total) Then rs_pups_last = rs_pups_total End If If (rs_pups_numRows > rs_pups_total) Then rs_pups_numRows = rs_pups_total End If End If %> <% Dim MM_paramName %> <% ' *** Move To Record and Go To Record: declare variables Dim MM_rs Dim MM_rsCount Dim MM_size Dim MM_uniqueCol Dim MM_offset Dim MM_atTotal Dim MM_paramIsDefined Dim MM_param Dim MM_index Set MM_rs = rs_pups MM_rsCount = rs_pups_total MM_size = rs_pups_numRows MM_uniqueCol = "" MM_paramName = "" MM_offset = 0 MM_atTotal = false MM_paramIsDefined = false If (MM_paramName <> "") Then MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "") End If %> <% ' *** Move To Record: handle 'index' or 'offset' parameter if (Not MM_paramIsDefined And MM_rsCount <> 0) then ' use index parameter if defined, otherwise use offset parameter MM_param = Request.QueryString("index") If (MM_param = "") Then MM_param = Request.QueryString("offset") End If If (MM_param <> "") Then MM_offset = Int(MM_param) End If ' if we have a record count, check if we are past the end of the recordset If (MM_rsCount <> -1) Then If (MM_offset >= MM_rsCount Or MM_offset = -1) Then ' past end or move last If ((MM_rsCount Mod MM_size) > 0) Then ' last page not a full repeat region MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' move the cursor to the selected record MM_index = 0 While ((Not MM_rs.EOF) And (MM_index < MM_offset Or MM_offset = -1)) MM_rs.MoveNext MM_index = MM_index + 1 Wend If (MM_rs.EOF) Then MM_offset = MM_index ' set MM_offset to the last possible record End If End If %> <% ' *** Move To Record: update recordset stats ' set the first and last displayed record rs_pups_first = MM_offset + 1 rs_pups_last = MM_offset + MM_size If (MM_rsCount <> -1) Then If (rs_pups_first > MM_rsCount) Then rs_pups_first = MM_rsCount End If If (rs_pups_last > MM_rsCount) Then rs_pups_last = MM_rsCount End If End If ' set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount) %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters Dim MM_keepNone Dim MM_keepURL Dim MM_keepForm Dim MM_keepBoth Dim MM_removeList Dim MM_item Dim MM_nextItem ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" End If MM_keepURL="" MM_keepForm="" MM_keepBoth="" MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each MM_item In Request.QueryString MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item)) End If Next ' add the Form variables to the MM_keepForm string For Each MM_item In Request.Form MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm If (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) End If If (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) End If If (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) End If ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> <% ' *** Move To Record: set the strings for the first, last, next, and previous links Dim MM_keepMove Dim MM_moveParam Dim MM_moveFirst Dim MM_moveLast Dim MM_moveNext Dim MM_movePrev Dim MM_urlStr Dim MM_paramList Dim MM_paramIndex Dim MM_nextParam MM_keepMove = MM_keepBoth MM_moveParam = "index" ' if the page has a repeated region, remove 'offset' from the maintained parameters If (MM_size > 1) Then MM_moveParam = "offset" If (MM_keepMove <> "") Then MM_paramList = Split(MM_keepMove, "&") MM_keepMove = "" For MM_paramIndex = 0 To UBound(MM_paramList) MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),"=") - 1) If (StrComp(MM_nextParam,MM_moveParam,1) <> 0) Then MM_keepMove = MM_keepMove & "&" & MM_paramList(MM_paramIndex) End If Next If (MM_keepMove <> "") Then MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1) End If End If End If ' set the strings for the move to links If (MM_keepMove <> "") Then MM_keepMove = Server.HTMLEncode(MM_keepMove) & "&" End If MM_urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "=" MM_moveFirst = MM_urlStr & "0" MM_moveLast = MM_urlStr & "-1" MM_moveNext = MM_urlStr & CStr(MM_offset + MM_size) If (MM_offset - MM_size < 0) Then MM_movePrev = MM_urlStr & "0" Else MM_movePrev = MM_urlStr & CStr(MM_offset - MM_size) End If %> Great Pyrenees Dogs, follow a litter of puppies for their first 8 weeks
Poste de Pompier Great Pyrenees, Potter Valley, Mendocino County, CA Poste de Pompier Great Pyrenees, Potter Valley, Mendocino County, CA See Great Pyrenees working dogs in action Working Great Pyenees can be show dogs too Poste de Pompier Great Pyrenees, Potter Valley, Mendocino County, CA see pictures of our show and working dogs Poste de Pompier Great Pyrenees, Potter Valley, Mendocino County, CA Poste de Pompier Great Pyrenees, Potter Valley, Mendocino County, CA California Great Pyrenees breeder Great Pyrenees Pedigree See our current litter of Great Pyrenees puppies
<% While ((Repeat1__numRows <> 0) AND (NOT rs_pups.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rs_pups.MoveNext() Wend %>

Sage x Bubba

<% If MM_offset <> 0 Then %> First <% End If ' end MM_offset <> 0 %> <% If MM_offset <> 0 Then %> Previous <% End If ' end MM_offset <> 0 %> <% If Not MM_atTotal Then %> Next <% End If ' end Not MM_atTotal %> <% If Not MM_atTotal Then %> Last <% End If ' end Not MM_atTotal %>
<%=(rs_pups.Fields.Item("Caption").Value)%>

" width="200" />
<% If MM_offset <> 0 Then %> First <% End If ' end MM_offset <> 0 %> <% If MM_offset <> 0 Then %> Previous <% End If ' end MM_offset <> 0 %> <% If Not MM_atTotal Then %> Next <% End If ' end Not MM_atTotal %> <% If Not MM_atTotal Then %> Last <% End If ' end Not MM_atTotal %>
Email us | Puppies | Available Puppies | Show Dogs | Proven Working Dogs

Website Design, Hosting & Maintenance by: Bright Hope Designs, Serving Northern California
<% rs_pups.Close() Set rs_pups = Nothing %>