Difference between revisions of "DD Class11"
esse quam videri
(→Sub Query) |
|||
| Line 19: | Line 19: | ||
</sql> | </sql> | ||
| − | ==Uploader/Email== | + | ==Uploader/Email== |
===Mappath=== | ===Mappath=== | ||
| + | |||
| + | Server.Mappath | ||
upload permissions | upload permissions | ||
Revision as of 04:11, 10 April 2007
Contents
Sub Query
Course adder example
http://iam.colum.edu/dd/classsource/class8/student.aspx
SQL Subquery
<sql>SELECT CourseID, CourseName, CourseNumber FROM Course WHERE (
CourseID not in
(
SELECT CourseID FROM StudentsCourses_vw WHERE StudentID = @StudentID
)
) </sql>
Uploader/Email
Mappath
Server.Mappath
upload permissions
HomeWork
Web Skeleton of your site
Demostate one feature
