I couldn't agree more, however the solution I posed was to display two separate records side-by-side.
-----Original Message----- From: Ferguson, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:15 AM To: '[EMAIL PROTECTED]' Subject: RE: Query in 2 columns? Whoa man, simplify. There's no need for all that. Just use the group attribute of the cfoutput tag, as in my last reply. It should work perfectly for you. Ferg -----Original Message----- From: Jeff Lucido [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:08 AM To: [EMAIL PROTECTED] Subject: RE: Query in 2 columns? 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 ------------------------------------------------------------------------ - 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 ------------------------------------------------------------------------- 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
