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.