I have a multiple table database set up that the company I am interning for has tasked me to design and create the web pages for this summer. The database is MS SQL and I am using Dreamweaver 8 to create the pages. The database is for my company to be able to add jobs and tasks and for the clients to view them. The problem that I am having, on multiple pages however is that for some reason the records won't show in firefox or internet explorer after I have added the dynamic content onto the pages. Some records show but the following ones do not. For instance, on a search results page the start and due dates show but when I have a detail page for that job, the do not show anymore. The Job ID is passed by the search page to the detail page and the client name is a session variable stemming from their login that only affects the search page. The query shows all values when I test it in the recordset creator in Dreamweaver so I am not sure why they are not showing up in the browser. This happens on other pages too, this is just a single example. Here is the Query if that helps, with MMColParam being the Job ID parameter. Any suggestions would be wonderful. The Employee is used to display the name of a job contact, instead of that employees ID number showing on the page.

SELECT [Job Info].*, Employees.Employee
FROM dbo.[Job Info], dbo.Employees
WHERE [Job ID] = MMColParam and [Job Info].[Job Contact] like Employees.EmployeeID