Writing RecordSet Values

[roynaveen]

Hi, I am using Dreamweaver for last 5 years and i am very happy with the way Dreamweaver is helping me in developing the Dynamic Webpages and Applications. I am using Dreamweaver Version 8. Lately i have a very serious problem while using dreamweaver.

I am trying to write Recordset values to my page i have no problems in writing this value
"(prdList.Fields.Item("prdName").Value)"

Now the problems starts, if i try to write the same value anywhere in the page again or if i am assigning the same value to a hidden field it does not write the value. Which means it write the same value only once.

It is very simple to write a Recordset value to anywhere in the page any number of times and i have done this a million times earlier.

Now if i declare a variable Dim ProductCode and assign the value i want to write to the page to this variable (ProductName = (prdList.Fields.Item("prdName").Value)) and try to write this variable (<%=ProductName%>), everything works perfectly fine.

Again horror, i have say 5 record set values and one amoung this is "(prdList.Fields.Item("prdName").Value)", if i try to do this excersice to any other 4 recordset values it works fine with them. The only problem is with prdName.

Please help me.

[Newsgroup_User]

That's what happens when you use Access' MEMO columns.
Keep using a variable, as you describe below, for each MEMO column that you
need to use more than once.


"roynaveen" <webforumsuser@macromedia.com> wrote in message
news:euql81$mit$1@forums.macromedia.com...
> Hi, I am using Dreamweaver for last 5 years and i am very happy with the
> way
> Dreamweaver is helping me in developing the Dynamic Webpages and
> Applications.
> I am using Dreamweaver Version 8. Lately i have a very serious problem
> while
> using dreamweaver.
>
> I am trying to write Recordset values to my page i have no problems in
> writing
> this value
> "(prdList.Fields.Item("prdName").Value)"
>
> Now the problems starts, if i try to write the same value anywhere in the
> page
> again or if i am assigning the same value to a hidden field it does not
> write
> the value. Which means it write the same value only once.
>
> It is very simple to write a Recordset value to anywhere in the page any
> number of times and i have done this a million times earlier.
>
> Now if i declare a variable Dim ProductCode and assign the value i want to
> write to the page to this variable (ProductName =
> (prdList.Fields.Item("prdName").Value)) and try to write this variable
> (<%=ProductName%>), everything works perfectly fine.
>
> Again horror, i have say 5 record set values and one amoung this is
> "(prdList.Fields.Item("prdName").Value)", if i try to do this excersice to
> any
> other 4 recordset values it works fine with them. The only problem is with
> prdName.
>
> Please help me.
>
>
>