sql return param

[Zana]

Hi and thanks<BR>I cant get the value of a parameter returned from a sql select.<BR>The code is<BR>objCmd = New SqlCommand("SELECT Count(*) FROM Supplier", Conn)<BR>objParam = objCmd.Parameters.Add("RETURN VALUE", SqlDbType.Int)<BR>objParam.Direction = ParameterDirection.ReturnValue<BR>objCmd.ExecuteNonQuery()<BR>Dim intAll As Integer = objCmd.Parameters("RETURN VALUE").Value<BR>Response.Write(intAll)<BR>Response.End()<BR><BR>Which always comes up 0.<BR>The Conn and objCmd are OK and the select Count(*) returns a value with the Query Analyzer.<BR>What am I missing here?<BR>Thanks<BR>Zeg<BR>