What you've written there, Les, will only get you records where BOTH
before and after have a value.   Is that what you want?

Perhaps you need to change the sql to read:


 SELECT * FROM myTABLE
 WHERE
   (before is not NULL or before <> '')
   OR
  (after  is not NULL or after <> '')
    and database_id = #url.id#

which in english means give me all the records from myTable  where
'before' has a value OR 'after' has a value and the database_id is
<whatever>

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month




On 7/23/07, Les Mizzell <[EMAIL PROTECTED]> wrote:
> Mike Kear wrote:
> > 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#
>
> Which would see to lead me to this:
>
> SELECT * FROM myTABLE
> WHERE
>   (before is not NULL or before <> '')
>    and (after is not NULL or after <> '')
>    and database_id = #url.id#
>
> But this returns zero results, and there's clearly cases where, "after"
> has a value, so I' still not sure what I've got wrong.
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284341
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to