[thelist] ASP.NET: UNION query not returning expected results

[Tab Alleman]

<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 ! 
>