|
ITCoreTeam -> Join 3 Tables in SQL using DW MX 2004 (10/14/2007 17:43:52)
|
Join 3 Tables in SQL using Dreamweaver MX 2004
I'm trying to display records using three tables joined as shown in the SQL code below. I'm getting "no data" message when I test the result page from the search form. I'm using the advanced Dreamweaver form to enter the SQL commands. I have never used this feature of Dreamweaver before and I'm not sure if the code below follows the way DW MX will understand what I'm trying to do. Below is the code based on Standard SQL....not sure if DW compatible...
This is what I typed in the SQL box:
SELECT
ResourceSkillMapping.resourceSkillMapID,ResourceSkillMapping.skillID,
ResourceSkillMapping.competenceLevel,skill.skillname,resource.resourceName,resource.resourceLoginId
FROM ResourceSkillMapping INNER JOIN Skill ON ResourceSkillMapping.skillID = Skill.skillID
INNER JOIN Resource ON ResourceSkillMapping.resourceSkillMapID = Resource.resourceSkillMapID
WHERE (Skill.skillName = '%Skill_asp%') AND (Resource.resourceLoginID = '%Agent_asp%')
AND (Resource.active = 1)
These is typed in the variables box:
Variable Default Runtime
Skill_asp 1 Request.QueryString("skillname")
Agent_asp 1 Request.QueryString("resourceLoginID")
I'm using asp and the "Get" url parameters in the search form calling the result recordset in DW. I'm connecting to a SQL 2000 server. Is this notation DW correct? Am I joining the tables correctly. The tables are ResourceSkillMapping, Skill and Resource. All I need is to be able to search by ResourceLoginID and by skillName on all active records (active=1). The plan is to be able to click on a result record and go to a detail page to update the "CompetencyLevel" field in the resourceSkillMapping table using the update behavior in DW.
Please help I have been trying every posibility I could think so far....I have read all the DW help facilities many pages on this and still keep getting the "no data" message
Thank you,
Carlos
carlos@itcoreteam.com
|
|
|
|
