<%@LANGUAGE="VBSCRIPT"%> <% Dim rsSubSection__MMColParam rsSubSection__MMColParam = "1" If (Request.QueryString("id") <> "") Then rsSubSection__MMColParam = Request.QueryString("id") End If %> <% Dim rsSubSection Dim rsSubSection_cmd Dim rsSubSection_numRows Set rsSubSection_cmd = Server.CreateObject ("ADODB.Command") rsSubSection_cmd.ActiveConnection = MM_conn_STRING rsSubSection_cmd.CommandText = "SELECT * FROM sections WHERE section_parent = ? order by section_order ASC" rsSubSection_cmd.Prepared = true rsSubSection_cmd.Parameters.Append rsSubSection_cmd.CreateParameter("param1", 5, 1, -1, rsSubSection__MMColParam) ' adDouble Set rsSubSection = rsSubSection_cmd.Execute rsSubSection_numRows = 0 %> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "1" If (Request.QueryString("ID") <> "") Then Recordset1__MMColParam = Request.QueryString("ID") End If %> <% Dim Recordset1 Dim Recordset1_cmd Dim Recordset1_numRows Set Recordset1_cmd = Server.CreateObject ("ADODB.Command") Recordset1_cmd.ActiveConnection = MM_conn_STRING Recordset1_cmd.CommandText = "SELECT * FROM sections WHERE ID = ?" Recordset1_cmd.Prepared = true Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 5, 1, -1, Recordset1__MMColParam) ' adDouble Set Recordset1 = Recordset1_cmd.Execute Recordset1_numRows = 0 %> <% Dim rsSection Dim rsSection_cmd Dim rsSection_numRows Set rsSection_cmd = Server.CreateObject ("ADODB.Command") rsSection_cmd.ActiveConnection = MM_conn_STRING rsSection_cmd.CommandText = "SELECT section_name FROM sections where ID = " & request.querystring("id") & "" rsSection_cmd.Prepared = true 'response.write rsSection_cmd.CommandText 'Set rsSection = rsSection_cmd.Execute rsSection_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rsSubSection_numRows = rsSubSection_numRows + Repeat1__numRows %> <%=(Recordset1.Fields.Item("section_name").Value)%> | Office paper and stationery | Highland Paper, Moray.

<% 'response.write rsSection.Fields.Item("section_name").Value %>

Stationery and paper

Products > <%=(Recordset1.Fields.Item("section_name").Value)%>
<% if rsSubSection.EOF then %> There are no sections here yet. <% else %> <% While ((Repeat1__numRows <> 0) AND (NOT rsSubSection.EOF)) %> <% if (rsSubSection.Fields.Item("body_text").Value) <> "" then response.write "

" & (rsSubSection.Fields.Item("section_name").Value) & "

" else %>
&sid=<%=request.querystring("id")%>&section=<%=request.querystring("name")%>">

<%=rsSubSection.Fields.Item("section_name").Value%>

 <% end if %> <% if (rsSubSection.Fields.Item("pic_id").Value) <> "" then response.write ""%> <% if (rsSubSection.Fields.Item("body_text").Value) <> "" then response.write (rsSubSection.Fields.Item("body_text").Value)%> <% Dim MyString, MyArray, i if rsSubSection.Fields.Item("icon_id").Value <> "" then MyString = (rsSubSection.Fields.Item("icon_id").Value) MyArray = Split(MyString,",") %>
<% for i = 0 to ubound(MyArray) if MyArray(i)="1" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="2" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="3" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="4" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="5" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="6" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="7" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="8" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="9" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="10" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="11" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="12" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="13" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="14" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="15" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="16" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="17" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="18" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="19" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="20" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="21" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="22" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="23" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="24" then response.write "" else response.write "" end if next %> <% for i = 0 to ubound(MyArray) if MyArray(i)="25" then response.write "" else response.write "" end if next %>

<% else %>
<% end if %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rsSubSection.MoveNext() Wend %> <% end if %>

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

<% Recordset1.Close() Set Recordset1 = Nothing %>