|
| |
|
|
hzarabet
Posts: 1539
From: New Milford CT USA
Status: offline
 |
Breaking one long column into many - 8/20/2002 22:55:38
Hi All:
I am sure I just reinvented the wheel, but this is something I have been wondering how to do for a while and just got to work so I thought I' d share it.
I am using the DWR on a diet. I wanted to break one long column up into 3 equal smaller columns. Like this
Here is the html
<!--#include file=" ../_fpclass/fpdblib.inc" --><%
fp_sQry=" SELECT Count(*) AS Total FROM SHL_Promoters WHERE PromoterEmail <> ' 0' "
fp_sDataConn=" xxxxxx"
fp_iCommandType=1
%>
<!--#include file=" ../_fpclass/fpdbrgn1.inc" -->
<%
DIM iTotal
iTotal = FP_FieldVal(fp_rs," Total" )
%>
<!--#include file=" ../_fpclass/fpdbrgn2.inc" -->
<%Dim iRCount
iRCount = 0
%>
<table width = " 100%" ><tr>
<td width = " 33%" height = ' 0' valign = ' top' ><font face=" Arial" size=" 2" ><!--#include file=" ../_fpclass/fpdblib.inc" --><%
fp_sQry=" SELECT Promoter FROM SHL_Promoters WHERE PromoterEmail <> ' 0' Order By Promoter"
fp_sDefault=" "
fp_sNoRecords=" "
fp_sDataConn=" xxxxxx"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=" "
fp_sMenuValue=" "
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file=" ../_fpclass/fpdbrgn1.inc" -->
<%iRCount = iRCount+1%>
<%=iRCount%>. <%=FP_FieldVal(fp_rs," Promoter" )%><br><%
If iRCount = Int(iTotal/3) OR iRCount = Int((iTotal/3)*2) then
response.write " </font></td><td width = ' 33%' height = ' 0' valign = ' top' > <font face=' Arial' size=' 2' >"
end if
%>
<!--#include file=" ../_fpclass/fpdbrgn2.inc" -->
</font></td>
</tr>
</table>
Hope this can be of use to someone
< Message edited by hzarabet -- 8/19/2002 10:58:16 PM >
_____________________________
http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 