I have a site using asp pages and an access 2000 database.
I do the following query:

<%
function getProductPage()
Set Connection = GetConnection
objRecordset = "SELECT ProductName, Title, ContentGlance, FunctionGlance, Application, LinkedProduct, subscriptionOptions, Trial, USA, Brochure, ProductDescription, ProductDescriptionNL, " &_
"IIf (Len (ProductOverview.ProductDescriptionNL) > 0 , ProductOverview.ProductDescriptionNL, ProductOverview.ProductDescription) as ProductDescription " &_
"FROM ProductOverview " & _
"WHERE ProductOverview.ProductName='" & productItem & "'"
Set objRecordset = Connection.Execute (objRecordset)
End function
%>

Performing the query in access works well. Instead, from the asp page, it only displays the first 255 caracters of the memo field ProductDescriptionNL and not the entire content.

Does anyone know a solution to avoid this?

Thanks.

Pietro

Place the memo field LAST in your select statement.

If that doesn't work look into the APPENDCHUNK method. (I think..)

Cheers,
Andrew