Adjustment of stored procedures in ASP
<% DIM objcnndim objcmddim rsconst o_ID = 112
'----- Create a Connection object --------- set objcn = server.createObject ("adoDb.connection") objcn.open "driver = {SQL Server}; server = localhost; uid = sa ; pwd = cncanet; database = check; "'----- Create a Command object ----------- set objcmd = server.createObject (" adodb.command ") Objcmd.activeConnection = Objcnnobjcmd.comMandtext = "order_tot_amt" 'specifies the name of the stored procedure objCmd.CommandType = adCmdStoredProc' as stored procedure '----- preparation stored procedure parameter ------- objCmd.Parameters.Append _ objCmd.CreateParameter ( "o_id" , Adinteger, Adparaminput,, O_ID) Objcmd.Parameters.Append_ Objcmd.createParameter ("p_tot", adbigint, adpaamoutput, 0) '----- Execute stored procedures ------------ ---------- Objcmd.execute
'----- Output parameters and processing results -------------- for Each Parm in objcmd.parameters response.write prmmo.name & "=" & trim (parm) & "< Br> "Next%>
The above code is passed in Win2000 IIS5.0 SQL Server2000
