Fafaik you can't just run 'normal' update operations on an ntext type field. If the ExtendedDescription field is of type 'ntext', it doesn't really contain the text but rather a pointer to it (it's actually a type of blob).
Google (or check sqlserver books online) for textptr, readtext, writetext, updatetext,... I've done this in the past a few times, but not enough to know it all from the top of my head (now let's just hope I'm not remembering oracle stuff and talking crap here). Hope this helps... (and if it does: let me know!) Piet. > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: dinsdag 31 januari 2006 3:05 > To: [email protected] > Subject: RE: [php-list] Does anybody know what an "ntext > error" would be in MSSQL? > > > Thank you for your assistance: > > are you sure that ExtendedDescription is the > correct field name? > > Unfortunatley I tried this Query on a few different fields - > very sure of their spelling and no luck. > > Thanks for the suggestion. > > Many Thanks, > Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
