Mike Waller
asked on
display query output in columns and rows
How can I display the output in a table so that it's 4 down with 3 rows across or 4 down with 4 rows across:
<cfset CurrentPage=GetFileFromPat h(GetTempl atePath()) >
<cfparam name="PageNum_myquery" default="1">
<cfquery name="myquery" datasource="dsn">
SELECT *
FROM listings
where status = 'active'
order by MyIdentity asc
</cfquery>
<cfset MaxRows_myquery=4>
<cfset StartRow_myquery=Min((Page Num_myquer y-1)*MaxRo ws_myquery +1,Max(myq uery.Recor dCount,1)) >
<cfset EndRow_myquery=Min(StartRo w_myquery+ MaxRows_my query-1,my query.Reco rdCount)>
<cfset TotalPages_myquery=Ceiling (myquery.R ecordCount /MaxRows_m yquery)>
<cfset QueryString_myquery=Iif(CG I.QUERY_ST RING NEQ "",DE("&"&XMLFormat(CGI.QU ERY_STRING )),DE("")) >
<cfset tempPos=ListContainsNoCase (QueryStri ng_myquery ,"PageNum_ myquery=", "&")>
<cfif tempPos NEQ 0>
<cfset QueryString_myquery=ListDe leteAt(Que ryString_m yquery,tem pPos,"&")>
</cfif>
<cfoutput query="myquery" startrow="#StartRow_myquer y#" maxrows="#MaxRows_myquery# ">#short_n ote#<!--- <img src="props/#photo_main#" width="648" height="6" border="" alt=""> ---><br><br></cfoutput>
<cfset CurrentPage=GetFileFromPat
<cfparam name="PageNum_myquery" default="1">
<cfquery name="myquery" datasource="dsn">
SELECT *
FROM listings
where status = 'active'
order by MyIdentity asc
</cfquery>
<cfset MaxRows_myquery=4>
<cfset StartRow_myquery=Min((Page
<cfset EndRow_myquery=Min(StartRo
<cfset TotalPages_myquery=Ceiling
<cfset QueryString_myquery=Iif(CG
<cfset tempPos=ListContainsNoCase
<cfif tempPos NEQ 0>
<cfset QueryString_myquery=ListDe
</cfif>
<cfoutput query="myquery" startrow="#StartRow_myquer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.