<cfif isDefined("FORM.submitMVP")>
<cfloop index="aRow" from="1" to="#val(form.MVPID)#">
<cfquery name="enterdetails" datasource="#datasource#">
INSERT INTO leadervotes (leaderid, voteid, votedate, mvp_ast, votelevel)
VALUES
(
<cfqueryparam value="#form.SessionID#" cfsqltype="cf_sql_varchar"> ,
<cfqueryparam value="#form.MVPID#" cfsqltype="cf_sql_varchar"> ,
<cfqueryparam value="#form.mvpdate#" cfsqltype="CF_SQL_varchar"> ,
<cfqueryparam value="#form.mvp_ast#" cfsqltype="cf_sql_int"> ,
<cfqueryparam value="#form.votelevelMVP#" cfsqltype="cf_sql_int">
)
</cfquery>
</cfloop>
<cfform action="vote.cfm" method="post" format="html">
<tr>
<cfinput type="hidden" name="SessionID" value="#Session.ID#">
<cfinput type="hidden" name="mvpdate" value="#DateFormat(DateAdd('m', -1, MyDateTime),'YYYYMMDD')#">
<cfinput type="hidden" name="mvp_ast" value="1">
<td align="center"><strong><cfoutput>#DateFormat(DateAdd('m', -1, MyDateTime),'mmmm')#</cfoutput></strong></td>
<cfoutput query="getNominated">
<cfinput type="hidden" name="MVPID" value="#MVPID#">
<tr>
<td> #VoterFirstName#<br /> #VoterLastName#</td>
<td width="60%"><strong>#MVPFirstName#</strong> <strong>#MVPLastName# #MVPID#</strong><br />
#mvpreason#</td>
<td>1
<input type="radio" name="votelevelMVP" value="1" />
2
<input type="radio" name="votelevelMVP" value="2" />
3
<input type="radio" name="votelevelMVP" value="3" /> <input type="submit" name="submitMVP" value="Vote"></td>
</tr>
<!--SEPARATOR ROW USED DIFFERENT STYLE-->
<tr>
<td colspan="3"></td>
</tr>
</cfoutput>
</cfform>
ASKER
ASKER
ASKER
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY
ie
<cfoutput query="getNominated">
<!--- BEGIN RECORD FORM --->
<!--- generate one form per record --->
<cfform action="vote.cfm" method="post" format="html">
<cfinput type="hidden" name="SessionID" value="#Session.ID#">
<cfinput type="hidden" name="mvpdate" value="#DateFormat(DateAdd
<cfinput type="hidden" name="mvp_ast" value="1">
.... etc ....
</cfform>
<!--- END RECORD FORM --->
</cfoutput>