It's working the way it should. It's finding each relevant record. If
you want just one version of it (and don't care about displaying who
is sharing it) just add a distinct clause at the front.
SELECT distinct n.meeting_name,n.type,n.note_date,n.notes,n.type_describe
FROM notes_to_the_record n LEFT JOIN notes_to_the_record_shared s on
n.n_r_id = s.n_r_id
WHERE
n.ID = #session.user.id# OR
s.id = #session.user.id#
ORDER BY UPPER(n.meeting_name) AS
On 1/26/07, daniel kessler <[EMAIL PROTECTED]> wrote:
> Well, I thought that worked - and it largely did with one problem.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267731
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
