>>I'd need someting like
IF create_d between <3 months ago> and <now>
Then
INSERT(title,0,0,'<span
style="font-style:bold;color:#000000;">NEW</span>') AS new_title
Check if you can use the IIf function in your database, ie:
SELECT IIF (create_d > <3 months ago>, '<span
style="font-style:bold;color:#000000;">NEW</span>' , '') & title
AS new_title, ...
Or try to use a UNION:
SELECT '<span style="font-style:bold;color:#000000;">NEW</span>' &
title AS new_title, ...
FROM ...
WHERE create_d > <3 months ago>
UNION
SELECT title AS new_title, ...
FROM ...
WHERE create_d <= <3 months ago>
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305340
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
