>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
