dynamic text field limitation after 8.02 update

[maesdomi]

After updating to DW8.02 we can’t display more than one time the same dynamic text or memo field. Before the update we have just to change the recordset cursor type and lock type but now we can’t do it anymore.
Any idea to resolve this?
Many thanks in advance
We use asp vbscript tested with sql server 2000, 2005, and express and access 2003.

[Newsgroup_User]

"maesdomi" <domi.maes@djmweb.be> wrote in message
news:e4cvnq$5l4$1@forums.macromedia.com...
> After updating to DW8.02 we can?t display more than one time the same
> dynamic
> text or memo field. Before the update we have just to change the recordset
> cursor type and lock type but now we can?t do it anymore.
> Any idea to resolve this?
> Many thanks in advance
> We use asp vbscript tested with sql server 2000, 2005, and express and
> access
> 2003.

That's because the new recordset behaviors use command objects instead of
recordset objects.
The best solution is to save your memo field to a local variable, then use
that variable instead.
Ex:

<%
myMemo = myRS.Fields.Item("myMemoField").Value
%>

Now, use myMemo everywhere you would normally have used
myRS.Fields.Item("myMemoField").Value