have to order classes by ID
Select c.classId, c.classTexts, c.classDescription,
cc.classCodeSection, cc.classDate, cc.classTime,
cc.classLocation, cc.classInstructor
FROM CLASSES c, CLASSCODES cc
WHERE c.classId = ""> AND ...
ORDER BY c.classId, ...
<cfoutput query="myQuery" group="classId">
<!--- general info about class --->
#myQuery.classDescription#<br>...
<cfoutput>
<!--- specific info about class code --->
#myQuery.classCodeSection#<br>
#myQuery.classDate#<br>
#myQuery.classTime#<br>...
</cfoutput>
</cfoutput>
Pascal
> -----Original Message-----
> From: mayo [mailto:[EMAIL PROTECTED]
> Sent: maandag 16 februari 2004 14:54
> To: CF-Talk
> Subject: sql, problem with
>
> Currently I display a list of classes.
> Simplified SQL and display below:
>
> SELECT *
> FROM classes
> WHERE
> classCategory='$Category' AND
> classDeleted=0
> ORDER BY $order $reorder
>
> The presentation is:
>
> +------------------+----------+------------+
> | CLASS TITLE | LOCATION | CLASS CODE |
> +------------------+----------+------------+
> | CLASS DESCRIPTION <br/><br/> |
> | CLASS INSTRUCTOR <br/><br/> |
> | CLASS TIME |
> +------------------------------------------+
>
>
> Now, things are getting a little more complicated. Each
> class is going to have sections. So the display will be:
>
> CLASS TITLE
> CLASS DESCRIPTION
>
> CLASS CODE : CLASS SECTION .. LOCATION .. CLASS TIME .. INSTRUCTOR
>
> example (simplified)
>
> +---------------------------------------------+
> | INTRO TO AAA |
> +---------------------------------------------+
> | This is a really interesting .... |
> | |
> +---------+-----+------------+----------------+
> |HT-111:A | NYC | 12:00-4:00 | Albert Alkin |
> |HT-111:B | JC | 2:00-6:00 | Bob Bailey |
> |HT-111:C | BX | 4:00-8:00 | Chris Cawley |
> +---------+-----+------------+----------------+
>
>
> I'm having a really hard time coming up with the sql for this.
>
> tables below
>
> CLASSES
> classID
> classDescription
> classTexts
> classCost
> classDeleted
>
> CLASSCODES
>
> classCodeID
> classID
> classCodeSection
> classDate
> classTime
> classLocation
> classInstructor
>
> I'm going nuts trying to get this. (using mysql)
>
> thx for any clues
>
> Gil
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
