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: [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
