@Christophe - I don't know if it wold be faster to load ten rows at a
time into some XML and then display each pair of nodes one at a time
or to just fetch each record from MySQL on every instance (XML is
pretty cludgy, and MySQL is pretty fast). At this point I would just
like to make it work, whether I put ten rows into XML or JSON or
fetched each row from MySQL.
@Gareth - I am very familiar with the LIMIT parameter in MySQL and
would prefer this technique, but I don't know how to keep track of the
last record retrieved so that I can increment the counter and then
retrieve the following record when the link/button is clicked again.
Here is my query (in ColdFusion):
<cfquery name="getTestimony" datasource="berrettdb">
SELECT id, content, name
FROM testimony LIMIT #url.count#, 1;
</cfquery>
<cfoutput><p>#qTestimony.content#</p><cite>#qTestiomony.name#</cite></cfoutput>
What that does is get the record starting at the number passed in and
limiting it to just that one record. Then I output that one record's
content in paragraph tags and the name in cite tags. When this is
returned, it will replace everything between <blockquote
id="testimony"></blockquote>.
I also have a query that returns the total number of records in the
table. Here it is in ColdFusion:
<cfquery name="getTestimonies" datasource="berrettdb">
SELECT id
FROM testimony
</cfquery>
Before I output the content from the table record I can check if the
number passed in is greater than (using GT in ColdFusion) the record
count. If it is, I can set the count variable back to one so that the
first testimony record will be output again (effectively rotating
through the testimonies instead of displaying a previous and next link
and worrying about hiding one or the other if we are at the first or
last record). Here is how that is done:
<cfif url.count GT getTestimonies.recordCount>
url.count = 1
</cfif>
THE ONLY PROBLEM is that I don't know how to pass number of count back
to the calling page with a value of count + 1 and then take that and
pass it back to my getData page so I can get the next record when the
link is clicked again. How do I "maintain state" between my getData
page and my view page?
@Maninder - I have poured over that article on particletree.com and I
cannot seem to parse it all out and apply the principles to my
situation.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Spinoffs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-spinoffs?hl=en
-~----------~----~----~----~------~----~------~--~---
