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. Advertisements

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,377
    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:
    575
    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:
    616
    Scott David Daniels
    Mar 8, 2006
  4. Diez B. Roggisch

    pydb remote debugging/cmd.Cmd over socket?

    Diez B. Roggisch, May 28, 2008, in forum: Python
    Replies:
    2
    Views:
    735
    Diez B. Roggisch
    May 29, 2008
  5. Diez B. Roggisch

    cmd.Cmd bug or at least docu-bug

    Diez B. Roggisch, May 29, 2008, in forum: Python
    Replies:
    1
    Views:
    479
    Michele Simionato
    May 29, 2008
  6. Jean-Michel Pichavant

    python cmd.Cmd auto complete feature

    Jean-Michel Pichavant, Mar 8, 2011, in forum: Python
    Replies:
    0
    Views:
    494
    Jean-Michel Pichavant
    Mar 8, 2011
  7. Kevin Audleman

    Bizarre error in cmd.CreateParameter

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