Sending arguments to a SP in PHP
| From: | Harpreet K. Singh | Date: | Thu, 04 Mar 2004 20:55:45 +0000 |
| Subject: | Sending arguments to a SP in PHP | ||
| References: | 1 | Groups: | php.general php.windows |
| Request: | Send a blank email to php-windows+get-23058@lists.php.net to get a copy of this message | ||
I am using PHP and sql server 2000.
I have a stored procedure which takes 3 arguments. The first argument is a
string and the rest 2 are integers.
For some reasons the call to the stored procedure is being trimmed.
My call is as follows
$oldquery="select var1,var2,var3,var4..... from table order by var1";
$query="exec limitselect '". $oldquery ."',". $limit .",".
$offset;
i try to print the sql command
echo "<br>".$query;
It prints out a trimmed string
exec limitselect 'select origin
is theri a limit to what one can send to a sp call
Please help i am totally confused.
Thanks