How can I display all records as a end user?

Question

I am applying for jobs with the state and every week they publish a list of new positions that have just been posted on the following link: https://forms.spb.ca.gov/bulletins/weekly.cfm

and also at http://jobs.spb.ca.gov/wvpos/search_p_ejv.cfm?classcode=5393&criteria=associate%20governmental

It is a .cfm but only displays 15 records at a time, I was wondering if there is a tag or way to have it display all 300 something records at once? My ultimate goal is to get just the full table into a excel spreadsheet while retaining the HTML formatting so the links still work.

My thought is that the state has set it up this way to only display a set number of records at a time, the data is not private or protected, I am simply seeking a easier way to access it in aggregate.

Thank you in advance for your suggestions and help!

tribule · Answer

If you control the .cfm i.e. can edit it, you need need to use startrow and maxrows in your <cfquery> to utilise pagination and control how many records are displayed at once e.g. <cfoutput query="getData" startrow="10" maxrows="20">. If you want to display all records at once, remove the startrow and maxrows from the <cfquery>.

If you don't have access to the .cfm template you will have to ask the person who authored it to see if it supports any parameters to allow it to display all records (or try and guess them :).

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded