access 2000 memo fields and asp [Archive]

ppa

10-08-02, 08:44

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