Hello there !!
I have Create this page which will receive the staffID from form page. Based on that information it should extract the unitIDs, names and semesters of all units coordinated by this staff member and display in a table
But When i run it i get this
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'coordination.staffID = and unit.unitID = coordination.unitID and coordination.staffID = staff.staffID'
If anyone could help me with this?
Thanx for your time.
<%@ Language="VBScript" %>
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<% set myConnection=server.createobject("ADODB.connection ")
myConnection.open "Outline", "IWSDStudent", "assign2"
sID = request.form("staffID") 'retrieve the StaffID
'use the Staff ID to retrieve the info from the db
mySQL = "select coordination.unitID, unit.unitname, "
mySQL = mySQL & "coordination.semester from unit, staff, coordination"
mySQL = mySQL & " where coordination.staffID = " & sID & " and "
mySQL = mySQL & "unit.unitID=coordination.unitID and "
mySQL = mySQL & "coordination.staffID =staff.staffID"
set myRS = myConnection.execute(mySQL)
%>
<body>
<h2>Units coordinated by: <%=sID%></h2>
<table border="1" summary="Coordination details">
<tr><td>Unit ID</td><td>Unit Name</td><td>Semester</td></tr>
<%
do while not myRS.eof
%>
<tr><td><%= myRS ("unitID")%></td>
<td><%= myRS ("unitname")%></td>
<td><%= myRS ("semester")%></td>
</tr>
<%
myRS.movenext
loop
%>
</table>
<br /><p><a href="ex8.htm">Return to the form</a></p>
</body>
</html>
dBforums
>
help?
05-21-04, 23:43
Linear Mode
