|
hzarabet -> 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
|
|
|
|
