Skip to main content
Participant
May 16, 2006
Question

dynamic text field limitation after 8.02 update

  • May 16, 2006
  • 1 reply
  • 233 views
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.
This topic has been closed for replies.

1 reply

Inspiring
May 16, 2006
"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