Please bear with me..its a little long..:)
I have 2 tables
table 1:courses
cid(primary key),coursename,coursedesc
table 2:students_courses
stucourses_id(primary key), cid(foreign key), stu_addedby
contents in table 1 are added by me to the Access database.
But contents in table 2 are added by students thru the web.
I made a Query in Access which shows cid and coursename from courses and stu_addedby from students_courses.
SELECT courses.cid, courses.coursename, students_courses.stu_addedby
FROM courses LEFT JOIN students_courses ON courses.cid = students_courses.cid;
but it shows several duplicate values like.
cid coursename stu_addedby
--------------------------------------
1 MATH1234 jane
1 MATH1234 greg
2 PSYC3421 jane
3 EDLD5643 monica
3 EDLD5643 jane
In my ASP page I would like to show distinct cid,coursename
My ASP page should look like this for User "greg"
Hi Greg!!Your courses are
COURSE NAME ADD/UPDATE
----------------------------
MATH1234 UPDATE
PSYC3421 ADD
EDLD5643 ADD
but it wud show duplicates like below
Hi Greg !! Your courses are
COURSE NAME ADD/UPDATE
----------------------------
MATH1234 UPDATE
MATH1234 UPDATE
PSYC3421 ADD
EDLD5643 ADD
EDLD5643 ADD
ASP code is
*********************************************
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<tr>
<td width="247"><%=(Recordset1.Fields.Item("coursename").Value)%></td>
<td width="497">
<table width="500" border="0" cellspacing="1" cellpadding="1">
<tr>
<td>
<% if (Recordset1.Fields.Item("cid").Value) <> " " AND Session("MM_Username") =
(Recordset1.Fields.Item("stu_addedby").Value) then %>
<p> UPDATE</p>
<%ELSE%>
<p> <A HREF="course_details.asp?<%= MM_keepURL & MM_joinChar(MM_keepURL) & "cid=" &
Recordset1.Fields.Item("cid").Value %>">ADD</A></p>
<%end if%>
</td>
</tr>
</table>
</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</table>
</body>
</html>
<%
Recordset1.Close()
%>
*****************************************************
PLEASE HELP!! I HAVE BEEN WORKING ON THIS FOR SEVERAL DAYS!! PLEASE help !
Thanks.
I have 2 tables
table 1:courses
cid(primary key),coursename,coursedesc
table 2:students_courses
stucourses_id(primary key), cid(foreign key), stu_addedby
contents in table 1 are added by me to the Access database.
But contents in table 2 are added by students thru the web.
I made a Query in Access which shows cid and coursename from courses and stu_addedby from students_courses.
SELECT courses.cid, courses.coursename, students_courses.stu_addedby
FROM courses LEFT JOIN students_courses ON courses.cid = students_courses.cid;
but it shows several duplicate values like.
cid coursename stu_addedby
--------------------------------------
1 MATH1234 jane
1 MATH1234 greg
2 PSYC3421 jane
3 EDLD5643 monica
3 EDLD5643 jane
In my ASP page I would like to show distinct cid,coursename
My ASP page should look like this for User "greg"
Hi Greg!!Your courses are
COURSE NAME ADD/UPDATE
----------------------------
MATH1234 UPDATE
PSYC3421 ADD
EDLD5643 ADD
but it wud show duplicates like below
Hi Greg !! Your courses are
COURSE NAME ADD/UPDATE
----------------------------
MATH1234 UPDATE
MATH1234 UPDATE
PSYC3421 ADD
EDLD5643 ADD
EDLD5643 ADD
ASP code is
*********************************************
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<tr>
<td width="247"><%=(Recordset1.Fields.Item("coursename").Value)%></td>
<td width="497">
<table width="500" border="0" cellspacing="1" cellpadding="1">
<tr>
<td>
<% if (Recordset1.Fields.Item("cid").Value) <> " " AND Session("MM_Username") =
(Recordset1.Fields.Item("stu_addedby").Value) then %>
<p> UPDATE</p>
<%ELSE%>
<p> <A HREF="course_details.asp?<%= MM_keepURL & MM_joinChar(MM_keepURL) & "cid=" &
Recordset1.Fields.Item("cid").Value %>">ADD</A></p>
<%end if%>
</td>
</tr>
</table>
</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</table>
</body>
</html>
<%
Recordset1.Close()
%>
*****************************************************
PLEASE HELP!! I HAVE BEEN WORKING ON THIS FOR SEVERAL DAYS!! PLEASE help !
Thanks.