Very is your problem located? Is the string not properly built by php? or is an error genereated when you try to execute the query? -----Original Message----- From: Harpreet K. Singh To: php-general@xxxxxxxxxxxxx; php-windows@xxxxxxxxxxxxx Sent: 2004-03-04 21:55 Subject: Sending arguments to a SP in PHP 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
