FAQ #4: My memo fields are not working. I get the error message:
Microsoft OLE DB Provider for ODBC Drivers error '80020009' or other errors

Let us look at a typical problem Query and the solution:

SELECT * from cargo where city LIKE "New York"
produces errors if the memo fields are retrieved.

(for the sake of this example the memo fields are marked in red
CargoID, CargoName, Comments, Street,  City, State,Zip, ShippingNotes and DueDate)

Memo fields have the following issues

Issue #1: Memo fields may only be reliably fetched once.

If Len(rstemp("comments"))=0 THEN
   ....
END IF %>
the comment was <%=rstemp("comments")%>!

is likely to fail because an attempt to fetch it more than once was made.

memo_comments=rstemp("comments")
If LEN(memo_comments)=0 THEN
   ....
END IF %>
the comment was <%=memo_comments%>!

 

Issue #2: Memo Fields must be listed last in the query.

MEMO/BLOBS must be listed last explictly.

SELECT CargoID,CargoName, Street,City, State,Zip,DueDate,ShippingNotes,Comments
from cargo where city LIKE "New York"
produces no errors since the memo fields are listed last.

Check out http://support.microsoft.com/support/kb/articles/q175/2/39.asp   as well for more details.

There are many worthy charities!!. But perhaps help starving children in Africa or South America AND help Charles too. a $5 tip buys him lunch at McDonalds, a $20 tip buys his kid Hitoshi a new computer game, a $39 tip buys his daughter Michiko a few nice outfits. See our donor list.