Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Unanswered: access 2000 memo fields and asp

    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

  2. #2
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    Place the memo field LAST in your select statement.

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

    Cheers,
    Andrew
    There have been many posts made throughout the world.
    This was one of them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •