Web Wiz Support and Community Forums : Display a single category? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 13:24:09 +0000 Fri, 04 Jun 2004 18:03:45 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10716 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Display a single category? : the way i would do it have an...]]> https://forums.webwiz.net/display-a-single-category_topic10716_post58838.html#58838 Author: dj air
Subject: 10716
Posted: 04 June 2004 at 6:03pm

the way i would do it have an identifier (c=3) and if that exists only call the category

the below should help you impliment what you want

-----------------------

just above the <html> tag of the default.asp page you will see the following code

'Read the various categories from the database
'Initalise the strSQL variable with an SQL statement to query the database


If strDatabaseType = "SQLServer" Then
 strSQL = "EXECUTE " & strDbProc & "CategoryAll"
Else
 strSQL = "SELECT " & strDbTable & "Category.Cat_name, " & strDbTable & "Category.Cat_ID FROM " & strDbTable & "Category ORDER BY " & strDbTable & "Category.Cat_order ASC;"
End If

(this method will only work on Access version)

chage the section of code for the below section

'Read the various categories from the database
'Initalise the strSQL variable with an SQL statement to query the database
If strDatabaseType = "SQLServer" Then
 strSQL = "EXECUTE " & strDbProc & "CategoryAll"
Else


 strSQL = "SELECT " & strDbTable & "Category.Cat_name, " & strDbTable & "Category.Cat_ID FROM " & strDbTable & "Category"

intQueryCatID = CLng(request.querystring("c"))

if intQueryCatID > 0 then strSQL = strSQL & " WHERE " & strDbTable &"Category.Cat_ID =" & intQueryCatID &""

strSQL = strSQL & " ORDER BY " & strDbTable & "Category.Cat_order ASC;"
End If

the above code will check to see if there is a selection and if so it will only get the selected category and none of the others.

I hope /think that is what you want. the above code should be copy and paste.

]]> Fri, 04 Jun 2004 18:03:45 +0000 https://forums.webwiz.net/display-a-single-category_topic10716_post58838.html#58838 <![CDATA[Display a single category? : http://www.cpca.org/healthcoll...]]> https://forums.webwiz.net/display-a-single-category_topic10716_post58747.html#58747 Author: CapnCrunch
Subject: 10716
Posted: 03 June 2004 at 12:57pm

http://www.cpca.org/healthcollabs/forum/default.asp?C=3

 

As you can see from this link, what I am trying to do is get ONLY the toolbox category to display. Is there an easy way to do this?

 

]]> Thu, 03 Jun 2004 12:57:59 +0000 https://forums.webwiz.net/display-a-single-category_topic10716_post58747.html#58747