<cfinclude template="header.cfm">
<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>
     
<cfif ParameterExists(form.answer)>
<CFQUERY NAME="Insert" datasource="mcifawb">
  INSERT INTO PollAnswers (Answer, QID, CurrentDateTime)
  VALUES ('#Form.answer#',#form.qid#,#CurrentDateTime#)
</CFQUERY>
</cfif>

<cfquery name="getquestion" datasource="mcifawb" maxrows="1">
select *
from PollQuestions
order by id desc
limit 1
</cfquery>

<cfquery name="GetAnswers" datasource="mcifawb">
SELECT PollAnswers.Answer, Count(PollAnswers.Answer) AS CountOfAnswer, PollAnswers.QID
FROM PollAnswers
GROUP BY PollAnswers.Answer, PollAnswers.QID

</cfquery>

<cfquery dbtype = "query" name = "GetAnswers2" > 
  SELECT *
  FROM GetAnswers
  WHERE qid = 10
  </cfquery>

<table width=590 cellpadding=5 cellspacing=5><tr><td>
<center><span class="PurpleHeadline">MCIFA Poll Results<br></span></center>
<font face=arial size=-1>

<cfgraph
type="horizontalbar"
Query="GetAnswers2"
ValueColumn="CountofAnswer"
ItemColumn="Answer"
FileFormat="flash"
itemlabelsize="12" 
Title="#getquestion.question#"
Borderwidth="1"
Bordercolor="Black"
depth="20"
graphwidth=590
graphheight=300>
</cfgraph>



</query>
<cfoutput>
<center>
<br>
#DateFormat(Now(),"dddd, mmmm d,")#
#TimeFormat(Now(), 'hh:mm:ss tt')#
</cfoutput>
<p>
</center>
</div>
</center>
<cfoutput query="getquestion" maxrows="1">
<font size="+1"><b>#Question#</b></font>
<p>
<br></div></center>
<align=left><cfif #AnswerA# is not ""><li><strong>A</strong> - #AnswerA#<Br></cfif>
<cfif #AnswerB# is not ""><li><strong>B</strong> - #AnswerB#<Br></cfif>
<cfif #AnswerC# is not ""><li><strong>C</strong> - #AnswerC#<Br></cfif>
<cfif #AnswerD# is not ""><li><strong>D</strong> - #AnswerD#<Br></cfif>
<cfif #AnswerE# is not ""><li><strong>E</strong> - #AnswerE#<Br></cfif>
<cfif #AnswerF# is not ""><li><strong>F</strong> - #AnswerF#<Br></cfif>
<cfif #AnswerG# is not ""><li><strong>G</strong> - #AnswerG#<Br></cfif>
<cfif #AnswerH# is not ""><li><strong>H</strong> - #AnswerH#<Br></cfif>
<cfif #AnswerI# is not ""><li><strong>I</strong> - #AnswerI#<Br></cfif>
<cfif #AnswerJ# is not ""><li><strong>J</strong> - #AnswerJ#<Br></cfif>
</cfoutput></td></tr></table><cfinclude template="footer.cfm">