<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim naturers Dim naturers_numRows Set naturers = Server.CreateObject("ADODB.Recordset") naturers.ActiveConnection = MM_ndb_STRING naturers.Source = "SELECT * FROM naturemain ORDER BY mnid ASC" naturers.CursorType = 0 naturers.CursorLocation = 2 naturers.LockType = 1 naturers.Open() naturers_numRows = 0 %> <% Dim natureinfo__MMColParam natureinfo__MMColParam = "1" If (Request.QueryString("natureid") <> "") Then natureinfo__MMColParam = Request.QueryString("natureid") End If %> <% Dim natureinfo Dim natureinfo_numRows Set natureinfo = Server.CreateObject("ADODB.Recordset") natureinfo.ActiveConnection = MM_ndb_STRING natureinfo.Source = "SELECT * FROM naturemain WHERE natureid = '" + Replace(natureinfo__MMColParam, "'", "''") + "' ORDER BY mnid ASC" natureinfo.CursorType = 0 natureinfo.CursorLocation = 2 natureinfo.LockType = 1 natureinfo.Open() natureinfo_numRows = 0 %> <% Dim npackage Dim npackage_numRows Set npackage = Server.CreateObject("ADODB.Recordset") npackage.ActiveConnection = MM_ndb_STRING npackage.Source = "SELECT * FROM naturepackage ORDER BY mnid ASC" npackage.CursorType = 0 npackage.CursorLocation = 2 npackage.LockType = 1 npackage.Open() npackage_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = 18 Repeat1__index = 0 naturers_numRows = naturers_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = 28 Repeat2__index = 0 npackage_numRows = npackage_numRows + Repeat2__numRows %> <% Dim MM_paramName %> <% ' *** 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 %> ::NepalNature.Com::
.jpg" width="100%" height="106">
 
<% While ((Repeat1__numRows <> 0) AND (NOT naturers.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 naturers.MoveNext() Wend %>
*

<%=(natureinfo.Fields.Item("title").Value)%>
<%=(natureinfo.Fields.Item("ntxt1").Value)%>
<% While ((Repeat2__numRows <> 0) AND (NOT npackage.EOF)) %> <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 npackage.MoveNext() Wend %>
Nature Package
<% naturers.Close() Set naturers = Nothing %> <% natureinfo.Close() Set natureinfo = Nothing %> <% npackage.Close() Set npackage = Nothing %>