Hi

Does anyone know how to execute a stored preocedure using VBScript in ASP. The Stored Procedure returns two values indicating whether the insert has been successfull or not. I am currently up to the following and I am now officially stuck.

Code:
Dim cnSQL
Dim ResultInt
Dim Resulttxt

'All the usual database connection stuff here

'Call the stored procedure

cnSQL = "EXEC CPSDetailsAdd_Up '12345','Hello','G Day '," _
      & ResultInt & "OUTPUT," & Resulttxt & "OUTPUT"

Conn.Execute(cnSQL)
Any help would be appreciated