Posted by Adrienne Boswell on 11/04/07 07:46

Gazing into my crystal ball I observed "Jonathan N. Little"
<lws4art@centralva.net> writing in
news:fab3$472d410a$40cba7c4$8201@NAXS.COM:

> Bone Ur wrote:
>> Well bust mah britches and call me cheeky, on Sun, 04 Nov 2007
>> 02:53:32 GMT Jonathan N. Little scribed:
>>
>>> I think dorayme is right here, server-side would have no idea what
>>> available size with respect to the browser. I think it would require
>>> some nasty JavaScript to calculate the available space and
>>> reposition the contents. And of course would also have to hook the
>>> onresize to do the process all over again if the user resizes the
>>> browser... yuck!
>>
>> Not necessarily. One could use string-length of (record/row),
>> converting the max to an em number with a reasonable amount of
>> leeway/slop, then float the tables/containers themselves. The number
>> of containers would be to taste, -sensible, of course, and their
>> max-width would need to be a suitable fraction of typical
>> screenwidth. This might break with super- large font-sizes, but most
>> things do, anyway.
>>
>
> But you cannot get the browser viewport via server-side. This is a
> client-side job. Also you need to know the height, not the width
> inorder to "wrap" to the next column as the OP wishes...more fun...
>

Getting the height is simple, for example, let's say you have a maximum
of 30 items in your record set. I do most of my development in ASP, so
here it is in ASP.

set rs = createobject("ADODB.Recordset")
rs.Open sql, oconn

if not rs.EOF then
rsarr = rs.getrows()
end if
rs.Close
set rs = nothing 'destroy the recordset
connection.close
set connection = nothing 'destroy the connection to the db


breakrow = ubound(rsarr,2)/2

for i = 0 to breakrow
%>
<li><%=rsarr(0,i)%></li>
<%
next
%>
</ul>
<ul>
<% for i = breakrow+1 to ubound(rsarr,2)%>
<li><%=rsarr(0,i)%></li>
<%
next
%>
</ul>



--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

[Back to original message]