Hi everyone,
Im Reyn, i just want to ask for help. We are making now a project using coldfusion but we are having a problem. Can someone help me on how to compute the final grade.
The situation is, a student has grades from first grading to fourth grading and i want to get the final average out of it. Plz help me on this....
Thanks....
Hi Reyn,
i would like to know the name of the table and the names that you use to represent the individual grades (column names) in that table.
if you give me this i probably can give you the code to get your thing done
Ramesh
Thanks Ramesh
Anyway, we have only one table to compute the grades,tbl_grade which ahs stuent_id, 1stgrading, 2nd grading, 3rdgrading, 4thgrading and the finalgrade.
We already tried to put the formula in the finalgrade column in database, yah it really work in SQL,but it doesn't work if we apply in coldfusion. We can input the grades of the students in one section because it has multiple textbox.
I hope you can help me.... Please....please....please....
Thanks...
Reyn
I want to use cfform's 'required' attribute to disable blank entries on some of the fields on my form but blank fields are not detected when the form is submitted. Is there a setting on the cold fusion admin for using cfform's validation?
It looks like they’re giving away an xBox 360 and the
Gear’s of War game every week until 12/15. Pretty cool game!
www.servermechanic.com
http://www.servermechanic.com
Hi Reyn
use the following query to get the average of the 4 grades
<cfquery name="getgrades" datasource="yourdsn">
select student_id, 1stgrading, 2ndgrading, 3rdgrading, 4thgrading,
(1stgrading+2ndgrading+3rdgrading+4thgrading)/4 as avg_grad
from tbl_grade
</cfquery>then the query will have avg_grad as the computed column.
use the field avg_grad as the average grade for students in your output
I hope this solves your problem
-Ramesh
Hello Ramesh,
tnx for the code... sorry for the late response... actually i already used that code but it seems that the error will exist. i will send the detailed errors so that you will know what is my problem. okey... see yah... tnx a lot....
Reyn
Hello Ramesh,
It's me again asking for your help. Still we encountered problems. How can I insert or add data using multiple textfield in one form?
Like this:
First Grading
James Tan 88
Jaime Abba 85
Grace Sasa 78
Gerald Hulife 96
Mark Reyes 85
Submit
Second Grading
James Tan 88 78
Jaime Abba 85 90
Grace Sasa 78 85
Gerald Hul 96 85
Mark Reyes 85 90
Submit
How will I insert that in different fields in a database?
Like this:
tbl_studentgrade
Name 1st 2nd 3rd 4th Ave
James Tan 88 78
Jaime Abba 85 90
Grace Sasa 78 85
Gerald Hul 96 85
Mark Reyes 85 90
If anyone knows how, Please help me....
Tnx...
Reyn
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.