2. PHPRunner General questions
  3. Using an Stored Procedure to load a list page
This topic is locked

Using an Stored Procedure to load a list page

 		4/18/2024 22:09:34
PHPRunner General questions
A
 asawyer13 authorDevClub member
I already have a table called Files. I have query and it shows the data on the list page.

In this case I want to use a Stored Procedure to load the list data. I can't use a database view.

I tried replacing with a CustomQuery like it's explained here: https://xlinesoft.com/phprunner/docs/how_to_display_data_returned_by_sp.htm

But it seems to ignore it.

Anyway to accomplish this?

Thanks
Alan
A
 		asawyer13 authorDevClub member 4/18/2024

Should I try using a PHPRunner SQL View instead? And do the Stored Procedure that way?

Alan
Davor GeciDevClub member 4/21/2024

Hello asawyer13 I see that you are also in the DevClub.
Watch the webinar called "Building running totals" that was on April 5, 2024.
In this webinar Sergey uses the SQL query and this is what you should also use. I did it for my Stored Procedures in that way also. I also use input parameters in SP and it works.

Davor