Bizarre error with cmd.CreateParameter

Discussion in 'ASP .Net' started by audleman@quasika.net, Apr 18, 2006.

  1. Guest

    I am trying to pass a text string into a stored procedure via a
    parameter, and am getting the baffling error:
    adErrDataConversion 3421 You are using a value of the wrong type for
    the current operation.

    I know for sure that the data type I've selected is correct. The code
    looks like this:

    Set plsShare = cmd.CreateParameter("@shareIdeas", adVarChar,
    adParamInput, 500, trim(Request("Please share your ideas")))

    The crazy thing is that it only throws this error 1/20 times the
    procedure is submitted. The last time it failed, the text string passed
    in was:

    always share a brief inspirational reading/statistic at beginning or
    end of the class and establish a theme around which you teach your
    material. Everything has a story.

    Can anybody explain this error?

    Thank you,
    Kevin
     
    , Apr 18, 2006
    #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. Achim Domma (Procoders)

    read input for cmd.Cmd from file

    Achim Domma (Procoders), Jun 3, 2005, in forum: Python
    Replies:
    2
    Views:
    8,135
    Peter Otten
    Jun 3, 2005
  2. Sarir Khamsi

    Interpreter-like help in cmd.Cmd

    Sarir Khamsi, Jun 9, 2005, in forum: Python
    Replies:
    4
    Views:
    400
    Bengt Richter
    Jun 26, 2005
  3. =?ISO-8859-1?Q?Sch=FCle_Daniel?=

    [exec cmd for cmd in cmds]

    =?ISO-8859-1?Q?Sch=FCle_Daniel?=, Mar 8, 2006, in forum: Python
    Replies:
    3
    Views:
    417
    Scott David Daniels
    Mar 8, 2006
  4. Kevin Audleman

    Bizarre error in cmd.CreateParameter

    Kevin Audleman, Apr 18, 2006, in forum: ASP General
    Replies:
    11
    Views:
    340
    Aaron Bertrand [SQL Server MVP]
    May 1, 2006
  5. news
    Replies:
    3
    Views:
    625
    Bob Barrows
    Jul 13, 2009
Loading...

Share This Page