Javier:
If I understand you correctly you are trying to place two records
side-by-side per row. If this is the case then something like this may
help:
<cfset g = 1>
<cfoutput query="foo">
<cfif g eq 2> <!--- this tells us that if we have two records then it
is time to close the row and start another --->
</tr>
<tr>
<cfset g = 1>
</cfif>
<td>#foo.output_variable#</td>
<cfset g = g + 1>
</cfoutput>
Hope this helps!
-JSLucido
-----Original Message-----
From: Javier Flores [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 7:59 AM
To: [EMAIL PROTECTED]
Subject: Re: Query in 2 columns?
Hi Ken...
It is in a table... your code work in a tw simple columns... I need it
in two table columns...
Thanks anyway!
JJ
----- Original Message -----
From: Ferguson, Ken <mailto:[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <mailto:'[EMAIL PROTECTED]'>
Sent: Thursday, April 18, 2002 8:49 AM
Subject: RE: Query in 2 columns?
I assume you mean something like this:
<cfquery name="testGroup" datasource="#application.ds#">
Select fname, lname
From users
</cfquery>
<cfoutput query="testGroup" group="fname">
#fname# / <cfoutput group="lName">#lName#</cfoutput><br>
</cfoutput>
Is this what you're getting at, or am I misunderstanding your question?
--Ferg
-----Original Message-----
From: Javier Flores [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 7:35 AM
To: [EMAIL PROTECTED]
Subject: Query in 2 columns?
Hi Everyone!
I would like to know if any of you has an example of a query in two
columns... currrently I have this query output...
-------------------------------
Arte
Ciencia y Educaci�n
Computaci�n e Internet
Deportes
Entretenimiento
Negocios y Economia
Noticias y Medios
Salud y Medicina
Sociedad y Cultura
Viajes y Turismo
-------------------------------
Y want to do this...
------------------------------------------------------------------------
---------------------
Arte / Ciencia y Educaci�n
Computaci�n e Internet / Deportes
Entretenimiento / Negocios y Economia
Noticias y Medios / Salud y Medicina
Sociedad y Cultura / Viajes y Turismo
------------------------------------------------------------------------
---------------------
Any ideas? Any code?
Thanxs for your help...
jjcyber.com
__Javier Flores, Web Site Developer
** 584168-358183
** <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
