Re: Formatting date extracted from DB

["jbird5k"]

Dan

 its a lot of code because it shows three options that I have tried.
 This option works best, but the table tags do not get repeated after the first 
row.

 <cfset row_count = row_count + 1>

 <cfquery name="getQ75Response" datasource="#application.insp#">
 select *
 from response_tbl
 Where inspection_id = #session.inspection# and questionaire_id = 75 and 
item_id = #getQ75Items.item_id#
 </cfquery> 
  <cfoutput >

 <tr >
 <td><cfloop query="getQ75Response"><cfif question_id IS 1196 
>#response#</cfif></cfloop></td>
 <td> <cfloop query="getQ75Response"> <cfif question_id IS 1197 
>#response#</cfif></cfloop></td>
 <td> <cfloop query="getQ75Response"> <cfif question_id IS 
1198>#response#</cfif></cfloop></td>
 <td><cfloop query="getQ75Response"><cfif question_id IS 1200>#response#</cfif> 
</cfloop></td>
 <td> <cfloop query="getQ75Response"><cfif question_id IS 
1201>#response#</cfif></cfloop></td>
 <td> <cfloop query="getQ75Response"><cfif question_id IS 
1202>#response#</cfif></cfloop></td>
 <td> <cfloop query="getQ75Response"><cfif question_id IS 
1554>#response#</cfif></cfloop></td>
 <td> <cfloop query="getQ75Response"><cfif question_id IS 
1555>#response#</cfif> </cfloop> </td>
 </tr>


 </cfoutput> --->
 </table>



 I am not able to redesign the db at this time, I inherited this project with 
just the reporting piece left to complete. and I don't believe extracting data 
to a narative report with display tables  was discussed.

  The response table looks like this:

 response_id, inspection_id, questionnaire_id, question_id, response,  case_id, 
locked, user_id,people_id, question_comment, item_id,item, and manager_response

 I have elimated the Items query, 

 I still have the problem of the table tags not repeating  

 thanks for your input Dan