#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    18
    Rep Power
    0

    createparameter for TEXT.


    When adding a parameter that is of type TEXT in the database, what replaces the bit that might otherwise say 'adVarChar' or 'adInteger'?

    e.g.

    Code:
    CreateParameter("@QuizQuestionOptionText", adVarChar, adParamInput)
    Cheers.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Location
    Las Vegas
    Posts
    12
    Rep Power
    0

    adLongVarChar (I think)


    I don't know for sure (I saw this someplace else online), but try: adLongVarChar.

    Good luck.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    18
    Rep Power
    0
    adLongVarChar doesn't appear to work either:

    ADODB.Parameters (0x800A0E7C)
    Parameter object is improperly defined. Inconsistent or incomplete information was provided.

    On further investigation I've found that adLongVarChar is correct:
    http://www.devguru.com/Technologies/ado/quickref/command_createparameter.html




    Perhaps it is the declaration in the stored procedure that is incorrect?

    I have declared it as 'TEXT' ?

IMN logo majestic logo threadwatch logo seochat tools logo