CFQUERY and STARTROW=0 (??!)
Hi all, 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: 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? Inquiring minds (at least one) want to know... Tom ~| 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
Subject: MM will OWN my Devex Submissions?
Jeez, I wasn't going to post anything regarding all the MM site changes
because there was so much traffic here about it, but I logged into the
CF DevEx and found that a few of my submissions were missing.
So, I went a step further to see what the new submission areas looked
like, and there was the following in the submission agreement:
(d) Commercial Submission Only: With respect to the Commercial
Submission only, You hereby grant Macromedia a perpetual, irrevocable,
royalty-free and worldwide license to use, test, copy, modify, create
derivative works of, publicly display, publicly perform or demonstrate
the Submission, and/or place a link to a website in connection with such
Submission.
Non-commercial Submission was very similar, if not the same (my eyes
bugged out, I can't remember now 8-).
I don't remember this before, but this sounds strikingly like the stuff
that MS pulled when they were pushing a centralized storage
product/service.
Am I reading it wrong, or doesn't this say that I would be giving them
licensed ownership ("create derivative works of") whatever product or
tag I might submit?
Please, please correct me and tell me I am reading it wrong.
Tom
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Which is faster: neq '' or len(#v#)?
I know we've determined that is faster than , etc., but is slower than ? Tom -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
