Ok I gotcha!! Now that you mention it, it does look like he might be trying to do just that. I sometimes just get frustrated seeing people do things the hard way. I'm going on 19 hours straight this morning trying to fix an application in which everything was done the hard way! I should have paid more attention to what you were actually saying.
I don't seem wound up this AM do I? :) -----Original Message----- From: Jeff Lucido [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:16 AM To: [EMAIL PROTECTED] Subject: RE: Query in 2 columns? 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 ------------------------------------------------------------------------- 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
