Webmaster Forum / ColdFusion / Getting Started / September 2004

How do I initialize  <cfparam name="SESSION.catagory_level" or make it not use
the default and use "5" in some cases?

Here is what I have:

<cfparam name="SESSION.catagory_level" default="1">
<cfquery name="catagory" datasource="#APPLICATION.datasource_name#"
dbtype="Query">
SELECT *
FROM catagory
WHERE catagory_level = #SESSION.catagory_level#</cfquery>

Here is what else I have on the same browse page:

<form action="catagory_action.cfm" method="post" name="get_catagory"
id="get_catagory">

You are in category
<select name="catagory" onchange="get_catagory_onchange_submit()">
<cfoutput query="catagory">    <option value="#catagory#"<cfif SESSION.catagory
IS "#catagory#" AND SESSION.catagory_level =
"#catagory_level#">SELECTED</cfif>>#catagory#</option></cfoutput>
</select>
</form>

<cfparam name="URL.o" default="actual_filename">
<cfquery name="get_files" datasource="#APPLICATION.datasource_name#"
dbtype="Query">
SELECT library.ID, library.TitleSubject, library.PresenterAuthor,
library.AudienceType, library.GivenTo, library.Synopsis, library.Objective,
library.actual_filename, library.server_filename, library.file_extension,
library.file_size, library.catagory, library.comments, library.upload_date,
user.first_name, user.last_name
FROM library LEFT JOIN [user] ON library.username = user.username
WHERE library.catagory = '#SESSION.catagory#'
ORDER BY #URL.o#</cfquery>

I want it to differentiate by users catagory_level. Default "1" sometimes "5".
How do I carry the specific <cfparam session.catagory_level> to the browse
page or tell it to initialize from the catagory_level the user has?

Kind regards,
CS