DW8 / ASP Page not displaying records from DB

Report · Feb 27, 2007

Hi,

I've encountered a sporadic and very frustrating problem! When building a simple data retrieval page, everything works fine, from the connection, RS, showing the column values etc. When I click and drag the fields I want displayed and test as I go along, it all works fine. When I drag in an additional field, 4 out of the 6 fields present on the page disappear.

I can cross check and build it up again and dragging in a different field can have a similar affect. That or if I bring them on to the page in a different order it might work. When I change the order, it can bring back the original problem - only a couple of the records display.

I'm running IIS, SQL and using ASP and rapidly going bald as I'm pulling hair out of my head.

Thanks in advance for any help.

MS

Report · Feb 27, 2007

Hi Muck,

In your SELECT statement, make sure that any ntext fields are reference
last. Let's say you have a description field in your table that is ntext.
You need to make sure your statement is as follows:
SELECT recordID, recordtitle, recorddescription FROM table...

...as opposed to:

SELECT recordID, recorddescription, recordtitle FROM table...

There is a strange bug that causes the ntext fields to not display is they
are not referenced last in the statement. I really don't know why, but it
does. Gotta love Dreamweaver! :o(

Hope this helps.
Nath.

"MuckSavage" <webforumsuser@macromedia.com> wrote in message
news:es12bq$5l1$1@forums.macromedia.com...
> Hi,
>
> I've encountered a sporadic and very frustrating problem! When building a
> simple data retrieval page, everything works fine, from the connection,
> RS,
> showing the column values etc. When I click and drag the fields I want
> displayed and test as I go along, it all works fine. When I drag in an
> additional field, 4 out of the 6 fields present on the page disappear.
>
> I can cross check and build it up again and dragging in a different field
> can
> have a similar affect. That or if I bring them on to the page in a
> different
> order it might work. When I change the order, it can bring back the
> original
> problem - only a couple of the records display.
>
> I'm running IIS, SQL and using ASP and rapidly going bald as I'm pulling
> hair
> out of my head.
>
> Thanks in advance for any help.
>
> MS
>

Report · Feb 27, 2007

"tradmusic.com" <sales@NOSHPAMtradmusic.com> wrote in message
news:es1502$8fc$1@forums.macromedia.com...
> There is a strange bug that causes the ntext fields to not display is they
> are not referenced last in the statement. I really don't know why, but it
> does. Gotta love Dreamweaver! :o(

It's not really a bug (though that might be arguable), and it has nothing to
do with Dreamweaver. It's simply a consequence of how the ADO provider
works with firehose cursors. I suggest doing exactly what you suggested -
list the columns last and in order - so that you still get the lightest
cursor possible (or in the case of 8.02 recordsets, the only cursor
possible).

Report · Feb 28, 2007

Hi guys,

Thank you, thank you, thank you. You've just made a very frustrated MuckSavage into a happy one.

Cheers,

MS