8 : SELECT weekdate, deadline, weeknumber FROM dypweek
9 : WHERE weekdate = <cfqueryparam value="#now()#" cfsqltype="CF_SQL_DATE" />
10 : AND CONTEST_ID = <cfqueryparam value="#CONTEST_ID#" />
11 : </CFQUERY>
12 : <CFSET wknum=#NumberFormat(GetWeek.weeknumber)#>
|