create or replace function Registration_Click(paitent_1 IN character varying,card_no IN character varying,dis_name IN character varying,taluka_name IN character varying,village_name IN character varying,po_name IN character varying,co_name IN character varying,occupation IN character varying,doc_name IN character varying,RefByType_name IN character varying,city_name IN character varying,state_name IN character varying,country_name IN character varying,body_name IN character varying,mob_no IN character varying,opd_id IN character varying,comboboxtitle_title_name IN character varying,comboboxco_title_name IN character varying,name_1 OUT character varying, id_246 OUT character varying,name_2 OUT character varying,max_date_id OUT character varying,max_dis_id OUT character varying,max_taluk_id OUT character varying,max_village_id OUT character varying,max_po_id OUT character varying,max_co_id OUT character varying,max_occupation OUT character varying,max_doc_id OUT character varying,mob_no_o OUT character varying, paitent_2 OUT character varying,id_1918 OUT character varying,f_name OUT character varying,comboboxtitle_title_id OUT character varying, comboboxco_title_id OUT character varying,auth_1 OUT character varying,city_name_o OUT character varying,state_name_o OUT character varying,std_code IN character varying,country_name_o OUT character varying,body_name_o OUT character varying ) AS $body$ declare temp varchar; BEGIN SELECT st_fname into name_1 FROM sc_register WHERE st_patient_id = paitent_1; SELECT st_value into id_246 from sc_setting where st_id =246; SELECT st_fname into name_2 from sc_register where st_pt_cardno = card_no; SELECT MAX(dt_doj) into max_date_id FROM sc_register; IF dis_name <> '' THEN SELECT si_district_id into max_dis_id FROM sc_district where st_districtname = dis_name; if max_dis_id IS NULL THEN SELECT max(si_district_id)into max_dis_id FROM sc_district; INSERT INTO sc_district values(max_dis_id,dis_name); END IF; END IF; IF taluka_name <> '' THEN SELECT si_talukid into max_taluk_id FROM sc_taluk where st_talukname=taluka_name; IF max_taluk_id IS NULL THEN SELECT max(si_talukid) into max_taluk_id FROM sc_taluk; INSERT INTO sc_taluk values(max_taluk_id,taluka_name); END IF; END IF; IF village_name <> '' THEN SELECT si_villageid INTO max_village_id FROM sc_village where st_villagename=village_name;

create or replace FUNCTION Activation2(v_status OUT varchar,v_status1 OUT varchar) returns setof sc_register AS $$ declare begin SELECT st_value into v_status FROM sc_activation_dtls WHERE si_slno = 2; select * from sc_register ; end; $$ LANGUAGE 'plpgsql' VOLATILE aftr writng above plsql functiopn in postgresql pane m getting follwing error function result type must be record because of OUT parameters doest it mean that we cant use output parameter and return statent togather. since my requirement is to get some value of table through output parameters along with records of different table ..in one function only. Thanks

i got image to be displayed but i want only one image to be displayed in division but its dislaying same image on divison multiple times?

thanks for the response but even after inserting an image to my asp.net application m not able to see image on division i did following changes in my code is that correct if not then plz tell where m doing wrong.

Thanks

how to display image on division i have code as follows

but no image is getting displayed on division...wts going wrong please help me out of it.

Thanks for the response but i got it fixed.

how to assign value of the session which is getting from text box with the text of the label on redirected page....i am getting the value of the session but not getting the text of the label along with the session value (which is nothing but text box value that i kept in session) when i redirect to different page....do help me with this issue.

Thank you sir...i got it worked through your solution..but its only working in LAN not in WAN...though i did port forwarding as well n provided my hosting machine ip address, lan port i.e 8023 and wan port i.e 8080 ...then trying to access my application on different machine in same lan by giving ....url as public ip address/www.xyz.com...but its saying web page cant be displayed on different machines.. Please guide me to overcome this issue as well Thanks

can u plz explain me step by step process of doing it? Thanks

How can i redirect a domain name to .aspx page in asp.net..i.e when i type www.test.come..it should redirect me to my xyz.aspx page...i did try with iis 7 but when i type domain name in browser it shows web page not available.How to overcome this issue. Thanks

when writing sql query in aspx file having alias with space I:e select emp_no as " emp no" working fine in database but giving syntax error when i run the same query in .aspx page of asp.net which is code behind file..how to resolve this issue? Thanks

How to write case statment with sql query in code behind file that is file.cs ....please help me out. Thanks

sorry for the inconvenience but did you get my requirement...does my requirement require session concept ...how could i achieve it ..please help. Thanks

thanks for the response now please read my requirement and provide best possible solution...if user is booking any slot then at the time of he booking slot to some specified time which is to be given.. till that time only he could book the slot otherwise session will get expire..and at the time of he booking slot if other user also logged in n booking the same slot that prev user is booking then for new user it should be shown as booked or slot is not available .

is there anyway to activate session on button click ...that means as i click button session should start for specified period of time.not on page load. Thanks

Actually m talking according to the requirement as it happens in any booking site if one user has booked a slot then other user should be seen it as red mark which implies as its booked.at the time of his log in to the sites...in this way session value should be managed automatically for different user ....on the whole how can such requirement be done in asp.net..please help me out of this. Thanks

Thank you..one more doubt can v provide different user different session time out or it will be managed by asp.net itself...since i have a requirement of booking an appointment online in this way how can be session managed for multiple no of users...

Thanks for the response is their any alternate way to retain session time out for each page in asp.net

when am accessing my application starting from login page to three more pages then session timeout resets for each pages...does session timeout reset for each page at the time of navigation from one page to other...if so the how can session time be retained for a single user until he is done with his operation. just for testing i put session timeout to 1 but when m navigating from one page to other time is resetting...i.e for each page it starts from 1 itself ...but i want it to start from the time that it has left in prev page for next page and so on.Please suggest me how could it be done. Thanks

when i am accessing my application in lan ...then its working fine provided that firewall is off..which is not recommended..in this way when i turned on the firewall my application is not running...even after setting an inbound rules to the specific port m not able to access my application...how to fix this issue ..please help me out Thanks