Free for PREMIUM members
Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium
' include adovbs file
Set cmd = Server.CreateObject("ADODB.Command")
.ActiveConnection = connMyConnection
.CommandType = adCmdStoredProc
.CommandText = "addNewThing" ' name of your stored procedure
.Parameters.Append .CreateParameter("@newThing",adVarWChar, adParamInput, 50)
.Parameters("@newThing") = widget
set rsName = .Execute
set cmd = nothing
set rs = nothing
Open in new window
Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Sql = " EXECUTE STP_CRMPOSITIVACAO " & Clie & ",-2 "
Call abre_conexao_hidrau ' open conection
Set Rs = Server.CreateObject("ADODB.RecordSet")
Rs.ActiveConnection = CnxHidrau
I tried this way: Rs.Open CnxHidrau.Execute(Sql)
I tried this way: set Rs = CnxHidrau.Execute(Sql)
If Not Rs.Eof Then
Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.