Having read the AWS Simple DB documentation once again I've noted there's a maximum limit of 250 items returned items when executing a select query.
Currently for my java swing application for immediate population of my jtable I'm fine with this limit but I need to also select all the entries as part of my application's features whereby the user will prompt the display of all items.
Using a range query I intended on dealing with my challenge as follows:
Step 1: Obtain the latest entries based on the maximum returned results limit.
Step 2: Take content from the last row and 1st column which in my
case is date in the format YYYY:MMD and save this in a variable
Step 3: Add 100 to step 2 above and save this in a variable eg.g
Step 4: Use the values from step 2 and 3 as part of the range query
Below is my current and fully functioning code which fetches the latest items based on the maximum returned results limit of 250