I Use memofields from my access database.

I like to filter them depend of empty or not.
<%
If (Angebote.Fields.Item "Objektbeschreibung_3".Value) <> "" then
%>
<%=(Angebote.Fields.Item("Objektbeschreibung_3".Value)
%>
<% End If %>

Why do i not get any contetns listet on my page even there is something stored in this field or not. It sems to be a problem in the if statement.

Juerg

It looks to me like you are missing an ELSE statement?

But then again...what the heck do I know. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

When in doubt...reboot!

You're missing one '('.
Correct to:
If (Angebote.Fields.Item("Objektbeschreibung_3".Value) &lt;&gt; "" then


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I Use memofields from my access database.

I like to filter them depend of empty or not.
&lt;%
If (Angebote.Fields.Item "Objektbeschreibung_3".Value) &lt;&gt; "" then
%&gt;
&lt;%=(Angebote.Fields.Item("Objektbeschreibung_3".Value)
%&gt;
&lt;% End If %&gt;

Why do i not get any contetns listet on my page even there is something stored in this field or not. It sems to be a problem in the if statement.

Juerg


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I have the same problem using memo field from the access database as well. The extension I used is "Conditional Region - DB Field and Script Version 2.0 developed by Waldo Smeets".

&lt;% If Recordset1.Fields.Item("Information".Value &lt;&gt; ("" Then 'script %&gt;
&lt;%=(Recordset1.Fields.Item("Information".Value)%&gt;
&lt;% End If ' end If Recordset1.Fields.Item("Information".Value &lt;&gt; ("" script %&gt;

Why I do not get any contents listed on the asp page, even there are data stored in memo field. Any problem in the "if" statement as above?

PLEASE HELP!!!

Roger
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Edited by - rycbn on 25 Feb 2002 15:05:50

I am currently having this same problem.

Works fine with a text field in an Access database but when used with a memo field it doenst show regardless of the script or if there is data in the field or not.

any suggestions appreciated

Thanks

Ive converted the datbase to MySQL...works fine now 8^)

yes. excellent. stop using access and all your problems go away. isn't that WEIRD!?!?!

oh, hang on, it's not weird. it's just a fact. access is fucking shit!

------------------------
Julio

PHP | MySQL | DWMX | ColdFusion

ICQ: 19735247