•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 391,549 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,537 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ColdFusion advertiser:
Views: 2770 | Replies: 7
 |
| |
•
•
Join Date: Sep 2006
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Can someone help me in Coldfusion? 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....
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....
"IT student doesn't work HARD but work SMART"
•
•
Join Date: Oct 2006
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Can someone help me in Coldfusion? 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
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
•
•
Join Date: Sep 2006
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
"IT student doesn't work HARD but work SMART"
•
•
Join Date: Oct 2006
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi Reyn
use the following query to get the average of the 4 grades
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
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
•
•
Join Date: Sep 2006
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
"IT student doesn't work HARD but work SMART"
•
•
Join Date: Sep 2006
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
Last edited by anyer_ast!g : Dec 6th, 2006 at 4:30 am.
"IT student doesn't work HARD but work SMART"
•
•
Join Date: Oct 2006
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
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?
•
•
Join Date: Oct 2006
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
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
Gear’s of War game every week until 12/15. Pretty cool game!
www.servermechanic.com
http://www.servermechanic.com
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb ColdFusion Marketplace
Hybrid Mode
Similar Threads
- PHP, ASP, ColdFusion, what's your fav? (IT Technologies and Trends)
- want to upload images to access db from ColdFusion (ColdFusion)
- Help needed removing coldfusion.112 (Viruses, Spyware and other Nasties)
- Can't remove ColdFusion Trojan (Viruses, Spyware and other Nasties)
- ColdFusion 5 Web Application Construction Kit (ColdFusion)
- Essential Coldfusion 4.5 For Web Professionals (ColdFusion)
- Macromedia Coldfusion 5 Language Reference (ColdFusion)
- Don't know much about ColdFusion? Read this. (ColdFusion)
Other Threads in the ColdFusion Forum
- Previous Thread: coldfusion administrator error
- Next Thread: Coldfusion MX Video???
