I am desperate for help here. My deadline is this Friday, and I have no clue 
how to make this work...

I have been provided with an Oracle stored procedure by our dba that 
provides a session id when a user logs in to my application with their 
domain name and password.  I have successfully gotten this to work (i.e., I 
get a session id passed back to me).

Now, I have also been provided with an Oracle function for the stored proc.  
I have NO idea what I'm supposed to do with this:

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

FUNC: DB_APP_STD.chk_ses(sesid, valid_hrs)
Input: sesid (varchar2)
       valid_hrs (number) <optional, default is 3 hrs>
Returns: Varchar2 'UserID' OR NULL

---------

Apparently the plan is to call the above function via an include page in any 
of the pages that I want password-protected.  Apparently it is for checking 
that the user is, in fact, logged in.

What I don't understand is, how do I call this function?  Do I put it in my 
login_action page with the original stored procedure?
What files do I need?  I know I need the application.cfm file--do I put this 
function in there?  What goes in the application.cfm file (other than my 
cfapplication tag) vs. what goes in my login_action.cfm file vs. what goes 
in my include page?  Do I even need that third include page?

PLEASE, if anyone has more of a clue than I do, let me know!


Thanks!
Terri
________________________________________________________________________
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