=?Utf-8?B?cm9kY2hhcg==?=
4/1/2004 2:04:00 AM
Question has been answered: Use table.field name
definitions for the entire sql string (select team.key as
kay1, team.resource_id as resource_id, resource.key as
key2...
Thanks
>-----Original Message-----
>I have a results page that queries two tables in the same
>databaseto return results specific to a team:
>fp_sQry="SELECT * FROM Team,Resource where team.proj_id
>=::proj:: and team.resource_id=resource.key"
>
>How do you select the specific table in the hyperlink
>parameter when the two tales have the field of the same
>name?
>
>The table holding the project specific resource data,
>team, has the same name, [color=#FF0000]key[/color], for
>its unique record as the overall resource table, resource.
>
>Problem is when I go to delete a specific record on the
>team list, I query the delete.asp page using a hyperlink
>with a parameter:
>.../team/editor/delete.asp?key=<%=FP_FieldVal
(fp_rs,"key")%>
>
>and in doing so, I keep pulling the key for the resource
>table and deleting the resource, instead of pulling key
>for the team table.
>
>I tried:
>team/editor/delete.asp?key=<%=FP_FieldVal
>(fp_rs,"team.key")%> and
>team/editor/delete.asp?key=<%=FP_FieldVal
>(fp_rs,team,"key")%>
>
>but these don't work.
>
>Any ideas?
>.
>