I have a custom table exp_jobs which I am querying. I have used {exp:query} and have also been trying out http://devot-ee.com/add-ons/activerecord ...
Having 1 issue which I think could be solved a few ways. The issue is when you page through the results page 2 I lose the value I am search for. So if I have search form and I do a post I get: http://website.com/jobs?keyword=medical&job_state=AL
Works fine.
Going to page 2 and I the query string is gone, which I expect. I need to be able to alter the paging links however the {pagination_links} pair doesn't work for exp:query even though the docs say:
The pagination in the Query module works exactly like the Channel and Comment Pagination with only one exception. Instead of using a LIMIT clause in your query, use the limit=”“ parameter to specify how many results to display per page, and ExpressionEngine will automatically modify your query to display the appropriate results.
Somehow I need to override the standard pagination to include the query string, any thoughts on how I can do that or plugin I may have overlooked. Tried a bunch.
I also looked at cookies and sessions but not getting consistent results. I may just need to write my own plugin here to handle this if all else fails.
Thank you!
UPDATE: April 20, 2013
I ended up using jQuery to append the URL based on an earlier recommendation from Rob
<script type="text/javascript">
var querystring = '{querystring}';
$('#paging a').each(function()
{
var href = $(this).attr('href');
href += (href.match(/\?/) ? '&' : '?') + querystring;
$(this).attr('href', href);
});
</script>