<%@ LANGUAGE=VBScript %> <% Option Explicit %> <% '-------------------------------------------------------------------- ' Microsoft ADO ' ' (c) 1996 Microsoft Corporation. All Rights Reserved. ' ' ' ' ADO constants include file for VBScript ' '-------------------------------------------------------------------- '---- CursorTypeEnum Values ---- Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 '---- CursorOptionEnum Values ---- Const adHoldRecords = &H00000100 Const adMovePrevious = &H00000200 Const adAddNew = &H01000400 Const adDelete = &H01000800 Const adUpdate = &H01008000 Const adBookmark = &H00002000 Const adApproxPosition = &H00004000 Const adUpdateBatch = &H00010000 Const adResync = &H00020000 Const adNotify = &H00040000 '---- LockTypeEnum Values ---- Const adLockReadOnly = 1 Const adLockPessimistic = 2 Const adLockOptimistic = 3 Const adLockBatchOptimistic = 4 '---- ExecuteOptionEnum Values ---- Const adRunAsync = &H00000010 '---- ObjectStateEnum Values ---- Const adStateClosed = &H00000000 Const adStateOpen = &H00000001 Const adStateConnecting = &H00000002 Const adStateExecuting = &H00000004 '---- CursorLocationEnum Values ---- Const adUseServer = 2 Const adUseClient = 3 '---- DataTypeEnum Values ---- Const adEmpty = 0 Const adTinyInt = 16 Const adSmallInt = 2 Const adInteger = 3 Const adBigInt = 20 Const adUnsignedTinyInt = 17 Const adUnsignedSmallInt = 18 Const adUnsignedInt = 19 Const adUnsignedBigInt = 21 Const adSingle = 4 Const adDouble = 5 Const adCurrency = 6 Const adDecimal = 14 Const adNumeric = 131 Const adBoolean = 11 Const adError = 10 Const adUserDefined = 132 Const adVariant = 12 Const adIDispatch = 9 Const adIUnknown = 13 Const adGUID = 72 Const adDate = 7 Const adDBDate = 133 Const adDBTime = 134 Const adDBTimeStamp = 135 Const adBSTR = 8 Const adChar = 129 Const adVarChar = 200 Const adLongVarChar = 201 Const adWChar = 130 Const adVarWChar = 202 Const adLongVarWChar = 203 Const adBinary = 128 Const adVarBinary = 204 Const adLongVarBinary = 205 '---- FieldAttributeEnum Values ---- Const adFldMayDefer = &H00000002 Const adFldUpdatable = &H00000004 Const adFldUnknownUpdatable = &H00000008 Const adFldFixed = &H00000010 Const adFldIsNullable = &H00000020 Const adFldMayBeNull = &H00000040 Const adFldLong = &H00000080 Const adFldRowID = &H00000100 Const adFldRowVersion = &H00000200 Const adFldCacheDeferred = &H00001000 '---- EditModeEnum Values ---- Const adEditNone = &H0000 Const adEditInProgress = &H0001 Const adEditAdd = &H0002 Const adEditDelete = &H0004 '---- RecordStatusEnum Values ---- Const adRecOK = &H0000000 Const adRecNew = &H0000001 Const adRecModified = &H0000002 Const adRecDeleted = &H0000004 Const adRecUnmodified = &H0000008 Const adRecInvalid = &H0000010 Const adRecMultipleChanges = &H0000040 Const adRecPendingChanges = &H0000080 Const adRecCanceled = &H0000100 Const adRecCantRelease = &H0000400 Const adRecConcurrencyViolation = &H0000800 Const adRecIntegrityViolation = &H0001000 Const adRecMaxChangesExceeded = &H0002000 Const adRecObjectOpen = &H0004000 Const adRecOutOfMemory = &H0008000 Const adRecPermissionDenied = &H0010000 Const adRecSchemaViolation = &H0020000 Const adRecDBDeleted = &H0040000 '---- GetRowsOptionEnum Values ---- Const adGetRowsRest = -1 '---- PositionEnum Values ---- Const adPosUnknown = -1 Const adPosBOF = -2 Const adPosEOF = -3 '---- enum Values ---- Const adBookmarkCurrent = 0 Const adBookmarkFirst = 1 Const adBookmarkLast = 2 '---- MarshalOptionsEnum Values ---- Const adMarshalAll = 0 Const adMarshalModifiedOnly = 1 '---- AffectEnum Values ---- Const adAffectCurrent = 1 Const adAffectGroup = 2 Const adAffectAll = 3 '---- FilterGroupEnum Values ---- Const adFilterNone = 0 Const adFilterPendingRecords = 1 Const adFilterAffectedRecords = 2 Const adFilterFetchedRecords = 3 Const adFilterPredicate = 4 '---- SearchDirection Values ---- Const adSearchForward = 1 Const adSearchBackward = -1 '---- ConnectPromptEnum Values ---- Const adPromptAlways = 1 Const adPromptComplete = 2 Const adPromptCompleteRequired = 3 Const adPromptNever = 4 '---- ConnectModeEnum Values ---- Const adModeUnknown = 0 Const adModeRead = 1 Const adModeWrite = 2 Const adModeReadWrite = 3 Const adModeShareDenyRead = 4 Const adModeShareDenyWrite = 8 Const adModeShareExclusive = &Hc Const adModeShareDenyNone = &H10 '---- IsolationLevelEnum Values ---- Const adXactUnspecified = &Hffffffff Const adXactChaos = &H00000010 Const adXactReadUncommitted = &H00000100 Const adXactBrowse = &H00000100 Const adXactCursorStability = &H00001000 Const adXactReadCommitted = &H00001000 Const adXactRepeatableRead = &H00010000 Const adXactSerializable = &H00100000 Const adXactIsolated = &H00100000 '---- XactAttributeEnum Values ---- Const adXactCommitRetaining = &H00020000 Const adXactAbortRetaining = &H00040000 '---- PropertyAttributesEnum Values ---- Const adPropNotSupported = &H0000 Const adPropRequired = &H0001 Const adPropOptional = &H0002 Const adPropRead = &H0200 Const adPropWrite = &H0400 '---- ErrorValueEnum Values ---- Const adErrInvalidArgument = &Hbb9 Const adErrNoCurrentRecord = &Hbcd Const adErrIllegalOperation = &Hc93 Const adErrInTransaction = &Hcae Const adErrFeatureNotAvailable = &Hcb3 Const adErrItemNotFound = &Hcc1 Const adErrObjectInCollection = &Hd27 Const adErrObjectNotSet = &Hd5c Const adErrDataConversion = &Hd5d Const adErrObjectClosed = &He78 Const adErrObjectOpen = &He79 Const adErrProviderNotFound = &He7a Const adErrBoundToCommand = &He7b Const adErrInvalidParamInfo = &He7c Const adErrInvalidConnection = &He7d Const adErrStillExecuting = &He7f Const adErrStillConnecting = &He81 '---- ParameterAttributesEnum Values ---- Const adParamSigned = &H0010 Const adParamNullable = &H0040 Const adParamLong = &H0080 '---- ParameterDirectionEnum Values ---- Const adParamUnknown = &H0000 Const adParamInput = &H0001 Const adParamOutput = &H0002 Const adParamInputOutput = &H0003 Const adParamReturnValue = &H0004 '---- CommandTypeEnum Values ---- Const adCmdUnknown = &H0008 Const adCmdText = &H0001 Const adCmdTable = &H0002 Const adCmdStoredProc = &H0004 '---- SchemaEnum Values ---- Const adSchemaProviderSpecific = -1 Const adSchemaAsserts = 0 Const adSchemaCatalogs = 1 Const adSchemaCharacterSets = 2 Const adSchemaCollations = 3 Const adSchemaColumns = 4 Const adSchemaCheckConstraints = 5 Const adSchemaConstraintColumnUsage = 6 Const adSchemaConstraintTableUsage = 7 Const adSchemaKeyColumnUsage = 8 Const adSchemaReferentialContraints = 9 Const adSchemaTableConstraints = 10 Const adSchemaColumnsDomainUsage = 11 Const adSchemaIndexes = 12 Const adSchemaColumnPrivileges = 13 Const adSchemaTablePrivileges = 14 Const adSchemaUsagePrivileges = 15 Const adSchemaProcedures = 16 Const adSchemaSchemata = 17 Const adSchemaSQLLanguages = 18 Const adSchemaStatistics = 19 Const adSchemaTables = 20 Const adSchemaTranslations = 21 Const adSchemaProviderTypes = 22 Const adSchemaViews = 23 Const adSchemaViewColumnUsage = 24 Const adSchemaViewTableUsage = 25 Const adSchemaProcedureParameters = 26 Const adSchemaForeignKeys = 27 Const adSchemaPrimaryKeys = 28 Const adSchemaProcedureColumns = 29 %> <% 'Make the database Connection 'We make 2 connections so we can query the database on the topic 'Dim objConnDetails : Set objConnDetails = Server.CreateObject("ADODB.Connection") 'Dim objConnCategory : Set objConnCategory = Server.CreateObject("ADODB.Connection") 'Dim objCmdDetails : Set objCmdDetails = Server.CreateObject("ADODB.Command") 'Dim objCmdCategory : Set objCmdCategory = Server.CreateObject("ADODB.Command") 'im objRSDetails 'im objRSCategory 'Open Database Connection 'objConnCategory.Open "Driver={SQL Server}; Database=calahansolutions; Server=Mail1; Uid=calahansolutions; password=calahansolutions!23; " 'Setup Command object to get Active Categories 'objCmdCategory.CommandType = adCmdStoredProc 'objCmdCategory.ActiveConnection = objConnCategory 'Setup Command Object to get Questions/Answers 'objCmdDetails.CommandType = adCmdStoredProc 'objCmdDetails.ActiveConnection = objConnDetails 'Grab active categories 'objCmdCategory.CommandText = "sp_GetProductCategories" 'Set objRSCategory = objCmdCategory.Execute 'Process Form data 'On Error Resume Next Dim CategoryID, SubCategoryID, SubSubCategoryID, resource, QryString If (Request.Form("categoryID") <> "" ) Then CategoryID = Request.Form("categoryID") Elseif not request.QueryString("category") = "" Then CategoryID = Request.QueryString("category") else CategoryID = "" End If If (Request.Form("subcategoryID") <> "" ) Then SubCategoryID = Request.Form("subcategoryID") Elseif not request.QueryString("subcategory") = "" Then SubCategoryID = Request.QueryString("subcategory") else SubCategoryID = "" End If If (Request.Form("subsubcategoryID") <> "" ) Then SubSubCategoryID = Request.Form("subsubcategoryID") Elseif not request.QueryString("subsubcategory") = "" Then SubSubCategoryID = Request.QueryString("subsubcategory") else SubSubCategoryID = "" End If If(Request.form("resource") <> "") Then If request.Form("changed") = "TRUE" THen resource = "" Else resource = Request.form("resource") End If Elseif not request.QueryString("resource") = "" Then resource = Request.QueryString("resource") else resource = "" End If 'If(Request.form("resource") <> "") Then ' If request.Form("changed") = "TRUE" THen ' resource = "" ' Else ' resource = Request.form("resource") ' End If 'QryString = QryString & "&resource=" & resource 'Else ' resource = "" ' End If 'response.Write request.form("categoryID") 'response.Write " - categoryID
" 'response.Write request.form("subcategoryID") 'response.Write " - subcategoryID
" 'r'esponse.Write request.form("subsubcategoryID") 'r''esponse.Write " - subsubcategoryID
" 'response.Write request.form("resource") 'r'esponse.Write " - resource
" %> Products & Resources by Topic
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

 

Shop Navigation

 

SHOP

Home

CS Favorites

 

mini subscribe
FREE PUBLICATIONS!

Subscribe to "Organizing Solutions!" today!

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

Products and Resources by Topic

<%CategorySelector%>

<% ResourceList CategoryID, SubCategoryID, SubSubCategoryID %>

<% 'Temp vars so we know when the sub/headings change Dim cat :cat = "" Dim subcat :subcat = "" Dim subsubcat :subsubcat = "" Dim count :count = 0 If resource = "all" then QueryResource "article", CategoryID, SubCategoryID, SubSubCategoryID QueryResource "link", CategoryID, SubCategoryID, SubSubCategoryID QueryResource "book", CategoryID, SubCategoryID, SubSubCategoryID QueryResource "product", CategoryID, SubCategoryID, SubSubCategoryID Else QueryResource resource, CategoryID, SubCategoryID, SubSubCategoryID End If 'resource="link" 'objRS = QueryResource(resource, objConnDetails) 'DisplayLinks objRS %>

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

 

NAPO Link NSGCD Link NAWBO Link Better Business Bureau Link

<% %> <% ''''''''''''''''''''''''''''''''''''''''''' ' ResourceList(CategoryID,SubCategoryID,SubSubCateogryID) ' ' ' Gets The list and count of resources for given category/sub/subsub ''''''''''''''''''''''''''''''''''''''' Public Function ResourceList(CategoryID,SubCategoryID,SubSubCateogryID) Dim objConn, objCmd, objRS, selected Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "Driver={SQL Server}; Database=calahansolutions; Server=Mail1; Uid=calahansolutions; password=calahansolutions!23; " Set objCmd = Server.CreateObject("ADODB.Command") objCmd.CommandType = adCmdStoredProc objCmd.ActiveConnection = objConn response.Write("

") Response.Write("Select a resource below.") Response.Write(" <% objConn.close Set objConn = Nothing Set objCmd = Nothing Set objRS = Nothing End Function %> <% Public Function QueryResource(resource, CategoryID, SubCategoryID, SubSubCategoryID) ''''''''''''''''''''''''''''''''''''''''''''''''''' '' Now display the resource the user has choosen ''''''''''''''''''''''''''''''''''''''''''''''''''' If (resource <> "") Then Dim objConn, objCmd, objRS Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "Driver={SQL Server}; Database=calahansolutions; Server=Mail1; Uid=calahansolutions; password=calahansolutions!23; " Set objCmd = Server.CreateObject("ADODB.Command") objCmd.CommandType = adCmdStoredProc objCmd.ActiveConnection = objConn objCmd.CommandText = "sp_GetResourceByCategory" 'Response.Write(CategoryID & " " & SubCategoryID & " " & SubSubCategoryID) objCmd.Parameters.Append = objCmd.CreateParameter("@resource",adVarChar,adParamInput,20,resource) objCmd.Parameters.Append = objCmd.CreateParameter("@CategoryID",adInteger,adParamInput,,int(CategoryID)) If SubCategoryID <> "" Then objCmd.Parameters.Append = objCmd.CreateParameter("@SubCategoryID",adInteger,adParamInput,,int(SubCategoryID)) End If If SubSubCategoryID <> "" Then objCmd.Parameters.Append = objCmd.CreateParameter("@SubSubCategoryID",adInteger,adParamInput,,int(SubSubCategoryID)) End If Set objRS = objCmd.Execute Dim cat :cat = "" Dim subcat :subcat = "" Dim subsubcat :subsubcat = "" Dim count :count = 0 Do While NOT objRS.EOF 'Watch for Categories to Change If(cat <> objRS("Category")) Then count = count + 1 cat = objRS("Category") Select Case resource case "article" Response.Write("

Articles : " & cat & "

") case "book" Response.Write("

Books & Multimedia : " & cat & "

") case "link" Response.Write("

Links : " & cat & "

") case "product" Response.Write("

Products: " & cat & "

") End Select 'Response.Write("
") End If 'Watch For Sub Categories to change If(subcat <> objRS("SubCategory")) Then subcat = objRS("SubCategory") %>

"><%=subcat%>

<% End If 'Change in SubSubCategorie If(subsubcat <> objRS("SubSubCategory")) Then subsubcat = objRS("SubSubCategory") %> ">

<%=subsubcat%>

<%End If%> <% Select Case resource case "article" %>

"><%= objRS("name")%>
<%If objRS("description")<> "" Then%> <%= replace(objRS("description"),vbcrlf,"
")%>
<%End If%> <%If objRS("link_to_review")<> "" Then%> <%= objRS("link_to_review")%>
<%End If%>

<% case "link" %>

"><%=objRS("Name")%>

<%If (objRS("description") <> "") Then%> <%=replace(objRS("description"),vbcrlf,"
")%> <%End If%> <%If (objRS("link_to_review") <> "") Then%> " >Link to review <%End If%>

<% case "book" 'Display Image and Product Info If(objRS("picture") = "") Then%> <%Else%>
<% If (Instr(objRS("html_reference")," 0) Then%> <%=objRS("html_reference")%> <% Else %> <%=objRS("html_reference")%> <% End If %>
<%End If%>
">">

<%=objRS("title")%>

<%=objRS("title")%>
<%=replace(objRS("description"),vbcrlf,"
")%>
<%If (objRS("link_to_review") <> "" ) Then %> "> <%End If%>

<% Response.Write "
" case "product" 'Display Image and Product Info If(objRS("picture") = "") Then%> <%Else%>
<% If (Instr(objRS("html_reference")," 0) Then%> <%=objRS("html_reference")%> <% Else %> <%=objRS("html_reference")%> <% End If %>

"> <%=objRS("name")%>

<%End If%>
<%If objRS("url") <> "" Then %> ">">

<%=objRS("name")%>

 <% Else %> ">

<%=objRS("name")%>

<%End If%>

<%=objRS("name")%>
<%=replace(objRS("description"),vbcrlf,"
")%>
<%If (objRS("link_to_review") <> "" ) Then %> "> <%End If%>



<% End Select %> <%objRS.moveNext Loop objConn.close Set objConn = Nothing Set objCmd = Nothing Set objRS = Nothing End If End Function %> <% '''''''''''''''''''''''''''''' ''' Category Selector ''' This will be used to populate the category selector box, ''' We want all categories to show up here everytime. ''' Should we do sub categories here? ''' ''''''''''''''''''''''''''''' Function CategorySelector() Dim objConn,objCmd, objRSDetails Dim objConn2,objcmd2, objRS Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "Driver={SQL Server}; Database=calahansolutions; Server=Mail1; Uid=calahansolutions; password=calahansolutions!23; " Set objCmd = Server.CreateObject("ADODB.Command") objCmd.CommandType = adCmdStoredProc objCmd.ActiveConnection = objConn Set objConn2 = Server.CreateObject("ADODB.Connection") objConn2.Open "Driver={SQL Server}; Database=calahansolutions; Server=Mail1; Uid=calahansolutions; password=calahansolutions!23; " Set objCmd2 = Server.CreateObject("ADODB.Command") objCmd2.CommandType = adCmdStoredProc objCmd2.ActiveConnection = objConn2 objCmd2.CommandText = "sp_GetResourceCountByCategory" 'objCmd2.Parameters.Append = objCmd.CreateParameter("@CategoryID",adInteger,adParamInput,,NULL) 'objCmd2.Parameters.Append = objCmd.CreateParameter("@SubCategoryID",adInteger,adParamInput,,NULL) 'objCmd2.Parameters.Append = objCmd.CreateParameter("@SubSubCategoryID",adInteger,adParamInput,,NULL) 'Grab active categories Dim counter : counter = 0 'objCmd.CommandText = "sp_GetProductCategories" objCmd.CommandText = "sp_GetCategories" Set objRSDetails = objCmd.Execute 'Temp vars so we know when the sub/sub/categories change cat = "" subcat = "" subsubcat = "" 'Declare Some Vars for this function Dim selected :selected = "" ''''''''''''''''''''''''''' '' Code to populate select box '' our pseudo TOC ''''''''''''''''''''''''''' Response.write("
") response.Write("

") Response.Write("Select a category.") Response.Write(" <%End Function%>