Hi All,

I have a login screen that passes the userid to a query:

<cfquery name="record_list" datasource="CF_3IS" dbtype="ODBC">
SELECT  suggestion_id,
        suggestion_name,
        status_code,
        actual_evaluator_userid
FROM SUG_SUGGESTIONS
WHERE status_code IN ('I', 'E', 'F', 'S')  AND
actual_evaluator_userid='#url.userid#'
      </cfquery>

Basically, whenever the user comes back to this page (eval.cfm), I want only 
those records that pertain to that userid to be displayed.  Seems simple 
enough.

The problem is that I have an included template for my left-hand navigation. 
This left-hand navigation has no idea what userid was passed from the form, 
so every time someone clicks on the link to go back to eval.cfm from the 
navigation bar, an error is thrown that the parameter "url.userid" cannot be 
resolved.  I really don't want to go back through and take out all of my 
included pages.  Is there any other way I can get around this?

Thanks!

T
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to