<% Set db = Server.CreateObject("ADODB.Connection") db.Open("bc4m") db.CursorLocation = 3 set rs = Server.CreateObject("ADODB.Recordset") SQL = "Select category From ResourceCategory" 'rs.Open SQL,db,1 ' set rs = db.Execute(SQL) SQL_TotalNumberOfRow = "Select count(0) From ResourceCategory" set rs_SQL_TotalNumberOfRow = db.Execute(SQL_TotalNumberOfRow) initial_value = rs_SQL_TotalNumberOfRow(0) initial_value_Prev = CLng((rs_SQL_TotalNumberOfRow(0)/2)) initial_value_Nex = initial_value - initial_value_Prev %> Resources - Business Cards 4 Me
  Business Cards 4 Me / Resources

Resources

Add a new link

<% initial_value = initial_value / 2 i = 1 Do Until i > initial_value_Prev %> <% Set db = Server.CreateObject("ADODB.Connection") db.Open("bc4m") db.CursorLocation = 3 conf_titlem = rs(0) SQL2 = "Select count(option_category) From e_resource where publish = 'yes' and option_category ='"&conf_titlem&"'" set cate = Server.CreateObject("ADODB.Recordset") set cate = db.Execute(SQL2) If cate.BOF Or cate.EOF Then end if %> <% get_url = lcase(rs(0)) get_url = replace(get_url," ","-") %> <% len_title = len(rs(0)) split_len_title = len_title -1 display_title = left(rs(0),1) display_split_title = Right(rs(0),split_len_title) %> Recreation    <%=display_title%> <%=display_split_title%>  ( <%=cate(0)%> )

<% rs.MoveNext i=i+1 Loop %>

<% i = 1 Do Until i> initial_value_Nex %> <% Set db = Server.CreateObject("ADODB.Connection") db.Open("bc4m") db.CursorLocation = 3 conf_titlem = rs(0) SQL2 = "Select count(option_category) From e_resource where publish = 'yes' and option_category ='"&conf_titlem&"'" set cate = Server.CreateObject("ADODB.Recordset") set cate = db.Execute(SQL2) If cate.BOF Or cate.EOF Then end if %> <% get_url = lcase(rs(0)) get_url = replace(get_url," ","-") %> <% len_title = len(rs(0)) split_len_title = len_title -1 display_title = left(rs(0),1) display_split_title = Right(rs(0),split_len_title) %> Recreation    <%=display_title%> <%=display_split_title%>  ( <%=cate(0)%> )

<% rs.MoveNext i=i+1 Loop %>
 
BusinessCards4me Custom Design Services