error Msg 279, Level 16, State 3

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fclanton
    New Member
    • Dec 2007
    • 2

    #1

    error Msg 279, Level 16, State 3

    when i run this query ......

    update item set description=(se lect description from item where itemid=5384);

    i get this error message...

    Msg 279, Level 16, State 3, Line 1
    The text, ntext, and image data types are invalid in this subquery or aggregate expression.

    there is a lot of text in the description column of itemid 5384 (html coding) and i need to set all of the records in the table equal to it......
  • mwasif
    Recognized Expert Contributor
    • Jul 2006
    • 802

    #2
    Are you using MySQL Server and which version you are using?

    Comment

    Working...