<%@ 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 %> Organizing Links and Articles
Calahan Solutions Header image Calahan Solutions Header image Calahan Solutions Header image
Calahan Solutions Header image
Services Link FAQs and Advice Link Resources Link Shop Link Client Experiences Link Newsroom Link About Us Link Contact Us Link

 

Resources Navigation

 

RESOURCES

Home

Site Map

 

mini subscribe
FREE PUBLICATIONS!

Subscribe to "Organizing Solutions!" today!

Just for signing up, you will receive 2 FREE Reports!

Links

Select a category from the list below.

" method="POST" id="frmCategory" name="frmCategory">

There are numerous web sites and articles available on organizing. We have selected a few links that we believe will be quite helpful based on topic.

Have a suggestion for something you'd like to see? Tell us your idea by clicking here.

<% 'Grab active categories Dim counter : counter = 0 objCmdCategory.CommandText = "sp_GetLinksByCategoryID" 'objCmdCategory.Parameters.Append = objCmdCategory.CreateParameter("@CategoryID",adInteger,adParamInput) 'objCmdCategory.Parameters("@CategoryID") = int(CategoryID) Set objRSCategory = objCmdCategory.Execute 'Temp vars so we know when the sub/headings change Dim cat :cat = "" Dim subcat :subcat = "" Dim subsubcat :subsubcat = "" Dim count :count = 0 %><% If CategoryID = "all" Then Set objRSCategory = objCmdCategory.Execute ElseIf IsNumeric(CategoryID) Then objCmdCategory.Parameters.Append = objCmdCategory.CreateParameter("@CategoryID",adInteger,adParamInput,,int(CategoryID)) Set objRSCategory = objCmdCategory.Execute Else objCmdCategory.Parameters.Append = objCmdCategory.CreateParameter("@CategoryID",adInteger,adParamInput,,-5) Set objRSCategory = objCmdCategory.Execute End If Do While NOT objRSCategory.EOF 'Watch for Categories to Change If(cat <> objRSCategory("Category")) Then count = count + 1 cat = objRSCategory("Category") If ( count>1 ) Then %>


<%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,"
")%> <%End If%> <%If (objRSCategory("link_to_review") <> "") Then%> " >Link to review <%End If%>

<% objRSCategory.MoveNext Loop %>
zz_main_footer_interior

 

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
Email • T: 309.826.5263 • F: 309.422.7665


(c)2004 - 2007 Calahan Solutions, Inc. - All Rights Reserved

 

<% 'Clean up the database connection 'close connection objConnCategory.close set objConnCategory = Nothing set objCmdCategory = Nothing set objRSCategory = Nothing %>