Data not visible ASP VBScript & SQL

[Simon Gare]

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

 

[Mike Brind]

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 <td>s or
something like that.

 

[Simon Gare]

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