RE: [PHP-WIN] Sending arguments to a SP in PHP

All morons who answer on this, make sure you send your bloody reply to either the guy who asked the question in the first place or to the PHP list - and NOT to me.... //Anders - sick tired of all private "help". On Fri, 2004-03-05 at 09:48, Svensson, B.A.T. (HKG) wrote: > 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@lists.php.net; php-windows@lists.php.net > Sent: 2004-03-04 21:55 > 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