Microsoft SQL Server forum - Copying Images...

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Copying Images...

terrydievendorf

2005-08-04, 4:50 pm

Getting the familiar error: The text, ntext, and image data types are invalid in this subquery or aggregate expression.

From the following code which tries to copy an image from one record to another:

UPDATE Events
SET ImageData=(SELECT ImageData FROM Events WHERE EventID=@EventID),
ImageType=(SELECT ImageType FROM Events WHERE EventID=@EventID)

WHERE EventID=@ParentEvent
ID

Any ideas? Thanks.

Sponsored Links