insert with SP

Discussion in 'ASP General' started by shank, Mar 3, 2005.

  1. shank

    shank Guest

    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>
     
    shank, Mar 3, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. cannontrodder
    Replies:
    1
    Views:
    752
    cannontrodder
    Jul 25, 2006
  2. Replies:
    1
    Views:
    466
  3. Replies:
    1
    Views:
    1,853
    Albert Hopkins
    Dec 6, 2008
  4. eagle

    Insert & Insert/Repeat buttons in a detailsview

    eagle, Jul 12, 2007, in forum: ASP .Net Datagrid Control
    Replies:
    0
    Views:
    1,080
    eagle
    Jul 12, 2007
  5. Feege
    Replies:
    0
    Views:
    493
    Feege
    Dec 20, 2005
Loading...

Share This Page