I'm trying to insert a customer profile with a stored procedure. This same
code has worked on other sites. But on this site, it appears to be ignored.
Nothing happens. The page loads fine with all the Request objects being
filled. The Insert code does nothing. I changed stp_InsertClient to
stp_xInsertClient just to see what happens. No errors, page loads, Request
objects are filled. All other ASP pages load fine. I setup the same code in
Query Analyzer and it works fine. Where should I be looking?
thanks
--------------------------------------------------------
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/JSK.asp" -->
<%
set InsertClient = Server.CreateObject("ADODB.Command")
InsertClient.ActiveConnection = MM_JSK_STRING
InsertClient.CommandText = "stp_InsertClient"
InsertClient.Parameters.Append InsertClient.CreateParameter("@Email", 200,
1,60,Request("Email"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@Password",
200, 1,20,Request("Password"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@FirstName",
200, 1,20,Request("FirstName"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@LastName",
200, 1,20,Request("LastName"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@Company", 200,
1,30,Request("Company"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@City", 200,
1,20,Request("City"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@Statte", 200,
1,20,Request("States"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@Country", 200,
1,20,Request("Country"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@StreetNumber",
200, 1,20,Request("StreetNumber"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@StreetName",
200, 1,30,Request("StreetName"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@Building",
200, 1,20,Request("Building"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@Region", 200,
1,20,Request("Region"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@PostalCode",
200, 1,10,Request("PostalCode"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@AreaCode",
200, 1,10,Request("AreaCode"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@RegionCode",
200, 1,10,Request("RegionCode"))
InsertClient.Parameters.Append InsertClient.CreateParameter("@PhoneNumber",
200, 1,10,Request("PhoneNumber"))
InsertClient.CommandType = 4
InsertClient.CommandTimeout = 0
InsertClient.Prepared = true
InsertClient.Execute()
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd<br>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1<br>
<title>Untitled Document</title>
</head>
<body>
<%=Request("Password")%><br>
<%=Request("Company")%><br>
<%=Request("FirstName")%><br>
<%=Request("LastName")%><br>
<%=Request("StreetNumber")%><br>
<%=Request("StreetName")%><br>
<%=Request("Building")%><br>
<%=Request("Region")%><br>
<%=Request("City")%><br>
<%=Request("States")%><br>
<%=Request("Countries")%><br>
<%=Request("PostalCode")%><br>
<%=Request("AreaCode")%><br>
<%=Request("RegionCode")%><br>
<%=Request("PhoneNumber")%><br>
<%=Request("Email")%><br>
<%=Request("SubmitNow")%><br>
</body>
</html>
