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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 beta â Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284340
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
