<cfstoredproc datasource="DLCampus" procedure="dlc_sp_verifyLogin"
debug="yes">
<cfprocparam type="in" value="#trim(FORM.sLogin)#"
cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#trim(FORM.sPassword)#"
cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#CGI.REMOTE_HOST#"
cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#cgi.http_user_agent#"
cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#screenSize#" cfsqltype="cf_sql_varchar">
<cfprocparam type="out" variable="studentID" cfsqltype="cf_sql_integer">
<cfprocparam type="out" variable="success" cfsqltype="cf_sql_integer">
<cfprocparam type="out" variable="lastLoginDate" cfsqltype="cf_sql_date">
</cfstoredproc>
...and later on, I have...
<h1><cfoutput>#studentID#</cfoutput></h1>
Unfortunately, by the time the second snippet is executed, which is
supposed to print out the value of #studentID#, which is determined in
the stored procedure, the value has changed to 0. I know it's not 0
earlier on, since other stored procedures which depend on a non-zero
value for this variable do not throw exceptions.
The worst part about this is that it *used* to work. It seems to have
broken when I changed the datasource to point to a different Oracle
database. The new database is identical to the old one, as far as I can
tell, but... things just don't work, and I can't find any errors in any
logs.
Any thoughts?
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
