Memo Field

[Guest]

What function do I need to use to check to see if a memo field is blank. I
have tried isnull, isempty, "" and " ".

All of these don't work. I'm pulling the memo field from an access database.

Any help would be greatly appreciated.
Terry

 

[Thomas A. Rowe]

Depends on what attributes you have assigned to the field in Access.

I normal use:

If recordset("memo") > " " Then
<%=recordset("memo")%>
End If

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

Thomas, thank for the suggestion. I tried what you have below and here is
the error that I got on the web page

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be
displayed.

Please try the following:

* Click the Refresh button, or try again later.
* Open the localhost home page, and then look for links to the
information you want.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

* Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'recordset'
/test.asp, line 52

* Browser Type:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
Netscape/7.1 (ax)

* Page:
GET /test.asp

* Time:
Wednesday, October 20, 2004, 9:27:42 PM

* More information:
Microsoft Support

The field in Access is a "MEMO" field. Again, I have tried IsNull, IsEmpty,
"" and I even tried &nbsp.

I don't know what is in the field for it to recoginze. I hope to be able to
figure it out.

Thanks.

 

[Stefan B Rusynko]

Did you use "recordset" to open the DB connection?
as in
<%
Dim recordset
Set recordset = Server.CreateObject("ADODB.Recordset")
recordset.Open .............(your SQL & connection name)
If recordset("memo") > " " Then
<%=recordset("memo")%>
End If

%>



--




| Thomas, thank for the suggestion. I tried what you have below and here is
| the error that I got on the web page
|
| The page cannot be displayed
| There is a problem with the page you are trying to reach and it cannot be
| displayed.
|
| Please try the following:
|
| * Click the Refresh button, or try again later.
| * Open the localhost home page, and then look for links to the
| information you want.
|
| HTTP 500.100 - Internal Server Error - ASP error
| Internet Information Services
|
| Technical Information (for support personnel)
|
| * Error Type:
| Microsoft VBScript runtime (0x800A000D)
| Type mismatch: 'recordset'
| /test.asp, line 52
|
| * Browser Type:
| Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
| Netscape/7.1 (ax)
|
| * Page:
| GET /test.asp
|
| * Time:
| Wednesday, October 20, 2004, 9:27:42 PM
|
| * More information:
| Microsoft Support
|
| The field in Access is a "MEMO" field. Again, I have tried IsNull, IsEmpty,
| "" and I even tried &nbsp.
|
| I don't know what is in the field for it to recoginze. I hope to be able to
| figure it out.
|
| Thanks.
|
| "Thomas A. Rowe" wrote:
|
| > Depends on what attributes you have assigned to the field in Access.
| >
| > I normal use:
| >
| > If recordset("memo") > " " Then
| > <%=recordset("memo")%>
| > End If
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > WEBMASTER Resources(tm)
| >
| > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > ==============================================
| > To assist you in getting the best answers for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| >
| > | > > What function do I need to use to check to see if a memo field is blank. I
| > > have tried isnull, isempty, "" and " ".
| > >
| > > All of these don't work. I'm pulling the memo field from an access database.
| > >
| > > Any help would be greatly appreciated.
| > > Terry
| >
| >
| >