Query help

MySQL has a TON of date/time functions that will allow you to get the month from a date and use it in an expression.

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

For example, if your column is "date", you could do a query like so:

<cfquery name="qmonths" datasource"...">

     select jid,date,...

     from tbl_jobs

     where month(date) = '5'

</cfquery>

The following would be equivalent, if you felt more like using the actual month name (not sure why, but kinda cool):

<cfquery name="qmonths" datasource"...">

     select  jid,date,...

     from tbl_jobs

     where monthname(date) = 'May'

</cfquery>

Of course, there are lot of different ways to achieve the same thing, so be sure to look through the array of functions that mySQL offers.

Regards