[thelist] ColdFusion Question

Minh Lee Goon v7ac at sdsumus.sdstate.edu
Mon Sep 25 16:12:04 CDT 2000


Dear evolters,
I really need your help here. You can view what I have at
http://137.216.120.208/scs/training/admin/Cadmin.cfm

I have a database of student information and some of the columns have
been given names like Access2000 and Excel2000 to denote the training
classes for which they have signed up. In those columns are the dates of
the classes. The names of those columns are also names of separate
tables (which may be my downfall), in which are stored the dates of that
class. For example, the Access2000 table would contain the dates and
times of Access 2000 classes.

Now, I've got the registration form pretty much done. I'm working on the
administration area to give our training coordinator access to print off
attendance sheets, ie the names of the people who have signed up for
each class.

Here's what I have:
<cfset ClassName="#url.Class#">

<!--- Select class name and description --->
<cfquery datasource="blah" name="ClassName">
	SELECT ID, TableName, CourseName
	FROM   Classes
	WHERE  TableName = '#ClassName#'
</cfquery>

<!--- Select list of student in that class --->
<cfquery datasource="blah" name="StudentsList">
	SELECT   StudentID, LastName, FirstName, #ClassName#
	FROM     StudentData
	ORDER BY LastName
</cfquery>

I'm stuck here. Any suggestions at all?

Thanks in advance.

</ml>




More information about the thelist mailing list