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:284334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
