Solved

Cold Fusion Query Output Problem!

Posted on 2011-02-17
15
308 Views
Last Modified: 2012-05-11
dear Experts,

i want my query after to records it should come in second TR you can see picture i attached  how i want  my query should show my records

<cfoutput query="getMoreRecords">
                  <cfif i EQ 3 or i EQ 1>
                  	<tr>
                   </cfif>

                       <td width="43%" class="Inner_FooterLinks">
                         <a href="##">Namiba's Sink Hole</a>
                        </td>

                  <cfif i EQ 2 >
                   	</tr>
		<cfset i = 1 >
                     <cfelse>
                    <cfset i = ++i >
                  </cfif>
 </cfoutput>

Open in new window

table-lookLike.jpg
0
Comment
Question by:onlyamir007
  • 7
  • 5
  • 3
15 Comments
 
LVL 19

Expert Comment

by:erikTsomik
Comment Utility
can you try something like this
<cfset i = 0>
<cfoutput query="getMoreRecords">
<cfset i++>
<cfif i EQ 4 or i EQ 1>
        <tr>
</cfif>
      
            <td width="43%" class="Inner_FooterLinks">
            <a href="##">Namiba's Sink Hole</a>
         </td>
      
        <cfif i eq 4>
            </tr>
      </cfif>


           
 </cfoutput>


0
 
LVL 52

Expert Comment

by:_agx_
Comment Utility
Since every link is the same , I'm not sure I understand the desired results.  But I'll take a guess ...


If you want to display the results in 3 columns, use MOD

<table>
<tr>
<cfoutput query="getMoreRecords">
	<td width="43%" class="Inner_FooterLinks">
    	<a href="##">#SomeColumn#</a>
	</td>
	<cfif currentRow mod 3 eq 0>
		</tr><tr>
	</cfif>
 </cfoutput>
</tr>
</table>

Open in new window

0
 
LVL 4

Author Comment

by:onlyamir007
Comment Utility
dear Aqx,

after applying ur code output coming something like this u can see attached pic and please have a look HTML OUT Putt
<table width="74%" border="0" cellspacing="2" cellpadding="2">
                
				                 
             
              <tr>
 
	<td  class="Inner_FooterLinks">
    	<a href="innerPage.cfm?contentid=18">Need For Speed</a>
	</td>
	
 
	<td  class="Inner_FooterLinks">
    	<a href="innerPage.cfm?contentid=19">Ray Feeding</a>
	</td>
	
 
	<td  class="Inner_FooterLinks">
    	<a href="innerPage.cfm?contentid=20">Off-Roading with AD4x4.com</a>
	</td>
	
		</tr><tr>
	
 
</tr>  
                 <!--  -->
                 
                 
                 
                 
               </table>

Open in new window

table-lookLike.jpg
0
 
LVL 4

Author Comment

by:onlyamir007
Comment Utility
dear erikTsomik:

please have a look when im running ur code this is HTML OUTPUT please have look output picture aswell
<table width="74%" border="0" cellspacing="2" cellpadding="2">
                
				                 
             
 
 
 
 
 
 
        <tr>
 
      
            <td width="43%" class="Inner_FooterLinks">
            <a href="#">Namiba's Sink Hole</a>
         </td>
      
        
 
 
            
 
 
 
      
            <td width="43%" class="Inner_FooterLinks">
            <a href="#">Namiba's Sink Hole</a>
         </td>
      
        
 
 
            
 
 
 
      
            <td width="43%" class="Inner_FooterLinks">
            <a href="#">Namiba's Sink Hole</a>
         </td>
      
        
 
 
            
 
 
 
                 <!--  -->
                 
                 
                 
                 
               </table>

Open in new window

table-lookLike.jpg
0
 
LVL 52

Expert Comment

by:_agx_
Comment Utility
>> dear Aqx,  after applying ur code output coming something like this u can see attached pic

@onlyamir007

Ok, I see the image. But I still don't understand your goal.  

Can you explain how it's different from what you want? ie What is it doing wrong?
0
 
LVL 52

Expert Comment

by:_agx_
Comment Utility
All of the values in your original example are the same:  "Namiba's Sink Hole".   That makes it hard to understand what your'e trying to do.

Can you use different values like:

ie          
SomeColumn
===========
apple
orange
pear
grape
banana
kiwi

... THEN show how you want the output to look

Example:
row 1 |   apple    |   orange |    pear |
row 2 |   grape    |  banana |    kiwi  |

Open in new window


0
 
LVL 4

Author Comment

by:onlyamir007
Comment Utility
Dear _agx_

what i want to do  you can see HTML Code
----------------------------------------------------------------------------------
<table width="33%" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td width="48%">Record 1</td>
    <td width="52%">Record 4</td>
  </tr>
  <tr>
    <td>Record 2</td>
    <td>Record 5</td>
  </tr>
</table>
<table width="33%" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td width="48%">Record 1</td>
    <td width="52%">Record 4</td>
  </tr>
  <tr>
    <td>Record 2</td>
    <td>Record 5</td>
  </tr>
</table>

Open in new window

0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 19

Expert Comment

by:erikTsomik
Comment Utility
maybe you can order the query such a way so you would not have to change the code
0
 
LVL 4

Author Comment

by:onlyamir007
Comment Utility
<table width="33%" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td width="48%">Row 1</td>
    <td width="52%">Row 3</td>
  </tr>
  <tr>
    <td>Row 2</td>
    <td>Row 4</td>
  </tr>
</table> 

Open in new window

0
 
LVL 4

Author Comment

by:onlyamir007
Comment Utility
this is not the case of ordering  the query this is just how can i show my records in 2nd col after 2nd row u can see HTML how i want to show my records
               
                 
0
 
LVL 19

Expert Comment

by:erikTsomik
Comment Utility
you can do it this way. Usea queryNew  to create a static query in the needed order and then simply output
0
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
Comment Utility
Oh, I see.  You want to display the values down - then across. That is a little more involved than MOD but doable.

... 
<cfset numOfCols = 2>
<cfset offset = ceiling( getMoreRecords.recordCount / numOfCols )>

<cfoutput>
<table>
<cfloop from="1" to="#offset#" index="col">
<cfset secondCol = col + offset>
<tr>
	<td>#getMoreRecords.SomeColumnName[col]#</td>
	<td><cfif secondCol lte getMoreRecords.recordCount>
			#getMoreRecords.SomeColumnName[secondCol]#
		</cfif>
	</td>
</tr>
</cfloop>
</table>
</cfoutput>

Open in new window

0
 
LVL 4

Author Comment

by:onlyamir007
Comment Utility
ohh dear thank you very much it is working fine but only one problem when  records are exceeding 4 it should come other Colum for example
 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>Record 1</td>
    <td>Record 3</td>
    <td>Record 5</td>
  </tr>
  <tr>
    <td>Record 2</td>
    <td>Record 4</td>
    <td>Record 6</td>
  </tr>
  </table>

Open in new window

0
 
LVL 4

Author Closing Comment

by:onlyamir007
Comment Utility
Thanks
0
 
LVL 52

Expert Comment

by:_agx_
Comment Utility
@onlyamir007 -

You keep changing the requirements. First it was 3 columns, then 2 (down and across) . Now it's seems like something very different.  Which is it?  ;-)

0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

What is Node.js? Node.js is a server side scripting language much like PHP or ASP but is used to implement the complete package of HTTP webserver and application framework. The difference is that Node.js’s execution engine is asynchronous and event…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now