i want to store the output of a query say select EMPLID from Job;the output of this column should be stored in a variable. how it can be done?

psft1017

 Profile Answers by psft1017 Questions by psft1017

• Nov 12th, 2008

You can use SQLExec to do the same.SQLExec("SELECT EMPLID FROM JOB",&Emplid);The value of EMPLID gets stored in the variable &Emplid.

Answer Question  Select Best Answer

As in when we open job page, we find advanced search page instead of normal search page. how to do that

Girish

• Sep 25th, 2011

There is a setting available in Component properties to make either the Normal Search Page or the Advanced search page to appear first.

Answer Question  Select Best Answer

All popular http servers (reverse proxies) are supported. Please refer to the platforms database onCustomer Connection for specific information on current certified platforms. You may find this athttp://www.peoplesoft.com/corp/en/iou/platforms/index.asp

Ariraj

• Nov 6th, 2006

Web logic and IBM Web server

Answer Question  Select Best Answer

One of the core values of the PeopleTools development group is investment protection. The time,money and resources that you may have already invested in licensing another web server, trainingdevelopers and administrators, building and deploying other web applications will not becompromised by this decision.How is this accomplished

Ariraj

• Nov 6th, 2006

Could be please tell what you mean by (other corporate web servers and tools)

Answer Question  Select Best Answer

peoplesoftfriendly

• Apr 26th, 2006

1. Include all the roles in a project by clicking on Insert -> Definitions into Project -> select Roles and add them into the project. Migrate the project to another database. 2. Create a datamover script to migrate roles from PSROLEDEFN table.

Answer Question  Select Best Answer

sriramkammisetty

• Oct 10th, 2006

Steps are listed belowCreate a record ,              Page ,            &nbs...

Answer Question  Select Best Answer

Rahul

• Jul 16th, 2011

Well .. Component variables can be used to carry data from one section to another. The scope of component variable remains throughout the program . They can be used in place of state record provided you do not want a restart facility and dynamic section calls.

Answer Question  Select Best Answer