Matt and Joe--
Thanks so much for your response. I really appreciate it!
Terri
----Original Message Follows----
From: "Matt Rodosky" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: RE: one more try re: oracle stored proc and session mgmt
Date: Mon, 14 Aug 2000 07:42:25 -0600
1. Call the stored procedure (pass the sessionid and valid hours to the sp):
<cfstoredproc procedure="db_app_std.chk_ses" datasource="yourDSN">
<cfprocparam type="in" dbvarname="sesid" value="#sessionid#
cfsqltype"datatype">
<cfprocparam type="in" dbvarname="valid_hrs" value="#validhrs#
cfsqltype"datatype">
<cfprocparam type="out" variable="sp_results" cfsqltype"varchar2">
</cfstoredproc>
2. Put the call: in your application.cfm
3. Loginaction: add the logged-in userid to the correct record in the
database, create variables for sessionid and validhrs
4. application.cfm: run the stored procedure, if the output is null, the
user is not supposed to be logged in anymore. If it returns a user id, make
sure its the right user and all that.
5. Oracle stored procedures don't return a regular recordset to cf, so you
might need to play with the "sp_results" to get the output to work.
hth,
Matt
-----Original Message-----
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 7:11 AM
To: [EMAIL PROTECTED]
Subject: one more try re: oracle stored proc and session mgmt
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.
------------------------------------------------------------------------------
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.
________________________________________________________________________
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.
