is it you result set that is getting trimmed or the actual query?
"B.A.T. Svensson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED]; [EMAIL PROTECTED] > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
