If i recall, "<>'' "' is not the same as "is not NULL". So perhaps you need to change your query to something like:
select * from myTABLE WHERE before is not NULL and after is not NULL and someID = #url.id# On 7/23/07, Les Mizzell <[EMAIL PROTECTED]> wrote: > This should be simple, but doesn't seem to be working right. > > I have a SQL Server view pulling data in from several tables. I'm > interested in three columns in the view: > > 1. dataID > 2. before > 3. after > > Query below returns maybe 100 results, sometime there's values for > either "before" or "after", but sometimes they're both blank (either > could be null or empty). > > select * from myTABLE > WHERE before <> '' > and someID = #url.id# > > > I don't want to see results where they both return a blank, so seems a > simple query to return the wanted results: > > select * from myTABLE > WHERE > before <> '' > and after <> '' > and someID = #url.id# > > Query above filters out everything and I get zero results. > > > What could I be doing wrong? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
