Solved

starting an ordered list at something besides 1 inside a cfoutput

Posted on 2003-11-05
6
240 Views
Last Modified: 2013-12-24
if i do the below ordered list, it creates an ordered list starting with 1.

*********
<ol>
<cfoutput query="qname" startrow="41" maxrows="60">
<li><font face="arial" size="2">#firstname# from #city#, #state#</font></li>
</cfoutput>
</ol>
*********

i.e.

1. steve from Denver, CO
2. lisa from tampa, FL
3. joe from nashville, TN
.
.
.

how do i get it to start at 41?

i.e.

41. steve from Denver, CO
42. lisa from tampa, FL
43. joe from nashville, TN
.
.
.
 

0
Comment
Question by:sagardeo
6 Comments
 

Author Comment

by:sagardeo
ID: 9690042
oh wait, looks like <ol..> tag has a start attribute. i should use this right?

<ol start=5.....>
0
 

Author Comment

by:sagardeo
ID: 9690048
or in my case

*********
<ol start=41>
<cfoutput query="qname" startrow="41" maxrows="60">
<li><font face="arial" size="2">#firstname# from #city#, #state#</font></li>
</cfoutput>
</ol>
*********
??
0
 
LVL 14

Assisted Solution

by:Renante Entera
Renante Entera earned 125 total points
ID: 9691118
You can also have it this way :

<ol>
<cfoutput>
<cfloop query="qname" startrow=41 endrow=60>
<!--- You may assign any number for your parameter "endrow" --->
<li><font face="arial" size="2">#firstname# from #city#, #state#</font></li>
</cfloop>
</cfoutput>
</ol>

Actually, your code should work.  I am referring to the code you posted on your question not on your comments.

Goodluck!
eNTRANCE2002 :-)
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 1

Expert Comment

by:Wasistdas
ID: 9691260
or use #currentrow# along with that cfloop
0
 
LVL 1

Accepted Solution

by:
Wasistdas earned 250 total points
ID: 9691275
Well, to be more precise: Better use the following code instead of <ol><li>:

<cfouput query="qname" startrow="41" maxrows="60">

#currentrow#. <font face="arial" size="2">#firstname# from #city#, #state#</font><br>

</cfoutput>
0
 
LVL 12

Assisted Solution

by:jyokum
jyokum earned 125 total points
ID: 9691791
i think you answered your own question. this seems to work fine.

<cfquery name="qryData" datasource="whatever">
SELECT * FROM table1
</cfquery>

<cfset myStart=41>
<cfset myRowcount=60>

<cfoutput>
<ol start="#myStart#">
</cfoutput>
<cfoutput query="qryData" startrow="#myStart#" maxrows="#myRowcount#">
<li>#qryData.columnA# #qryData.columnB#</li>
</cfoutput>
</ol>
0

Featured Post

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 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