<% 'toxictracker.asp?db=cfia or 'toxictracker.asp?db=tds db=request.querystring("db") if db="" then db="cfia" end if dim FoodCategoryTbl dim FoodItemTbl dim toxinCategoryTbl dim toxinItemTbl dim toxinTbl if db="cfia" then FoodCategoryTbl="CFIAFoodCategory" FoodItemTbl="CFIAFoodItems" toxinCategoryTbl="CFIAToxinCategory" toxinItemTbl="CFIAToxins" toxinTbl="CFIA" else FoodCategoryTbl="TDSFoodCategory" FoodItemTbl="TDSFoodItems" toxinCategoryTbl="TDSToxinCategory" toxinItemTbl="TDSToxins" toxinTbl="TDS" end if 'connect to the database Set conn = Server.CreateObject("ADODB.Connection") conn.open "Driver={Microsoft Access Driver (*.mdb)};dbq=" & _ Server.MapPath("food.mdb") mySql = "SELECT FoodCatCode, FoodCatName FROM " & FoodCategoryTbl & " ORDER BY FoodCatName " set rsFoodCategory=Server.CreateObject("ADODB.recordset") rsFoodCategory.Open mySQL,conn,3 Response.Write "" & vbNewLine %> Toxic Tracker - Search the Canadian Food Inspection Agency data And Total Diet Study data
<% if db="cfia" then %>

Search the Canadian Food Inspection Agency data

The Canadian Food Inspection Agency is responsible for testing food before it reaches store shelves, and enforcing Canada's food safety laws. The Toxic Tracker allows you to search the results of the CFIA's testing. The CFIA data is not statistically representative of Canada's food supply, but it does act as an indicator of what sorts of substances are entering our food.

Read more about the CFIA.

The more specific you make your search, the faster your results will be generated.

<% else %>

Search the Total Diet Study data

Health Canada's Total Diet Study program monitors contamination in food that is offered for sale on grocery store shelves. It uses this information to calculate average daily exposures to food borne toxic contamination. The data is averaged based on foods collected from several cities over several years, and does not represent individual test results. The Toxic Tracker allows you to search the average values of contamination in a variety of foods tested by the TDS program.

Read more about the Total Diet Study Program.

The more specific your search, the faster the results will be generated.

<% end if %>
Food Category:
Food Type:
Contaminant Category:
Contaminant: