%@ LANGUAGE=VBScript %> <% Option Explicit %> [an error occurred while processing this directive] <% 'Setup database connections Dim objConnCategory : Set objConnCategory = Server.CreateObject("ADODB.Connection") Dim objCmdCategory : Set objCmdCategory = Server.CreateObject("ADODB.Command") Dim objRSCategory 'Connect and get some data objConnCategory.Open "Driver={SQL Server}; Database=calahansolutions; Server=Mail1; Uid=calahansolutions; password=calahansolutions!23;" objCmdCategory.CommandType = adCmdStoredProc objCmdCategory.ActiveConnection = objConnCategory 'Grab active categories objCmdCategory.CommandText = "sp_GetLinkCategories" Set objRSCategory = objCmdCategory.Execute 'Process Form data ' Could be a number or 'all' Dim CategoryID If (Request.Form("category") <> "" ) Then CategoryID = Request.Form("category") Elseif not request.QueryString("category") = "" Then CategoryID = Request.QueryString("category") else CategoryID = NULL End If %>
|
||||||||||||||||||||||||||||||||||||||||||||||||||
|
RESOURCES
|
||||||||||||||||||||||||||||||||||||||||||||||||||
Links
<%End If%> "> <%=cat%><% End If 'Watch For Sub Categories to change If(subcat <> objRSCategory("SubCategory")) Then subcat = objRSCategory("SubCategory") %>"><%=subcat%><% End If 'Change in SubSubCategorie If(subsubcat <> objRSCategory("SubSubCategory")) Then subsubcat = objRSCategory("SubSubCategory") %>"><%=subsubcat%><%End If%>"><%=objRSCategory("Name")%>
<%If (objRSCategory("description") <> "") Then%>
<%=replace(objRSCategory("description"),vbcrlf," | ||||||||||||||||||||||||||||||||||||||||||||||||||
You won't have to do it our way, because we help you find YOUR way.™ Home | Submit Referral | Email This Page | Login | Request Services | Ask an Organizer Legal Information | Privacy | Anti-Spam Policy | Copyright | Site Map | Newsroom Calahan Solutions, Inc. Productive & Organized - We'll Help You Find Your Way 8 Shoreline Court, Suite 100, Bloomington IL 61704
|
||||||||||||||||||||||||||||||||||||||||||||||||||