Is the echo you show after the string being generated or within the funcion ? Try it (if you haven't already) immediately after the generation. Maybe there is something wrong with the other strings envolved, or with the syntax itself (you don't show the entire command). If it is not, don't bother with the function... Another thing : > 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 What you say is echoed does not (apparently) correspond to the generation. Were does the word "origin" come from ? The string $oldquery does not contain it, as far as you show. Luis ----- Original Message ----- From: "Svensson, B.A.T. (HKG)" <B.A.T.Svensson@xxxxxxx> To: "'Harpreet K. Singh '" <harpreet@xxxxxxxxxxxxxxx>; <php-general@xxxxxxxxxxxxx>; <php-windows@xxxxxxxxxxxxx> Sent: Friday, March 05, 2004 8:48 AM Subject: RE: Sending arguments to a SP in PHP > 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@xxxxxxxxxxxxx; php-windows@xxxxxxxxxxxxx > Sent: 2004-03-04 21:55 > 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
