Classic ASP, Stored Procedures and NText

This note is about the problem I had trying to display the NText variable from executing a stored procedure. Atlast, I figured out that we need to have the NText variable as the the last variable in the query in order for the data to get displayed in classic ASP pages.