Because it is a string The first variable is a sql statement which is a string the call to the SP is as follows exec limitselect 'select var1, var2, var3 from table1 order by var1',10,100 ----- Original Message ----- From: "Gerardo Rojas" <grojas@xxxxxxxxxxxxxxxx> To: "Harpreet K. Singh" <harpreet@xxxxxxxxxxxxxxx>; <php-windows@xxxxxxxxxxxxx> Sent: Thursday, March 04, 2004 4:00 PM Subject: RE: Sending arguments to a SP in PHP Why do you only have single ticks around the value of $oldquery? -- Gerardo S. Rojas mailto: grojas@xxxxxxxxxxxxxxxx -----Original Message----- From: Harpreet K. Singh [mailto:harpreet@xxxxxxxxxxxxxxx] Sent: Thursday, March 04, 2004 2:56 PM To: php-general@xxxxxxxxxxxxx; php-windows@xxxxxxxxxxxxx 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
