How do I get an ASP to display a "Memo" field from Access

[Don Walton]

I am having trouble getting the memo field to display in an ASP on my web
site. It is coming from an Access file. Can anyone help?

Thanks

Don Walton

 

[Kathleen Anderson [MVP - FrontPage]]

What kind of trouble are you having? Error messages, etc.?

 

[clintonG]

This is a known issue. I'm sorry I can't remember exactly how to resolve but
as I recall we had to do something like declare the name of the memo field
as the first value passed to the SQL command or something very similar to
that response as it had something to do with the order of this or that.

Ambiguous for sure but I'm fairly confident that this issue will be
documented at the ASP FAQ [1] which you should learn about using anyway.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/


[1] http://aspfaq.com/

 

[MD Websunlimited]

Hi Don,

Make the memo column the last column selected by the SQL. Also, use the native JET driver.

 

[Jon Spivey]

You'd also want to assign it to a variable,eg
<%
set oRs = connection.execute("select field1, field2, memofield from table")
memo = oRs("MemoField")
%>