Thread: access 2000 memo fields and asp
10-08-02, 08:44 #1Registered User
- Join Date
- Oct 2002
Unanswered: access 2000 memo fields and asp
I have a site using asp pages and an access 2000 database.
I do the following query:
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)
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?
11-01-02, 00:23 #2Registered User
- Join Date
- Jul 2002
Place the memo field LAST in your select statement.
If that doesn't work look into the APPENDCHUNK method. (I think..)
AndrewThere have been many posts made throughout the world.
This was one of them.