[Top] [All Lists]

Re: Dynamic Tool Tip

Subject: Re: Dynamic Tool Tip
From: Azadi
Date: Wed, 01 Aug 2007 18:27:37 -0400
Newsgroups: macromedia.coldfusion.cfml_general_discussion

Javagene wrote:

....which query will give me his two department name to display in tool tip?
1) - basic sample using GROUP attribute of cfoutput tag

select e.*, d.department_name
from employees e inner join departments d on e.employee_id = d.employee_id
order by whateveryouwant

then use the GROUP attribute in the cfoutput

2) - will probably be more usable in your case of tooltips

have 1 master join query that selects ALL employees and departments
have 1 QoQ selecting DISTINCT employee rows from master query
cfoutput this QoQ to display your employee info
within the cfoutput have another QoQ select departments of current employee from master query
loop through the second QoQ to populate your tooltip

Azadi Saryev

<Prev in Thread] Current Thread [Next in Thread>