Re: Sending arguments to a SP in PHP

is it you result set that is getting trimmed or the actual query? "B.A.T. Svensson" <B.A.T.Svensson@lumc.nl> wrote in message news:D291F33C586C8E48B95C26F8C805513A01A3D984@mail5.lumc.nl... > 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