In using GetRows() in an asp/vbscript page, including a field from a small record set which contains URLs, the GetRows() fails to get one or more of the other fields . Using the query below, the sueBlogWhatsHotParagraph field is blank
The SQL query is
"SELECT sueBlogWhatsHotSource, sueBlogWhatsHotParagraph, sueBlogWhatsHotUrl FROM tblSueBlogWhatsHot WHERE (sueBlogID = '"&CInt(selectedBlogID)&"'
) AND (sueBlogWhatsHotEndDate IS NULL OR sueBlogWhatsHotEndDate >= GETDATE()) ORDER BY sueBlogWhatsHotOrder"
The four URL fields are
I have experimented by including additional fields and the resulting missing fields in the array changes with the position of the URL field in the SQL query. The URL field does appear in the array again dependent upon its position in the query.
Reloading the GetRows() array by looping through the original record set works.