Memo Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
==============================================
 
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.
 
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
| >
| >
| >
 
Back
Top