-
multiple table sort AGAIN
I am trying to list all staff in each department. I am using access, and have defined a link key so that the tables are joined. I followed your original instructions in defining the query, getting the SQL statement that access defined for the query, and pasting it into the asp script. Well, no matter what I try, it will not work. I continually get errors.
the script is as follows:
<HTML>
<BODY>
<CENTER>
Welcome to an ASP-db™ Test Page.<P>
<%
Set MyDb = Server.CreateObject("ASPdb.Free" ' Create the ASP-db™ object
MyDb.dbMDB = Server.MapPath("DepartmentsNew2000.mdb" ' Use YourFile.mdb in the current directory
MyDb.dbColor = "1,auto" ' Pick color scheme 1, turn on Color button
MyDb.dbMode = "grid" ' Show it in "display" mode
MyDb.dbGridTableTag = "BORDER=2" ' Set the table BORDER to 2
MyDb.dbSQL = "SELECT DepartmentInfo.DepartmentName, WSCStaff.Fname, WSCStaff.Lname, WSCStaff.Title, WSCStaff.Extension, WSCStaff.Email" &_
"FROM DepartmentInfo, WSCStaff INNER JOIN Staff_Dept ON WSCStaff.ID = Staff_Dept.ID" &_
"ORDER BY DepartmentInfo.DepartmentName, WSCStaff.Lname"
MyDb.ASPdbFree ' Tell ASP-db to show the table
%>
</CENTER>
</BODY>
</HTML>
I have tried to move the quotes and seperate the statements in different ways, i have tried to add &_ at the end of the statements like the example on your web site and I am at a loss.
Could someone please help.
Thank you
Jennifer C. Swartz
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|