PSP help [message #280474] |
Tue, 13 November 2007 16:00 |
quakeworld2007@gmail.com
Messages: 9 Registered: October 2007
|
Junior Member |
|
|
I am having trouble with this part of my psp
<%FOR list_row IN (SELECT first_name, last_name, position, staff_no FROM staff) LOOP
staff_id := staff_rental(list_row.staff_no);%>
I am getting an error that the identifier staff_id must be declared.
Staff_rental is a function that counts the # of rentals that each employee has and it works correctly when I test it in sql developer.
My question is how do I declare it in a psp.
[Updated on: Tue, 13 November 2007 16:02] Report message to a moderator
|
|
|
|
|