Hi,
I have an application page that shows Store details. A store can have many sections: Apparels, Kitchen, Stationery, Accessories etc. but not necessarily all.
Now I am displaying the data like: <BR>
Store Name: BestProducts@Hand <BR>
City: Delhi <BR>
Sections:
Apparels,
Kitchen,
Stationery <BR>
<BR>
section_types are links to other corresponding pages showing a snapshot of that section. On mouse hover these section_types you get a section_description like in case of Apparels you get 'Shirts, Pants, Suits, Skirts, Kidswear'.
I want that if there is no section_descrioption present the mouse should not turn into a Hand symbol. An underlined section_types means a link to another page. <BR>
I have used the below function for this: <BR>
create or replace function link_hover(id number) return varchar2 is <BR>
cursor c1 is select section,section_type,section_description
from store_sections where store_id=id; <BR>
a_rec c1%rowtype;<BR>
v_results varchar2(4000):=NULL;<BR>
begin<BR>
for a_rec in c1<BR>
LOOP<BR>
IF v_results is null then<BR>
v_results:='
'||a_rec.section_type||'';
ELSE <BR>
v_results:=v_results||',
'||a_rec.section_type||''; <BR>
END IF; <BR>
END LOOP;<BR>
return v_results;<BR>
end;<BR>
<BR>
Any help would be appreciated.<BR>
Thanks,<BR>
Priyanka