Variable within Variable Name

["semi star gazer"]

Hello~

 I have a page that brings in a form value from the previous page (a number 
from 1-20), and I have that value set as the variable "week." I am using that 
variable as part of a query (which works) and to call a certain variable name 
(which does not). I don't know how to layer the # symbols, etc., to make the 
variable name correct. Please help!

 -----Query-------
 <cfif isDefined('form.submit')>

 <cfset week = form.journalsDatestamps>

 <cfquery name="journalsDatestamp" datasource="intern">
        SELECT
                request.ID, request.FirstName, request.LastName, request.sem, 
request.year, 
request.banner, journals.ID, journals.journal#week#, journals.time#week#
        FROM
                request, journals
        WHERE
                request.ID = journals.ID AND request.sem = 'Fall' AND 
request.year = '2007'
        ORDER BY
                request.LastName, request.FirstName
 </cfquery>

 </cfif>

 ----------------------------------------------------

 Trying to output variable:

 <cfoutput>
   <cfloop query="journalsDatestamp">
   <tr>
     <td>#ID#</td>
     <td>#banner#</td>
     <td>#LastName#, #FirstName#</td>
        <td>#journal#week##</td>
     <td>#time#week##</td>
   </tr>
   </cfloop>
   </cfoutput>