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" <[EMAIL PROTECTED]> To: "Harpreet K. Singh" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 04, 2004 4:00 PM Subject: RE: [PHP-WIN] Sending arguments to a SP in PHP Why do you only have single ticks around the value of $oldquery? -- Gerardo S. Rojas mailto: [EMAIL PROTECTED] -----Original Message----- From: Harpreet K. Singh [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 2:56 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-WIN] 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
