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