[Templates] MySQL Quriry Question.

Hi

I am attempting to create a html table of entries from a log table.

The output table will look like
Date Description project 1 project 2 project 3 .... Total time for the day.

Data is stored in the table
Date project name description time

My code looks so far like this. The script fails on passing the date gotten 
from the first query into the second.	
                                WHERE  (project_code = 'ECF_Bill_HH_WO' AND
	                                        startdate = log.start_date) # this 
fails How do I pass the date value from the first query to the second?

[% FOREACH log = DBI.query("SELECT * FROM csc_log_tb
                                   WHERE start_date LIKE '2003-10%'
                                   AND (project_code = 'ECF_Bill_HH_WO' OR
                                            project_code = 'ECF_BeeWork_Bill' 
OR
                                        project_code = 
'ECF_Bill_Maintinance_Equipment' OR
                                        project_code = 'ECF_Pollination_Bill' 
OR
                                        project_code = 
'ECF_Bill_Property_Matinance')
                                   ORDER BY start_date 
                           ")%]    
                        <tr>
   <td>[% log.start_date %]</td>

[% total_day_time = 0 %]
	[% FOREACH item = DBI.query("SELECT * FROM csc_log_tb
	                                WHERE  (project_code = 'ECF_Bill_HH_WO' AND
	                                        startdate = log.start_date)
	                            ")%]    
	    [% total_item_time = total_item_time + item.time %]

	    [% total_day_time = total_day_time + total_item_time %]

	   [% END %]

	   <td>[% total_item_time %]</td>

	    [% total_time = total_time + total_day_time %]
  <td>[% total_day_time %]</td>
   </tr>
   [% END %]

Shanta McBain
http://computersystemconsulting.ca

        -- 
        Thanks
Shanta McBain
Http://computersystemconsulting.ca Web hosting and Application Hosting.

_______________________________________________
templates mailing list
templates@xxxxxxxxxxxxxxxx.xxx
http://lists.template-toolkit.org/mailman/listinfo/templates