Hi everyone,
First of all, I would like to thank the community for their help.
I have been working with APEX since a few months (December) ago, since then it has captivated most of my attention, because of what can be done with it…
This time I would like to ask for your advice about some new topics (tool tip and VCF or saving contacts) in regard to APEX, I created a calendar application –works as it meant to be- but now got some question to which I have not yet found an answer, (I have already looked on some online info).
1). Regarding to tool tip: as I mentioned before I have created a calendar application, and on it I am linking the events (specifically on calendar region) on it to some other pages, in the link that leads to the page I have put this:
select '<a title="TGB SCHEDUL" href="f?p=&APP_ID.:5:' || :APP_SESSION || '::::P5_ID: ' || ID || '">' || EVENT_NAME|| '</a>
' EVENT_NAME, START_DATE
from APP_TGB
This script does what it is meant to do link to a specific page. As I understand tool tip, if I want some message I have to place the comments on the title=''#COMMENTS#'' as I am using mozilla, as you can see I have a phrase and I would like to adjust it to every event in particular, I thought in using bind variables, so I look in google about how to create it, found how to... but no where to apply.
2). In concern to the VCF, I saw an example and tried to adjust it to my needs, but apparently I have done something inappropriate.
DECLARE CURSOR member_cur IS
SELECT id, quarter_fy08, kind_of_campaign, event_name, owner, partner, associationcollaboration, location, presales, marketing, chanel_manager, territory_manager, start_date, end_date, list, emailing, telemk, status, source_code_omo, attendees, leads, opps, budget, pipe_estimado, objetives, comments
FROM app_tgb
WHERE id = (
SELECT ' f?p=&APP_ID.:5: '||:APP_SESSION||'::::P5_id: '||id||' '
FROM APP_TGB
)
BEGIN
htp.init; -- wipe out the buffer
owa_util.MIME_HEADER('text/x-vcard; method=request');
for member_rec in member_cur loop
--Get the member information
htp.print('BEGIN:VCARD');
htp.print('VERSION:3.0');
htp.print('Event Details:');
htp.print('Event ID (consecutive number):' || member_rec.id);
htp.print('Quarter FY:' || member_rec.quarter_fy08 || ';;Event Name:' || member_rec.event_name ||';;Kind of Campaign:' || member_rec.kind_of_campaign);
htp.print('Start date:' || member_rec.start_date ||';;End date:' || member_rec.end_date ||';;Location:' || member_rec.location);
htp.print('Partner:' || member_rec.partner ||';;Association/Collaboration:' || member_rec.associationcollaboration);
htp.print('Owner:' || member_rec.owner ||';;Marketing:' || member_rec.marketing ||';;Presales:' || member_rec.presales);
htp.print('Chanel Manager:' || member_rec.chanel_manager ||';;Territory Manager:' || member_rec.territory_manager);
htp.print('Call for Entries:');
htp.print('List:' || member_rec.list ||';;Emailing:' || member_rec.emailing ||';;Telemk:' || member_rec.telemk);
htp.print('Event status:');
htp.print('Status:' || member_rec.status ||';;Emailing:' || member_rec.emailing ||';;Source Code (OMO):' || member_rec.source_code_omo);
htp.print('Investment & Results:');
htp.print('Attendees:' || member_rec.attendees ||';;Leads:' || member_rec.leads ||';;Opps:' || member_rec.opps);
htp.print('Budget:' || member_rec.Budget ||';;Pipe Estimado:' || member_rec.pipe_estimado ||';;Objetives:' || member_rec.objetives);
htp.print('Comments:');
htp.print('Comments:' || member_rec.comments);
htp.print('REV:20050707T234724');
htp.print('END:VCARD');
end loop;
END;
3). Referring to user groups, I have read on chapter 8, that creating groups I will be able to restrict access to various parts of an application, so I did create them and applied them but once again something happens.
2346861
What I am trying to do with the users, is to restrict their access to specific pages, so for example let's say that I do have these pages.
Start, calendar, insertion, update and report, on the start page I have a link to the insertion page, that I want it to be accessed just by those users who have some privileges (which I understand can be done with groups, to manage who can access to a page and who can not.), and to allow other user to go around to the allowed areas.
I do appreciate any kind of help or guidance.
Best regards,
Jaison José González Chaux