He's an idiot. The first row is 1. CF counts everything from 1. Note arrays in CF start at 1, while in most other languages I've encountered, they start at 0.
> I was looking up some stuff on joins versus unions, and came across an > opinion that used CFQUERY as an example. (I won't post the url since I > don't know if it's kosher here.) > > However, under this person's tutorial topic called "Limiting > Results" it > used this code: > > <CFQUERY DATASOURCE = "Friends" Name = "Query1" Maxrows = > "10" Startrow > = "0"> > > followed by the comment: > > "Note that the starting row is set at 0. Remember that computers start > numbering at 0, not 1. > So the first record in the database is record number 0." > > ------- > > Now, I understand offsets, et cetera, but I've never heard it used > regarding cfquery (or any other sql query for that matter -- > I couldn't > even find another mention of startrow=0 anywhere in google or > altavista for any major sql platform...). > > And obviously, I've never had a problem with using startrow=1 missing > the first record of a query return set. > > Has anyone else ever used startrow=0 in *any* sql platform, is it > practical/standardized, or is this guy just telling people to > do things > the > way he thinks they should be? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
