ASP Calling Stored Procedure

[Liam Bennett]

I've written this asp to execute a stored procedure but this seem like an odd way to do it. The stored procedure will only add a new member if the username and email address are unique, and value is created 0,1,2,3

0 - Added Unique Member
1 - Email Already Registered
2 - Username taken
3 - Points 1 & 2

<!--#include virtual="/Connections/data_Conn.asp"-->
<%
uname =request("register_uname")
fname =request("register_fname")
sname = request("register_sname")
email = request("register_email")
password = request("register_password")


'ObjCmd.CommandText = "call sp_members_addnew(" & fname & ", " & sname & ", " & email & ", " & password & ");"
set adoConn = Server.CreateObject("ADODB.Connection")
adoConn.Open MM_data_Conn_STRING


set rs = server.CreateObject("ADODB.Recordset")
rs.activeconnection = adoConn
rs.open = "call sp_members_addnew('" & uname & "', '" & email & "', '" & password & "', '" & fname & "', '" & sname &"');"
adoConn.Execute "call sp_members_addnew('" & uname & "', '" & email & "', '" & password & "', '" & fname & "', '" & sname &"');"
response.write rs(0)

%>

Is their a better way of doing this? Because it is actually querying the database twice.



Edited 1 time(s). Last edit at 09/08/2006 05:30PM by Liam Bennett.