[thelist] SQL: Problem with a join, i think

[Tab Alleman]

Have you tried having your ASP page Response.Write() your SQL before executing it?   

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Luther, Ron
> Sent: Tuesday, February 14, 2006 5:56 PM
> To: Casey Crookston; thelist at lists.evolt.org
> Subject: Re: [thelist] SQL: Problem with a join, i think
> 
> 
> Casey Crookston asked about a misbehaving query:
> 
> 
> Hi Casey,
> 
> I'm not 100% sure, but I'm thinking it could be an 'order of 
> precedence'
> issue.
> 
> Whenever I mix 'and's and 'or's I throw in enough parenthesis to make
> sure there 
> is no ambiguity.
> 
> 
> HTH,
> 
> RonL.
> -- 
> 
> * * 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 ! 
>