Friday, November 28, 2003

Since subscribing to CFAUSSIE I have been skimming through the daily digests and today I learned something about MySQL I didn't even realise I could do. I am building a little Flash Remoting app to read in recent news and developments but I don't want the whole table loading in, so I thought I would use the Dreamweaver code to set the minimum and maximum rows as I have done with my .cfm pages, however this didn't work and that is when I remembered something I had read on CFAUSSIE! I never knew you could use 'LIMIT 1,10' in your SQL statement to read in 10 records starting at position 1! Perfect, cheers Ryan Sabir for pointing that out.

Jon 11:14 AM Permalink