>Not sure what you mean by side by side... This? > > <cfquery name="members" datasource="test"> SELECT ID, firstName, > lastName, email FROM Membership </cfquery> > > <table border="0" cellpadding="0" cellspacing="0"> > <cfoutput query="members"> > <tr> > <td>First Name</td> > <td>#firstName#</td> > </tr> > > <tr> > <td>Last Name</td> > <td>#lastName#</td> > </tr> > > <tr> > <td>Email</td> > <td>#email#</td> > </tr> > <tr><td colspan="3"><hr /></td></tr> > </cfoutput> > </table> > >OR do you mean... > ><table border="0" cellpadding="0" cellspacing="0"> ><tr> ><td>FirstName:</td> ><cfloop from="1" to="#members.recordcount#" >index="f"><td>#members['firstname'][f]#</td></cfloop> ></tr> > ><tr> ><td>LastName:</td> ><cfloop from="1" to="#members.recordcount#" >index="l"><td>#members['lastname'][l]#</td></cfloop> ></tr> > ><tr> ><td>Email:</td> ><cfloop from="1" to="#members.recordcount#" >index="e"><td>#members['email'][e]#</td></cfloop> ></tr> ></table> > >Or do you mean something else entirely? > >.:.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com
As a matter of fact non of them. I found a way to do that. I write the code down: <cfparam name="PageNum_Recordset1" default="1"> <cfquery name="Recordset1" datasource="test"> SELECT * FROM Membership </cfquery> <cfset MaxRows_Recordset1=6> <cfset StartRow_Recordset1=Min((PageNum_Recordset1-1)*MaxRows_Recordset1+1,Max(Recordset1.RecordCount,1))> <cfset EndRow_Recordset1=Min(StartRow_Recordset1+MaxRows_Recordset1-1,Recordset1.RecordCount)> <cfset TotalPages_Recordset1=Ceiling(Recordset1.RecordCount/MaxRows_Recordset1)> <table border="1"> <tr> <cfoutput query="Recordset1"> <td><table width="444" height="44" border="0" cellpadding="1" cellspacing="1" bordercolor="##996633"> <tr> <td>#Recordset1.firstName#</td> <td>#Recordset1.lastName#</td> <td>#Recordset1.email#</td> </tr> </table></td> <cfscript> if (NOT Recordset1.CurrentRow eq Recordset1.RecordCount AND Recordset1.CurrentRow mod 2 eq 0) { writeoutput("</tr><tr>"); } </cfscript> </cfoutput> </tr> </table> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4