Sending arguments to a SP in PHP

From: 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

« previous php.windows (#23058) next »