Boolean result from SQL Update for asp page

[jimny]

I know that a sql functin should return a value of -1,0 or 1, but I have no been able to use it to validate whether a process has completed syuccessfully.

Example:

sql = "UPDATE tblNum t WHERE t.num = '"&num&"'"
verify = conn.execute(sql)

-- OR preferably--

is there a way to do it without using conn.execute:

Example:

rs.open = sql,conn,1,3

Thanks ahead of time

Seems like it should be easy, but then again, I don't have a regents diploma.

 

[Veep]

I believe you're talking about a return value. In order to make that happen you are going to have to first create a stored procedure in your database and tell it what to return under certain conditions. Then in your .asp page you will need to use the ADO command object to retrieve that output parameter. If I misunderstood, sorry.

 

[jimny]

If what i am talking about is a return value, then how do I retrieve said value?

CREATE Procedure InsertNum
@Num int(4)
As
Update tblNum set num = '@Num'
return @@Error
GO

????

 

[jimny]

OOPs sorry

coding two different thoughts in one post.

CREATE Procedure InsertNum
@Num int(4)
@RetVal
As
Update tblNum set num = '@Num'
return @@Error as RetVal
GO

-- OR --

CREATE Procedure InsertNum
@Num int(4)
As
Update tblNum set num = '@Num'
return @@Error
GO

 

[Veep]

The easy version:

Stored Proc
CREATE Procedure InsertNum
@Num int(4)
As
SET NOCOUNT ON
Update tblNum set num = '@Num'
SET NOCOUNT OFF
SELECT myERROR = @@Error

Then in your .asp page:
<%
set conn=server.createobject(&quot;ADODB.CONNECTION&quot
conn.open yourConnectionString
strSql=&quot;EXEC InsertNum @Num=&quot; & YourNumberVariable
set rs=Conn.execute(strSql)
myErrorCode=rs(0)
set rs=nothing
conn.close
set conn=nothing
If myErrorCode <> 0 then
response.write &quot;There was an error!&quot;
Else
response.write &quot;We had an error-free update!&quot;
End if
%>

 

[jimny]

thanks Veep,

haven't been able to get it running, but am in the right neighborhood