[thelist] ASP.NET: UNION query not returning expected results
Tab Alleman
talleman at Lumpsum.com
Fri Sep 28 09:05:59 CDT 2007
<asp:SqlDataSource ID="dsMyDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="MyStoredProcedure" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter Name="EmpID" QueryStringField="id" />
</SelectParameters>
</asp:SqlDataSource>
...Pretty sure this would do it. This, or something like it...
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Joel D Canfield
> Sent: Thursday, September 27, 2007 6:05 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] ASP.NET: UNION query not returning expected
> results
>
>
> > if you then apply a filter after the result set has been
> returned, all
> > offices from the first SELECT except (maybe) one will be removed
> >
> > this just seems ~so~ in line with microsoft's approach to things...
>
> astute observation
>
> hey, Tab points out that SQL allows these things called 'stored
> procedures' that might do me up nicely
>
> 'cept, how would I convince it not to apply the filter to the returned
> results?
>
> I dislike enormously the way .NET manages this stuff, and I wish the
> client wasn't a) an excellent payer and b) a good friend or
> I'd abandon
> this for happier things
>
> joel
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list