refer to the variable as cookieId.
-----Original Message-----
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 4:56 PM
To: CF-Talk
Subject: Cold Fusion and Oracle Stored Procedures
and here is where I call it in Cold Fusion:
==========================================
<cfstoredproc datasource="DLCampus" procedure="dlc_sp_verifyLogin"
debug="yes">
<cfprocresult name="loggedIn">
<cfprocparam type="in" dbvarname="sLogin" value="#trim(FORM.sLogin)#"
cfsqltype="cf_sql_varchar">
<cfprocparam type="in" dbvarname="sPassword"
value="#trim(FORM.sPassword)#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" dbvarname="sRemoteAddr"
value="#CGI.REMOTE_HOST#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" dbvarname="sBrowser"
value="#cgi.http_user_agent#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" dbvarname="screen" value="#screenSize#"
cfsqltype="cf_sql_varchar">
<cfprocparam type="out" dbvarname="success" variable="successCode"
cfsqltype="cf_sql_integer">
<cfprocparam type="out" dbvarname="studentID" variable="cookieID"
cfsqltype="cf_sql_integer">
</cfstoredproc>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
