CFMX no longer uses the dbvarname attribute (at least for Oracle, not
sure about other databases), so the order in which you provide the
parameters needs to match the order they're defined in the procedure.
In the procedure, you have success last, but in the CF you're listing
studentID last.
Scott
Richard Crawford wrote:
> Here is the stored procedure:
>
> ==========================================
> CREATE OR REPLACE procedure dlc_sp_verifyLogin (
> sLogin IN varchar2,
> sPassword IN varchar2,
> sRemoteAddr IN varchar2,
> sBrowser IN varchar2,
> screen IN varchar2,
> studentID OUT number,
> success OUT int
> )
>
> <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>
>
--
---------------------------
Scott Brady
http://www.scottbrady.net/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
