Forums: [SOLVED] Data from Stored Procedure not shown on List page - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

[SOLVED] Data from Stored Procedure not shown on List page Rate Topic: -----

#1 User is offline   Jarmo 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 5
  • Joined: 27-February 10

Posted 12 January 2018 - 01:59 PM

How can I show data from SQL Server's stored procedure on List page?
I found instructions to do that with PHPRunner, but i didn't manage to do it in ASPRunner.NET.
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15550
  • Joined: 03-February 03

Posted 12 January 2018 - 03:34 PM

Check this:
https://xlinesoft.co...urned_by_sp.htm
Best regards,
Sergey Kornilov
0

#3 User is offline   Jarmo 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 5
  • Joined: 27-February 10

Posted 12 January 2018 - 05:09 PM

Thank you from quick help! I'm getting further now.
I found the correct syntax from help file:

1. Add 'test' table or any other table to the project

2. Add the following code to List page: CustomQuery event:

return DB.Query( "EXEC test_proc" );

3. Add the following code to List page: FetchRecords event:

return rs.fetchAssoc();
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic