gandert
16/08/07, 03:25
Ik weet hoe ik 1 INNER JOIN kan doen maar weet niet hoe ik meerdere doe.
Nu is het mogelijk dat entries.FKcategoryId1 kan veranderd worden naar category.categoryname.
Wat ik wil:
Dat volgende gegevens allemaal veranderd kunnen worden:
entries.FKcategoryId1 naar category.categoryname
entries.FKcategoryId2 naar category.categoryname
entries.FKcategoryId3 naar category.categoryname
entries.FKcategoryId4 naar category.categoryname
bv:
entries.FKcategoryId1 = "1", category.id = "1" en category.categoryname = "categorienaam"
dus het moet "categorienaam" tonen ipv "1" (dit voor de 4 (FKcategoryId1, FKcategoryId2, ...)
<asp:DataList ID="DataList1" runat="server" DataSourceID="AccessDataSourceEntries">
<ItemTemplate>
<h1 class="asp"><asp:HyperLink CssClass="live" ID="HyperLink2" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.id", "comment.aspx?id={0}")%>'>
<%# Eval("titel") %></asp:HyperLink></h1>
<h2 class="php"><%# Eval("date") %> in
<asp:HyperLink CssClass="stream" ID="HyperLink1" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId1", "comment.aspx?FKcategoryId1={0}")%>'>
<%#Eval("FKcategoryId1")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink5" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId2", "comment.aspx?FKcategoryId2={0}")%>'>
<%#Eval("FKcategoryId2")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink6" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId3", "comment.aspx?FKcategoryId3={0}")%>'>
<%#Eval("FKcategoryId3")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink7" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId4", "comment.aspx?FKcategoryId4={0}")%>'>
<%#Eval("FKcategoryId4")%></asp:HyperLink>
-
<asp:HyperLink CssClass="stream" ID="HyperLink3" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.id", "comment.aspx?id={0}")%>'>
Comments</asp:HyperLink></h2>
<h2 class="ajax"><%# Eval("text") %></h2>
<asp:HyperLink CssClass="stream" ID="HyperLink4" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId1", "comment.aspx?FKcategoryId1={0}")%>'>
<%#Eval("FKcategoryId1")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink8" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId2", "comment.aspx?FKcategoryId2={0}")%>'>
<%#Eval("FKcategoryId2")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink9" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId3", "comment.aspx?FKcategoryId3={0}")%>'>
<%#Eval("FKcategoryId3")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink10" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId4", "comment.aspx?FKcategoryId4={0}")%>'>
<%#Eval("FKcategoryId4")%></asp:HyperLink>
<hr class="webdesigner" />
</ItemTemplate>
</asp:DataList><asp:AccessDataSource ID="AccessDataSourceEntries" runat="server"
DataFile="~/App_Data/gandert.mdb"
SelectCommand="SELECT entries.id, entries.titel, entries.text, entries.FKcategoryId1, entries.FKcategoryId2, entries.FKcategoryId3, entries.FKcategoryId4, entries.date, entries.must, category.categoryname
FROM (entries INNER JOIN category ON entries.FKcategoryId1 = category.id) ORDER BY [entries.id] DESC">
</asp:AccessDataSource>
Nu is het mogelijk dat entries.FKcategoryId1 kan veranderd worden naar category.categoryname.
Wat ik wil:
Dat volgende gegevens allemaal veranderd kunnen worden:
entries.FKcategoryId1 naar category.categoryname
entries.FKcategoryId2 naar category.categoryname
entries.FKcategoryId3 naar category.categoryname
entries.FKcategoryId4 naar category.categoryname
bv:
entries.FKcategoryId1 = "1", category.id = "1" en category.categoryname = "categorienaam"
dus het moet "categorienaam" tonen ipv "1" (dit voor de 4 (FKcategoryId1, FKcategoryId2, ...)
<asp:DataList ID="DataList1" runat="server" DataSourceID="AccessDataSourceEntries">
<ItemTemplate>
<h1 class="asp"><asp:HyperLink CssClass="live" ID="HyperLink2" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.id", "comment.aspx?id={0}")%>'>
<%# Eval("titel") %></asp:HyperLink></h1>
<h2 class="php"><%# Eval("date") %> in
<asp:HyperLink CssClass="stream" ID="HyperLink1" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId1", "comment.aspx?FKcategoryId1={0}")%>'>
<%#Eval("FKcategoryId1")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink5" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId2", "comment.aspx?FKcategoryId2={0}")%>'>
<%#Eval("FKcategoryId2")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink6" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId3", "comment.aspx?FKcategoryId3={0}")%>'>
<%#Eval("FKcategoryId3")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink7" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId4", "comment.aspx?FKcategoryId4={0}")%>'>
<%#Eval("FKcategoryId4")%></asp:HyperLink>
-
<asp:HyperLink CssClass="stream" ID="HyperLink3" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.id", "comment.aspx?id={0}")%>'>
Comments</asp:HyperLink></h2>
<h2 class="ajax"><%# Eval("text") %></h2>
<asp:HyperLink CssClass="stream" ID="HyperLink4" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId1", "comment.aspx?FKcategoryId1={0}")%>'>
<%#Eval("FKcategoryId1")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink8" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId2", "comment.aspx?FKcategoryId2={0}")%>'>
<%#Eval("FKcategoryId2")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink9" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId3", "comment.aspx?FKcategoryId3={0}")%>'>
<%#Eval("FKcategoryId3")%></asp:HyperLink>
<asp:HyperLink CssClass="stream" ID="HyperLink10" runat="server" NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.FKcategoryId4", "comment.aspx?FKcategoryId4={0}")%>'>
<%#Eval("FKcategoryId4")%></asp:HyperLink>
<hr class="webdesigner" />
</ItemTemplate>
</asp:DataList><asp:AccessDataSource ID="AccessDataSourceEntries" runat="server"
DataFile="~/App_Data/gandert.mdb"
SelectCommand="SELECT entries.id, entries.titel, entries.text, entries.FKcategoryId1, entries.FKcategoryId2, entries.FKcategoryId3, entries.FKcategoryId4, entries.date, entries.must, category.categoryname
FROM (entries INNER JOIN category ON entries.FKcategoryId1 = category.id) ORDER BY [entries.id] DESC">
</asp:AccessDataSource>