Data not visible ASP VBScript & SQL

Hi all,

Some pages wont display dynamic data from the SQL DB unless the data is in a
certain order, when I move the dynamic element up the page it becomes
visible.


Does the layout in the SQL DB determine the layout on the page?


Regards

--
Simon Gare
The Gare Group Limited

website: www.thegaregroup.co.uk
website: www.privatehiresolutions.co.uk

Re: Data not visible ASP VBScript & SQL

"Simon Gare" wrote in message
news:OhOcGO4VHHA.4180@TK2MSFTNGP06.phx.gbl...
> Hi all,
>
> Some pages wont display dynamic data from the SQL DB unless the data is in
> a
> certain order, when I move the dynamic element up the page it becomes
> visible.
>
>
> Does the layout in the SQL DB determine the layout on the page?
>

No, but this might be happening:
http://support.microsoft.com/default.aspx/kb/200124. If not, have a look at
the source code of the pages and see if there are overlapping s or
something like that.

--
Mike Brind

Re: Data not visible ASP VBScript & SQL

Hi Mike,

weird one, temporarily solved it by adding the fields manually to the select
statement in the rs, in order, after the select dbo.BookingForm.*

If you have any other thoughts let me know.

Regards
Simon


"Mike Brind" wrote in message
news:eALw$v4VHHA.1212@TK2MSFTNGP03.phx.gbl...
>
> "Simon Gare" wrote in message
> news:OhOcGO4VHHA.4180@TK2MSFTNGP06.phx.gbl...
> > Hi all,
> >
> > Some pages wont display dynamic data from the SQL DB unless the data is
in
> > a
> > certain order, when I move the dynamic element up the page it becomes
> > visible.
> >
> >
> > Does the layout in the SQL DB determine the layout on the page?
> >
>
> No, but this might be happening:
> http://support.microsoft.com/default.aspx/kb/200124. If not, have a look
at
> the source code of the pages and see if there are overlapping s or
> something like that.
>
> --
> Mike Brind
>
>