Sql statement error with ntext field
-
select itemlookupcode,extendeddescription from item where itemlookupcode = '14010006'the extendeddesription data type is ntext i get the error when executing the commandAn error occurred while executing query: Page (1:735), slot 40 for text, ntext, or image node does not exist.i cannot even execute the delete and update statement to amend this row, any1 can help me?:( -
select itemlookupcode,extendeddescription from item where itemlookupcode = '14010006'the extendeddesription data type is ntext i get the error when executing the commandAn error occurred while executing query: Page (1:735), slot 40 for text, ntext, or image node does not exist.i cannot even execute the delete and update statement to amend this row, any1 can help me?:(Is this article applicable to your issue? http://support.microsoft.com/default.aspx?scid=kb;en-us;320434&sd=tech[^]
-
Is this article applicable to your issue? http://support.microsoft.com/default.aspx?scid=kb;en-us;320434&sd=tech[^]
-
select itemlookupcode,extendeddescription from item where itemlookupcode = '14010006'the extendeddesription data type is ntext i get the error when executing the commandAn error occurred while executing query: Page (1:735), slot 40 for text, ntext, or image node does not exist.i cannot even execute the delete and update statement to amend this row, any1 can help me?:( -
try by converting column extendeddescription into varchar select itemlookupcode,Convert(varchar,extendeddescription) as description from item where itemlookupcode = '14010006'
Albanian wrote:
try by converting column extendeddescription into varchar select itemlookupcode,Convert(varchar,extendeddescription) as description from item where itemlookupcode = '14010006'
Still cannot solve the problem, below is the Error Return by Query Analyzer:
Server: Msg 7105, Level 22, State 6, Line 1 Page (1:26314), slot 66 for text, ntext, or image node does not exist. Connection BrokenAny1 can help me please??:(( -
Well then, here's another possibility: http://support.microsoft.com/kb/890755[^] Incidentally, I have found these by Googling for the following:
Page slot for text, ntext, or image node does not exist.so if the technote doesn't apply for you, you may want to Google the above phrase yourself and see what you can get.