ASP VBScript
Access database
Table setup with 'memo' as data type.

I have a page the shows the records from a database in a repeat region with a counter. Like so:
1. data
2. more data
3. even more data

I had it setup so that if there was empty record it would not show a line. Trying to avoid the following:
1. Data
2.
3. more data.

It was working fine as long as the datatype in the table was set to 'text'. When I changed the datatype to 'memo' the results page shows no data.

Here is the code that worked with 'text'datatype:

<% if rsSurvey.Fields.Item("q4".Value <>"" then %>
<%=Counter%>. <%=(rsSurvey.Fields.Item("q4".Value)%>


<%
Counter = Counter + 1
end if
rsSurvey.MoveNext()
Wend

So I am thinking that .Value <>"" works with 'text' and not 'memo' but I don't know what to change it to.



alex


Alex E Marino

Never mind ...

I found out that this is a bug in ASP and one has to assign tghe value to a local variable.

alex

Alex E Marino