Ado error

Results 1 to 3 of 3

Thread: Ado error

  1. #1
    Join Date
    Dec 1969
    Posts
    247

    Default Ado error

    ADODB.Command error &#039 800a0bb9&#039 <BR><BR>The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. <BR><BR>any idea

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Ado error

    We&#039re going to need to see more code. How you create all your ADO objects, how you are opening them, etc. Just show us all your ADO-related code for that page, and we should be able to help! :)

  3. #3
    Join Date
    Dec 1969
    Posts
    247

    Default RE: Ado error

    a customer enter a product that wanted to add it to his wishing list table, he enter prod_id or cust_id he should see his wnew wish list that he added.<BR>I ccalled the stor proc tha this way:<BR><BR>&#039Create the objects<BR> <BR>Set MSCS = Server.CreateObject("ADODB.Connection")<BR>&#039Se t rsWishList = Server.CreateObject("ADODB.Recordset")<BR>&#039rsW ishList.Open MSCSSite.DefaultConnectionString<BR><BR>&#039Open the connection<BR>MSCS.Open MSCSSite.DefaultConnectionString<BR><BR>&#039 Create the command object<BR>Set objSPcmd = Server.CreateObject("ADODB.Command")<BR><BR>&#039f ill in the command properties<BR>Set objSPcmd.ActiveConnection = MSCS<BR>objSPcmd.CommandType = adCmdStoredProc<BR>objSPcmd.CommandText = "sp_addTOY_WISHLIST"<BR><BR>&#039Create the parameters<BR>set p1 = objSPcmd.CreateParameter("@customer_id",adinteger, adParamInput,,objSPcmd("@customer_id"))<BR>objSPcm d.Parameters.Append p1<BR>set p2 = objSPcmd.CreateParameter("@wishlist_id",adtinyint, adParamInput,,objSPcmd("@wishlist_id"))<BR>objSPcm d.Parameters.Append p2<BR>set p3 = objSPcmd.CreateParameter("@produst_id",adinteger, adParamInput,,objSPcmd("@product_id"))<BR>objSPcmd .Parameters.Append p3<BR>set p4 = objSPcmd.CreateParameter("@wishlist_cmmt",advarcha r, adParamInput,180,objSPcmd("@wishlist_cmmt"))<BR>ob jSPcmd.Parameters.Append p4<BR><BR>&#039set up parameters values<BR>objSPcmd("@customer_id")=Request.QuerySt ring("CUST_ID")<BR>objSPcmd("@product_id")=Request .QueryString("SKU")<BR>objSPcmd("@wishlist_id")= Request.QueryString("WL")<BR>objSPcmd("@wishlist_c mmt") = Request.QueryString("CMMT")<BR><BR>&#039Now open it<BR> objSPcmd.Execute

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •