Let's just say that I'm fundamentally lazy when it comes to writing emails, especially long ones (just ask my friends in Hungary). So I basically wouldn't have borthered writing if it wasn't *that* good. I can't really think of anything negative about the whole thing. OK, there were a couple of snooze moments. One Flash preso was really way over my head and although I did catch a few useful tidbits (mainly cool applications for Flash like realtime collaborative editing), by the end I was reading Slashdot over the wireless link. The other thing was Fusebox -- the methodology part I was already familiar with, and I still found the actual standard somewhat restrictive. That, and we already have our own in-house implementation based on FB2 heavily extended so again I found myself reading CFAussie instead.
Talking about the wireless link, it was great if you brought your laptop (and wireless card) along. It was great for looking up URLs the presenter was talking about, checking email (just in case some disaster happened at work), and well, reading Slashdot and CFAussie when things got boring ;)
I understand where you're coming from with the money situation. Work did pay for my ticket. Has this not been the case I woldn't have gone either. I have imagined MXDU to be like the MX product launch and wasn't all that excited about it initally. But this really was an 'user event' and also having a separate CF and Flash threads meant that I didn't have to suffer through several high level Flash or Dreamweaver presentations that I understood little about -- or cared little about in case of Dreamweaver.
So anyway, it was good, it was worth it, and next year I'd be willing to pay for it myself if I had to. At least this is my opinion but it seems that other CFAussies were saying similar things as well.
----
About that code... I realised that I've overlooked something. The second query should be sorted DESC so it would return the 20 records you want rather than the first 20. Then you could either reverse it with a query of queries or loop through it backwards like:
<cfloop index="i" from="#Query.RecordCount# to="1" step="-1">
Cheers Vik
Ron Ziemiecki wrote:
Thanks Vik, I will try that code and see if it works, after reading
through it quickly the first time it would seem to make sense to me.
I would also like to thank you for your summation of the recent MXDU.
I could not possibly attend because I am a single lone designer, and
that amount of money (yes I know it was cheap in relation to going to
the States etc.) would feed my family for 3 months :-)
However I read your entire spin on it and don't think you were Spin
Doctoring it, I believe you simply stated it the way it was and in that
respect as non-goer, I would like to thank you because I know have a
sense of what I missed.
Ron...
/-------Original Message-------/
/*From:*/ CFAussie Mailing List <mailto:[EMAIL PROTECTED]>
/*Date:*/ Saturday, February 22, 2003 11:08:14 PM
/*To:*/ CFAussie Mailing List <mailto:[EMAIL PROTECTED]>
/*Subject:*/ [cfaussie] Re: Logic help
Hi Ron,
I've seen you have solved the problem, but I've figured a way to optimise your query (ie not having to retreive everything every time):
Set two variables, form.first_athlete_name and form.last_athlete_name. They should be in the format "smith john"
Then you'd use this sql for pulling the next 20:
<cfquery name="BODYBUILDING" datasource="#db_datasource#" username="#db_username#" maxrows="20"> select * FROM athlete WHERE athlete_sport = 'BODY BUILDING' AND athlete_surname + ' ' + athlete_firstname > <cfqueryparam name="#form.last_athlete_name# cfsqltype="cf_sql_varchar"> order by athlete_surname ASC </cfquery>
And this one for the previous 20:
<cfquery name="BODYBUILDING" datasource="#db_datasource#" username="#db_username#" maxrows="20"> select * FROM athlete WHERE athlete_sport = 'BODY BUILDING' AND athlete_surname + ' ' + athlete_firstname < <cfqueryparam name="#form.first_athlete_name# cfsqltype="cf_sql_varchar"> order by athlete_surname ASC </cfquery>
I haven't tested this one but once you fix up the syntax it should work (unless I've overlooked something)... well, it's worth a try anyway. The only bug in it is if you have two athletes with identical first *and* last name, and they happen to be the n*20th and n*20 + 1th record then one of them will be skipped (I think).
Hope you still find this code useful...
Cheers, Vik
Ron Ziemiecki wrote: > You are a legend Phil, thanks, its working perfectly now, go make > yourself a coffee and stretch your legs :-) > > Ron... > > startat will either need to be a session variable, or passed as a URL > parameter. > e.g. > <cflock...> > <cfset session.startat = 1> > </cflock> > ... >
____________________________________________________
<http://www.incredimail.com/redir.asp?ad_id=309&lang=9> /IncrediMail/ - *Email has finally evolved* - *_Click Here_* <http://www.incredimail.com/redir.asp?ad_id=309&lang=9>
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
