Drop down list doesn't display selected value Hi there,
I have a problem. This page output from the query result.
There is 2 fields need to be updated:scholarshipID and amount. I
want to update my query at once. My dynamic drop down list doesn't
display selected value. The value is there but doesn't recognize it
in the drop down list. I couldn't find the error. My code is below,
so please help....
<cfquery name="getStudentsData"
datasource="#application.DSN#">
select StudentID, fname, lname, GPA, Tbl_Students.ID,
ScholarshipID, amount, Tbl_StudentsScholar.ID as SSID, AwardStatus
from Tbl_Students, Tbl_ApplyYear, Tbl_EduBckgrnd,
Tbl_StudentsScholar
where Tbl_Students.ApplyYr = Tbl_ApplyYear.id
and Tbl_Students.id = Tbl_EduBckgrnd.SID
and Tbl_Students.ID = Tbl_StudentsScholar.SID
and ApplyYear = 1
and steps = 7
order by studentid
</cfquery>
<cfquery name="getScholarship"
datasource="#application.DSN#">
select AcctNum, scholarship, Tbl_Scholarships.id, Code
from Tbl_Scholarships, Tbl_DistCode
where T
AdChoices