Hi. . . hope someone can help. . . (PLEASE BEAR WITH ME -- THIS IS ALL
HIGGLEDYPIGGLEDY) we are having a problem displaying the value of a query
variable. . it seems really confusing, and it is - but unfortunately this is
the simplest way we can think of to do this.
Our goal is to run a query to check and see what proposals (proposalid) have
been submitted, create a table with column for each proposalid that also
contains one row for each of the seven proposal 'readers'. (this part works)
The readers then grade the proposals using an online form. Explanation of what
we are doing is below. . . . BUT HERE IS THE PROBLEM WE ARE HAVING -- the
'readers' are able to log in repeatedly to input their 'grades', change them
etc. . . which means we have to be able to capture the value stored in a given
field. . . ex:
<cfquery name"" datasource""> select proposalcolumn from grades where reader =
currentreader</cfquery>
The problem is that we do not know the name of the column!! and for the life
of us we cannot figure out what variable to set, etc. . which would let us
output this value!!
Each reader reads only ~half of the proposals, as they are divided up by
region. So, once the reader logs into the reader 'grading' section -- we
create a session variable to denote which region they are from. On the
'grading' form page we then use the session variable to get only the columns
for the grading table that correspond to the proposals they were assigned to
read.
ON THE GRADING FORM PAGE WE DO THIS TO GET THE DATA NEEDED TO CREATE THE FORM.
<cfquery name="getproposals" datasource="sotl">
select *
from proposal06
where readinggroup = #session.group#
and status = 1
order by proposalid asc
</cfquery>
<cfset proposals = ''>
<cfoutput query="getproposals">
<cfset proposals = '#listappend(proposals,proposalid)#'>
</cfoutput>
THEN WE LOOP THE PROPOSALS LIST TO QUERY THE GRADES TABLE (PROPOSALID =
GRADES.COLUMNNAME)
<cfloop list="#proposals#" index="i">
<cfquery name="getgrades" datasource="sotl">
select #i#
from grades06
where readerid = #session.readerid#
</cfquery>
THEN WE LOOP THE GETGRADES QUERY TO POPULATE THE GRADING FORM WITH THE
APPROPRIATE PROPOSAL FORM FIELDS
<cfloop list="#getgrades.columnlist#" index="i">
<tr>
<cfoutput> <td><strong>#i#</strong></td>
THEN WE RUN THIS QUERY TO GET THE VALUE OF THE SPECIFIC FIELD (PREVIOUSLY
SUBMITTED GRADE STORED IN THE TABLE
<!---get the grade for this proposal - based on column name from looping
columnlist --->
<cfquery name="getindiv" datasource="sotl">
select #i#
from grades06
where readerid = #session.readerid#
</cfquery>
<td>Accept:
<!--- Should checkbox be pre-checked? --->
!!!!!AND FINALLY -- IF YOU WADED THROUGH ALL OF THIS -- HERE IS THE PROBLEM --
HOW CAN WE REFERENCE THIS FIELD -- EVEN THOUGH WE DON'T KNOW THE FIELD NAME????
-- WE HAVE TRIED EVERYTHING WE CAN THINK OF (admittedly/obviously not that
much) AND CAN'T GET IT TO WORK!!!!!!!!!!!
<cfif #FIELD# is 1>
<CFSET IsChecked = 'Yes'>
<cfelse>
<CFSET IsChecked = 'No'>
</cfif>
<!--- Checkbox itself --->
<cfinput
type="radio"
name="#i#"
checked="#IsChecked#"
value="1"></td>
<td>Reject:
<!--- Should checkbox be pre-checked? --->
<cfif '#column#' eq 0>
<CFSET IsChecked = 'Yes'>
<cfelse>
<CFSET IsChecked = 'No'>
</cfif>
<!--- Checkbox itself --->
<CFINPUT
TYPE="radio"
NAME="#i#"
checked="#IsChecked#"
VALUE="0"> </td>
<td>Maybe:
<!--- Should checkbox be pre-checked? --->
<cfif '#column#' eq ''>
<CFSET IsChecked = 'Yes'>
<cfelse>
<CFSET IsChecked = 'No'>
</cfif>
<!--- Checkbox itself --->
<CFINPUT
TYPE="radio"
NAME="#i#"
checked="#IsChecked#"
VALUE="2"> </td>
<td>Not Yet Graded:
<!--- Should checkbox be pre-checked? --->
<cfif '#column#' eq ''>
<CFSET IsChecked = 'Yes'>
<cfelse>
<CFSET IsChecked = 'No'>
</cfif>
<!--- Checkbox itself --->
<CFINPUT
TYPE="radio"
NAME="#i#"
checked="#IsChecked#"
VALUE="3"> </td></cfoutput>
</tr>
</cfloop></cfloop>
<tr>
Please take pity on us if you can! If you can make sense of this. Thank you.
M
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225571
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
