If you use SELECT * on a table with the column type NTEXT, your resultset will not display the NTEXT column on a Web page when using ASP to show the recordset.
To ensure that the NTEXT contents display, move the NTEXT column to the last column in your recordset. If you are pulling data from a view, the same thing applies?try thinking of NTEXT columns as the ‘anchor’ to your recordset.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
