Repeat region problem - field not displaying

[Newsgroup_User]

Hi,

I have a page with a repeat region on it. Inside this piece of code, I have
got it displaying 3 fields from a table: an image, a title and a
description.

Everything works fine when I have only the image and title inserted into the
page. However, when I add the 3rd field from the table into the page, it
does not show up! I don't understand this. What makes it even spookier is
that If I place the description field before either of the other 2, they all
show up.

Can anyone help me?

[Newsgroup_User]

Okay, i've found where i'm going wrong. The field that won't show is a nText
type in my SQL server database. I need to change the CursorLocation value
from 2 to 3. Either that, or change the field type from nText to Varchar.


"Mintyman" <mintyman@ntlworld.com> wrote in message
news:e8j2vu$bmh$1@forums.macromedia.com...
> Hi,
>
> I have a page with a repeat region on it. Inside this piece of code, I
> have got it displaying 3 fields from a table: an image, a title and a
> description.
>
> Everything works fine when I have only the image and title inserted into
> the page. However, when I add the 3rd field from the table into the page,
> it does not show up! I don't understand this. What makes it even spookier
> is that If I place the description field before either of the other 2,
> they all show up.
>
> Can anyone help me?
>

[Newsgroup_User]

Mintyman

Think there is a problem with nText or Text or Memo fields displaying,
depending on where you place them in the Select statement of the SQL. From
what I can recall, you have to call these field types last in your Select
statement.

Brendan

______________________________________________
Rate your experiences with your UK and Ireland builders at
http://www.ratethebuilder.co.uk
=========================================


"Mintyman" <mintyman@ntlworld.com> wrote in message
news:e8j47r$d7f$1@forums.macromedia.com...
> Okay, i've found where i'm going wrong. The field that won't show is a
> nText type in my SQL server database. I need to change the CursorLocation
> value from 2 to 3. Either that, or change the field type from nText to
> Varchar.
>
>
> "Mintyman" <mintyman@ntlworld.com> wrote in message
> news:e8j2vu$bmh$1@forums.macromedia.com...
>> Hi,
>>
>> I have a page with a repeat region on it. Inside this piece of code, I
>> have got it displaying 3 fields from a table: an image, a title and a
>> description.
>>
>> Everything works fine when I have only the image and title inserted into
>> the page. However, when I add the 3rd field from the table into the page,
>> it does not show up! I don't understand this. What makes it even spookier
>> is that If I place the description field before either of the other 2,
>> they all show up.
>>
>> Can anyone help me?
>>
>
>