maybe you could also use a call statement..
<cfquery Name="Test" Datasource="your_data">
Call FunctionName(Param1, param2);
</cfquery>
--- Original Message ---
"Matt Rodosky" <[EMAIL PROTECTED]> Wrote on
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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.
-----
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.