ASP page won't display text from MS Access Memo field 
Author Message
 ASP page won't display text from MS Access Memo field

Up until this point, all of the text fields in my Access database have
been of the Text datatype.  However, I have a need to increase the
maximum number of characters in the field above 255 so I changed the
datatype to Memo.  However, for some reason, when I try to retrieve the
text from the fields now and display it in a standard html page, it
returns nothing.  Is there a different way to retrieve data from a memo
type field or is there an issue with the Memo datatype in Access?  Any
help would be appreciated.  Thanks.

Sincerely,
Ryan Bolger



Tue, 14 Aug 2001 03:00:00 GMT  
 ASP page won't display text from MS Access Memo field
Ryan,

First of all check to make sure that there is text in the memo field, I'm
not trying to be a jerk but sometimes the simplest answer is the answer.
Second make sure you have spelled the field name correctly in all places
(Sql string, reference, maybe even variables you stored the value in.
Third make sure you don't have and if then else statements that could
randomly cause the field to either not be retrieved or deleted from a
variable.
Fourth if none of the above work then e-mail me the asp page (take out the
DSN name and database passwords and stuff but leave everything else) and
I'll debug it myself.

Regards,
Brian Roberds
Network Admin, Webmaster
Odyssey Digital Printing, Inc.
----------------------------------------------------------------------------
----
Some of my web sites:
http://www.OdysseyPrint.com - Odyssey Digital Printing, Inc. (Incredibly out
dated rebuilding in Flash 3.0)
http://www.TUSigmaChi.com - Local undergraduate chapter of my fraternity
(Partners- Binoy Agarwal, Kyle Wander)
http://webdev.utlusa.edu/conted - Engineering Section of the University of
Tulsa's Continuing Education Division
----------------------------------------------------------------------------
----
Those Under Construction:
http://www.IhloffSpa.com - (In the layout stage) Ihloff Salon in Tulsa, OK
(Partner- Binoy Agarwal)
http://www.OdysseyOnline.net - (layout complete) Web Page Design Division of
Odyssey Digital Printing (Partner- Binoy Agarwal)
----------------------------------------------------------------------------
----

Quote:

>Up until this point, all of the text fields in my Access database have
>been of the Text datatype.  However, I have a need to increase the
>maximum number of characters in the field above 255 so I changed the
>datatype to Memo.  However, for some reason, when I try to retrieve the
>text from the fields now and display it in a standard html page, it
>returns nothing.  Is there a different way to retrieve data from a memo
>type field or is there an issue with the Memo datatype in Access?  Any
>help would be appreciated.  Thanks.

>Sincerely,
>Ryan Bolger




Wed, 15 Aug 2001 03:00:00 GMT  
 ASP page won't display text from MS Access Memo field
Ryan,

There is an issue with using memo fields from a VBScript page.
You cannot reference the same memo field twice.  If you need to be able to
use it more than once in your page then assign the value to a local variable
and use that.
e.g.

This will not work:

if RS("MyMemoField") <> "" then
    Response.Write(RS("MyMemoField"))
End If

This will:

MyMemoField = RS("MyMemoField")

if MyMemoField <> "" then
    Response.Write(MyMemoField)
End If


Quote:
> Up until this point, all of the text fields in my Access database have
> been of the Text datatype.  However, I have a need to increase the
> maximum number of characters in the field above 255 so I changed the
> datatype to Memo.  However, for some reason, when I try to retrieve the
> text from the fields now and display it in a standard html page, it
> returns nothing.  Is there a different way to retrieve data from a memo
> type field or is there an issue with the Memo datatype in Access?  Any
> help would be appreciated.  Thanks.

> Sincerely,
> Ryan Bolger




Wed, 15 Aug 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Access 2000 memo type fields don't display on my ASP pages

2. Displaying MS Access fields over 255 characters (Memo fields)

3. Access memo field won't accept more than 255 chars

4. Reporting Rich Text in Memo Field in MS Access

5. Reporting Rich Text in Memo Field in MS Access

6. Using ASP to read email address in MS Access field and display

7. Handling MS Access memo fields

8. MEMO FIELDS - displaying as string text

9. Displaying Memo Fields as Text

10. Entering vast amont of text into memo-field of access-database (on server)

11. Problem returning data from a scroll text box to an Access memo field

12. Format Text Stored in Access Memo Fields

 

 
Powered by phpBB® Forum Software