Stored procedure

Stored procedure

osanmartinosanmartin Posts: 15Questions: 6Answers: 0

Hi, how can I populate datatable from stored procedure....? in other words I need get differents columns from many tables, not neccesary from only one table.

From my php code I call this stored procedure as: "select * from get_myFunction(param1, param2...)"

What I need to change in the example:

/* DB tables to use with necesary joins */
$table = " myTable;

// Table's primary key
$primaryKey = 'tablePrimaryKey';

Thanks in advance...

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 63,761Questions: 1Answers: 10,510 Site admin
    Answer ✓

    Can you not simply use the output from your SELECT statement? If you want to use server-side processing then you would need to modify the demo server-side processing script. It is not currently designed to work with stored procedures.

    Allan

  • osanmartinosanmartin Posts: 15Questions: 6Answers: 0

    Ok....i understand, thanks for your quickly answer...

This discussion has been closed.