Detecting the lenght of a MEMO field retrieved from a SQL database

[Ken Lomax]

Hi

using VBScript, SQL, ASP I would like to show the contents of a memo
field but only if it is not empty. I can do this with regular text
fields, but not a memo field. So something like:

sCommand = "SELECT aMemoField FROM aTable"
set sDetails=conn.execute(scommand)
if sDetails(0)<>"" then
%>..<%=sDetails(0)%><br>
<%end if%>

but this does not work with a memo field.
Can anyone please help??
Thanks
Ken


*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows [MVP]]

Ken Lomax wrote:

> Hi
>
> using VBScript, SQL, ASP I would like to show the contents of a memo
> field but only if it is not empty. I can do this with regular text
> fields, but not a memo field. So something like:
>
> sCommand = "SELECT aMemoField FROM aTable"
> set sDetails=conn.execute(scommand)
> if sDetails(0)<>"" then
> %>..<%=sDetails(0)%><br>
> <%end if%>
>
> but this does not work with a memo field.

What does "does not work" mean? Error message? Incorrect result?

I normally use the len() function with all strings instead of comparing to
"". Your logic is missing a step however: you should test for EOF before
attempting to read the contents of a Field (why not use the more
straightforward "rs" for your recordset variable?):
if not sDetails.EOF then
if len(sDetails(0)) > 0 then
...
end if
end if

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Aaron [SQL Server MVP]]

Is it MEMO in Access, or TEXT in SQL Server? SQL Server doesn't have a MEMO
datatype.

What does "does not work" mean?

Have you read:

[url]http://www.aspfaq.com/2188[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"Ken Lomax" <kennethlomax@hotmail.com> wrote in message
news:#bFOOrTTEHA.2544@TK2MSFTNGP10.phx.gbl...

> Hi
>
> using VBScript, SQL, ASP I would like to show the contents of a memo
> field but only if it is not empty. I can do this with regular text
> fields, but not a memo field. So something like:
>
> sCommand = "SELECT aMemoField FROM aTable"
> set sDetails=conn.execute(scommand)
> if sDetails(0)<>"" then
> %>..<%=sDetails(0)%><br>
> <%end if%>
>
> but this does not work with a memo field.
> Can anyone please help??
> Thanks
> Ken
>
>
> *** Sent via Devdex [url]http://www.devdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!