i want to create a form in apex 4.2 against oracle database 11g R2, internet explorer 9.
i have 2 tables.
create table students (student_id number primary key, student_name varcahr2(50)); create table pictures (pic_id number primary key, student_id number references students(student_id) not null, pic blob not null) ;
i want to create a single form where all the studnet infromation could be entered including the picture.
for the picture i need to have an image place holder, when i click on the image place holder, the file browse dialog should open.
i could do it in developer suite 10g.
but for apex, i don't know how to do it?
as there any example exists which could i follow?
i want to upload an image which i take from access employees entry page as for example. how could i upload image here? the image icon is disables above.
it is provided in the packeged applications?
what is the name fo the sample database application please?
i know the mimtype etc, i will include them, but problem is how to get together both the tables in one entry form?
i want o show you an image which i have on my desktop. how could i share it with you here in the forum?
just a final query,
kindly make me understnd the query behind the report
select p.product_id, p.product_name, p.product_description, p.category, decode(p.product_avail, 'Y','Yes','N','No') product_avail, p.list_price, (select sum(quantity) from demo_order_items where product_id = p.product_id) units, (select sum(quantity * p.list_price) from demo_order_items where product_id = p.product_id) sales, (select count(o.customer_id) from demo_orders o, demo_order_items t where o.order_id = t.order_id and t.product_id = p.product_id group by p.product_id) customers, (select max(o.order_timestamp) od from demo_orders o, demo_order_items i where o.order_id = i.order_id and i.product_id = p.product_id) last_date_sold, p.product_id img, apex_util.prepare_url('f?p='||:app_id||':6:'||:app_session||'::::P6_PRODUCT_ID,P6_BRANCH:'||p.product_id||','||3) icon_link, decode(nvl(dbms_lob.getlength(p.product_image),0),0,null, '<img style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '|| 'src="'|| apex_util.get_blob_file_src('P6_PRODUCT_IMAGE',p.product_id)|| '" height="75" width="75" alt="Product Image" title="Product Image" />') detail_img, decode(nvl(dbms_lob.getlength(p.product_image),0),0,null, apex_util.get_blob_file_src('P6_PRODUCT_IMAGE',p.product_id)) detail_img_no_style, tags from demo_product_info p
i stop understanding from line 12.
could you kindly explaint these lines for me?
from 12th line you should write follow for your report as follow
apex_util.prepare_url('f?p='||:app_id||':page_id:'||:app_session||'::::PX_PIC_ID,PX_BRANCH(i.e used to branch from form page):'||PIC_ID||','||3) icon_link,
'<img style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '||
'" height="75" width="75" alt="PIC" title="PIC" />')
is query to display student pic in report
i will do as you guide,
and i am really searching for words to properly thank you.
i cant put the example right now on apex.oracle.com becuase the it is in my personal laptop which is in my room,
but i got a very better idea from your help.
all i have is just to study thoroughly the sample database application's page and report, and the book you has given the refernece.
i am planning to give my ocp final paper in the coming next days since i receive the confirmation email.
thank you so much paars.