ludiusvox
/
TaskProject


  
1

	
2

	
3

	
4

	
5

	
6

	
7

	
8

	
9

	
10

	
11

	
12

	
13

	
14

	
15

	
16

	
17

	
18

	
19

	
20

	
21

	
22

	
23

	
24

	
25

	
26

	
27

	
28

	
29

	
30

	
31

	
32

	
33

	
34

	
35

	
36

	
37

	
38

	
39

	
40

	
41

	
42

	
43

	
44

	
45

	
46

	
47

	
48

	
49

	
50

	
51

	
52

	
53

	
54

	
55

	
56

	
57

	
58

	
59

	
60

	
            <!DOCTYPE html>
<html>
<head>
    <!-- Include Bootstrap CSS -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    <title>Projects for Student</title>
</head>
<body>


    <cftry>
        <!-- Define the project query for faculty involved in "Website Redesign" project -->
        <cfquery name="students" datasource="task">
           SELECT * FROM student
        </cfquery>
        <cfdump var="#students#" expand="true" label="Students Array">
        <!-- Check if the project query exists and has records -->
        <cfif isQuery(students)>
            <!-- Loop through the project query and display faculty names -->
            <ul>
                <cfoutput query="students">
                    <li>#htmlEditFormat(students.fname)#</li>
                </cfoutput>
            </ul>
        </cfif>
    <cfcatch>
        <!-- Handle any errors that occur within the try block -->
        <p>Error retrieving student data: #cfcatch.message#</p>
    </cfcatch>
</cftry>

<!--- Loop through the students query and display student information --->
<!--- Loop through the students query and display student information --->
<table border="1">
    <tr>
        <th>Student ID</th>
        <th>Name</th>
        <th>Major</th>
        <th>Level</th>
        <th>Birth Year</th>
    </tr>
    <cfoutput query="students">
        <tr>
            <td>#students.sid#</td>
            <td>#students.sname#</td>
            <td>#students.major#</td>
            <td>#students.level#</td>
            <td>#students.byear#</td>
        </tr>
    </cfoutput>
</table>


</body>
</html>