...I will check to see what quarter the entered month and year falls into. If the month and year falls in the first quarter(1 Oct-31 Dec.) pull all the idle days values out of the database for that quarter...
But what is your question? I don't know whether you're asking how to tell which quarter a date falls into, or whether you're asking about database connectivity.
"We're kind of on the level of crossword puzzle writers... And no one ever goes to them and gives them an award." ~Joe Strummer sscce.org
Start as small as you can manage. Isolate this little part of your program into a new class called Quarter - maybe temporarily, maybe forever. Can you make this work? Put it in the main() of a throw-away test class. Let's give it a month (0-11 like Date) and ask what quarter it's in (0-3)
Show us what you make for that!
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
roses are red, violets are blue. Some poems rhyme and some are a tiny ad: