Try using cfprocresult name=... rather than cfprocparam
I've never used CF with Oracle, but that's how I fixed a similar issue
with SQL Server a while ago
_
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: 22 June 2004 19:13
To: CF-Talk
Subject: Why don't query variables persist?
I have the following bit of code:
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...
h1cfoutput#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]