Update Behavior using Multiple tables

ITCoreTeam wrote:
> I'm trying to use the Update behavior from Dreamweaver MX2004 to
update fields
> from diferent joined tables. The search form works OK as I joined the
tables
> and I get great results (see SQL Query below). When I try to create
link to a
> detail page from the master page and I use the same recordset as
below and I
> use the update behavior, I can only choose a table at the time to
update fields
> using only one key. If I choose only one table and pass one key field
is OK but
> I need to update all three joined tables. Is there a way to do
something like
> this in the Link field in the master page calling the detail page? Is
there is
> a correct way to pass the three keys from the master page to the
detail page?
> I'm using ASP and standard SQL. The environment is Windows for
testing and SQL
> server.
> Detail Page Parameters:
> details_Admin_Skill_Resource.asp?resourceSkillMapID=
>
>
<%=(Recordset1.Fields.Item("resourceSkillMapID").Value)%>?<%=(Recordset1.Fields.
>
Item("skillID").Value)%>?<%=(Recordset1.Fields.Item("resourceId").Value)%>
>
> I'm also inserting hidden fileds in the detail form. Any Ideas how
to update
> several tables in DW MX2004 with the update behavior?
>
>
> This is the query in the recordset and it is working OK as it
produces results
> from the search page. What modifications I need to do to this
recordset in the
> update page?
>
>
> Thank you for your help!!!
> Carlos Melendez
> carlos@itcoreteam.com
>
> This is what I typed in the advanced SQL box in the recordset.
> SELECT
>
>
>
ResourceSkillMapping.resourceSkillMapID,ResourceSkillMapping.skillID,ResourceSki
>
llMapping.competenceLevel,skill.skillname,resource.resourceName,resource.reso
>
>
>
urceLoginId,resource.resourceId,resource.profileId,resource.resourceGroupID,reso
>
urce.resourceType,resource.active,resource.autoAvail,resource.extension,resou
>
>
>
rce.orderInRG,resource.dateInactive,resource.assignedTeamID,resource.resourceFir
> stName,resource.resourceLastName
> FROM ResourceSkillMapping INNER JOIN Skill ON
ResourceSkillMapping.skillID =
> Skill.skillID INNER JOIN Resource ON
ResourceSkillMapping.resourceSkillMapID =
>
> Resource.resourceSkillMapID
> WHERE (Resource.resourceLoginID LIKE '%Agent_asp%') AND
(Resource.active = 1)
> OR (Skill.skillName LIKE '%Skill_asp%')
>
> Variables
> Skill_asp for skillName
> Agent_asp for resourceLoginID
>
> Default value of variables is 1 to display all records
>
> Runtime
> Request.QueryString("skillname")
> Request.QueryString("resourceLoginID")
>

One solution is to create a view in SQL, that is exactly the same as
your SELECT above. You then use the view name instead of the table name
in your UPDATE statement. I know in the SQL world that this is possible,
but I don't know if the Dreamweaver update behaviour will see the views
stored on your SQL server.

Steve

ITCoreTeam wrote:
> I'm trying to use the Update behavior from Dreamweaver MX2004 to update fields
> from diferent joined tables. The search form works OK as I joined the tables
> and I get great results (see SQL Query below). When I try to create link to a
> detail page from the master page and I use the same recordset as below and I
> use the update behavior, I can only choose a table at the time to update fields
> using only one key. If I choose only one table and pass one key field is OK but
> I need to update all three joined tables. Is there a way to do something like
> this in the Link field in the master page calling the detail page? Is there is
> a correct way to pass the three keys from the master page to the detail page?
> I'm using ASP and standard SQL. The environment is Windows for testing and SQL
> server.
> Detail Page Parameters:
> details_Admin_Skill_Resource.asp?resourceSkillMapID=
>
> <%=(Recordset1.Fields.Item("resourceSkillMapID").Value)%>?<%=(Recordset1.Fields.
> Item("skillID").Value)%>?<%=(Recordset1.Fields.Item("resourceId").Value)%>
>
> I'm also inserting hidden fileds in the detail form. Any Ideas how to update
> several tables in DW MX2004 with the update behavior?
>
>
> This is the query in the recordset and it is working OK as it produces results
> from the search page. What modifications I need to do to this recordset in the
> update page?
>
>
> Thank you for your help!!!
> Carlos Melendez
> carlos@itcoreteam.com
>
> This is what I typed in the advanced SQL box in the recordset.
> SELECT
>
>
> ResourceSkillMapping.resourceSkillMapID,ResourceSkillMapping.skillID,ResourceSki
> llMapping.competenceLevel,skill.skillname,resource.resourceName,resource.reso
>
>
> urceLoginId,resource.resourceId,resource.profileId,resource.resourceGroupID,reso
> urce.resourceType,resource.active,resource.autoAvail,resource.extension,resou
>
>
> rce.orderInRG,resource.dateInactive,resource.assignedTeamID,resource.resourceFir
> stName,resource.resourceLastName
> FROM ResourceSkillMapping INNER JOIN Skill ON ResourceSkillMapping.skillID =
> Skill.skillID INNER JOIN Resource ON ResourceSkillMapping.resourceSkillMapID =
>
> Resource.resourceSkillMapID
> WHERE (Resource.resourceLoginID LIKE '%Agent_asp%') AND (Resource.active = 1)
> OR (Skill.skillName LIKE '%Skill_asp%')
>
> Variables
> Skill_asp for skillName
> Agent_asp for resourceLoginID
>
> Default value of variables is 1 to display all records
>
> Runtime
> Request.QueryString("skillname")
> Request.QueryString("resourceLoginID")
>

One solution is to create a view in SQL, that is exactly the same as
your SELECT above. You then use the view name instead of the table name
in your UPDATE statement. I know in the SQL world that this is possible,
but I don't know if the Dreamweaver update behaviour will see the views
stored on your SQL server.

Steve