Conditional regions and Memo Fields

[enzobanzai]

Hi

Im developing the a site in ASP VB Script with Access and I am doing some Conditional regions.

Have any of you done these before and if so have you ever came accross problems with conditional regions and Access Memo fields.

For example I have a few conditional regions in this page

http://www.paperboys.com.au/products_list.asp?catid=1

which displays that papers specs only if there is a entry in the DB for that spec. (eg no colour variations then you wont see that heading on the page)

This all works fine but it wont WORK WITH MEMO FIELDS!!!!!

As you can see it hides the description and heading "Description" if there is no entry but if there is an entry then it displays the heading but not the description itself. (As in the Ace Screenboard paper, this has a descritpion in the database but it wont dislpay online)

I have tested this thousands of time with no luck.

Have any of you ever had to do this before.

Heres and example of the Description Condtional region:

<% if rsProdList.Fields.Item("memProdDescription").Value <>"" then ' Adv Conditional Region %>
<strong>Description:</strong> <%=(rsProdList.Fields.Item("memProdDescription").Value)%><br />
<br />
<% end if ' rsProdList.Fields.Item("memProdDescription").Value <>"" %>

Cheers
Dave

 

[bslintx]

<%
' use a style sheet .css to play w/ color to
' match web page or use <div> tag container
'instead of textarea

If rsProdList("memProdDescription") <> "" then
%>

<strong>Description:</strong>
<p>
<textarea name="pdesc" rows="2" cols="10" readonly><%=rsProdList("memProdDescription")%></textarea></p>

<%
End If
%>

 

[bslintx]

sorry...you're using a table instead of css to design the site....scratch previous post

<% 
  If rsProdList("memProdDescription") <> "" Then
%>

<strong>Description:</strong> <%=rsProdList("memProdDescription")%>
<br />
<br />

<% 
  End If
%>

 

[ChrisHirst]

there is a well known problem with memo/text fields, where you can only reference the field once. The answer is to transfer it to a variable then reference that.


see this thread333-1019242




Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
Nightclub counting systems

So long, and thanks for all the fish.