On Nov 3, 2005, at 3:22 PM, Emmet McGovern wrote: > I thought you were dead!!! ;)
Um... That was an unexpected response. No. Not dead. Just away... fighting evil in another dimension. Etc. :) More seriously, true, I have been out of the scene for a while. About a year. However about a month or so ago my (new) wife (and I) decided it would be nice to be able to work together at home ... Etc. So... .... Among other things, I've been rebuilding the old intrafoundation.com website this last week. Just uploaded the very newest, freshly packed, viri-scanned versions of several old CFXs and COMs (i.e. tcpclient, IHK, etc.) All available, as per usual, free of charge. [True side-note: with I think it was 3 hours or so after I put intrafoundation I get 2 unsolicited pleas for copies of tcpclient. Now the site hasn't been up in months remember. Jeez.] Anyway, if your next statement to me was to try to hit me up for a spare copy of tcpclient or something.... :-P --min > > -----Original Message----- > From: Lewis Sellers [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 03, 2005 3:13 PM > To: CF-Talk > Subject: Re: "Limit" or "Top" and mySQL Question > > I believe you've answered yourself in your subject. It's called LIMIT > in mysql, and it's slightly more flexible than using TOP. > > > SELECT Airdates.ShowID FROM shows LIMIT 30; > > shows only the first 30 records returned from the query. > > > SELECT Airdates.ShowID FROM shows LIMIT 10,30; > > shows records 10 through 40. > > > --min > http://www.intrafoundation.com > > >> Using a mySQL Database with thousands of records. >> For the query below, >> to optimize performance, I'd like to be able to >> return on the TOP N records. >> >> A. "SELECT TOP 50" doesn't work in mySQL. "Top" is >> only SQL >> Server, correct? >> B. "From Shows Limit 50" returns an error as well. >> >> 1. What's the equal of "TOP" in mySQL? >> 2. At what point in the query is that actually >> evaluated? >> I don't want the first 50 records, I want the >> first >> TOP records out of all of them according to the >> sort. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223091 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
