[thelist] SQL Server tip

[Cory Preus]

Last week I had a question about missing elements from a recordset using ASP
to query SQL server data. I found the problem and some folks might be
interested in the info.

Cheers.

<tip type="SQL Server">

If you do not have Mdac 2.1sp2 or later with the 3.7 driver or later for SQL
Server installed, text/BLOB fields are selected in an order preceding other
types of fields. Thus, it is necessary to structure your SQL query with text
and BLOB fields last.

SELECT [id], [date], [text], [blob] FROM [table]

Moreover, it is important to retrieve the data from the recordset in a
similar fashion. Minor fields first and text/BLOBs last (in the order stated
in the SQL statement).

A more robust explanation is available here:
http://support.microsoft.com/support/kb/articles/Q175/2/39.asp

Or one can just upgrade Mdac and the SQL server driver. ;)
http://www.microsoft.com/data/download.htm

</tip>