ASP.NET

SQL Strings

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2009

Posts: 8

Reputation: f_atencia is an unknown quantity at this point

Solved Threads: 0

f_atencia

Offline

Newbie Poster

SQL Strings

Sep 23rd, 2009

Hi all,

I have an SQL Datasource:

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
<asp:SqlDataSource ID="shownMovie" runat="server" 
        ConnectionString="<%$ ConnectionStrings:MovieTix %>" 
        SelectCommand="SELECT movie.title, movie.category FROM [movie],[session],[theatre],[cinema] 
                       WHERE cinema.cinemaLocation=theatre.cinemaLocation AND theatre.theatreNumber=session.theatreNumber
                       AND session.movieID=movie.movieID AND ([movieID] = @movieID)">
        <SelectParameters>
            <asp:ControlParameter ControlID="GridView1" Name="movieID" 
                PropertyName="SelectedValue" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
<asp:SqlDataSource ID="shownMovie" runat="server" 
        ConnectionString="<%$ ConnectionStrings:MovieTix %>" 
        SelectCommand="SELECT movie.title, movie.category FROM [movie],[session],[theatre],[cinema] 
                       WHERE cinema.cinemaLocation=theatre.cinemaLocation AND theatre.theatreNumber=session.theatreNumber
                       AND session.movieID=movie.movieID AND ([movieID] = @movieID)">
        <SelectParameters>
            <asp:ControlParameter ControlID="GridView1" Name="movieID" 
                PropertyName="SelectedValue" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>

However, i get the following error message:
Ambiguous column name 'movieID'.

Basically I am trying to join it up so whatever cinema the customer wishes to see pulls up a record of movies being shown at that chosen cinema from a previous gridview.

Any help would be appreciated.

Last edited by peter_budo; Sep 27th, 2009 at 8:35 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Aug 2007

Posts: 182

Reputation: Kusno is an unknown quantity at this point

Solved Threads: 15

Kusno

Offline

Junior Poster

Re: SQL Strings

Sep 24th, 2009

•

Originally Posted by f_atencia

Hi all,

I have an SQL Datasource:
<aspqlDataSource ID="shownMovie" runat="server"
ConnectionString="<%$ ConnectionStrings:MovieTix %>"
SelectCommand="SELECT movie.title, movie.category FROM [movie],[session],[theatre],[cinema]
WHERE cinema.cinemaLocation=theatre.cinemaLocation AND theatre.theatreNumber=session.theatreNumber
AND session.movieID=movie.movieID AND ([movieID] = @movieID)">
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" Name="movieID"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</aspqlDataSource>

However, i get the following error message:
Ambiguous column name 'movieID'.

Basically I am trying to join it up so whatever cinema the customer wishes to see pulls up a record of movies being shown at that chosen cinema from a previous gridview.

Any help would be appreciated.

maybe, you forget the red-bold one text.

thanks

NEVER NEVER NEVER GIVE UP

•

Join Date: Feb 2009

Posts: 3,442

Reputation: sknake has much to be proud of

Solved Threads: 626

sknake

Offline

.NET Enthusiast

Re: SQL Strings

Sep 24th, 2009

Try using this:

Help with Code Tags

text Syntax (Toggle Plain Text)

<asp:SqlDataSource ID="shownMovie" runat="server" 
        ConnectionString="<%$ ConnectionStrings:MovieTix %>" 
        SelectCommand="SELECT movie.title, movie.category FROM [movie],[session],[theatre],[cinema] 
                       WHERE cinema.cinemaLocation=theatre.cinemaLocation AND theatre.theatreNumber=session.theatreNumber
                       AND session.movieID=movie.movieID AND (movie.[movieID] = @movieID)">
        <SelectParameters>
            <asp:ControlParameter ControlID="GridView1" Name="movieID" 
                PropertyName="SelectedValue" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>