First of all replace GO with RETURN(0) ....
Then try again....
>-----Original Message-----
>From: Hugo Alexandre Almeida Soares Dias [mailto:[EMAIL PROTECTED]]
>Sent: Friday, April 20, 2001 7:22 PM
>To: PHP-WIN
>Subject: [PHP-WIN] Problem with procedures in MSSQL
>
>
>
>I created a stored procedure in MSSQL like this:
>CREATE PROCEDURE destaques_relacionados @codigo_doc int, @relacao
>varchar(20) AS
>SELECT TOP 5 DN.cod, DN.titulo
>FROM dbo.Keywords_associacoes KA INNER JOIN
> dbo.Destaques_noticias DN ON
>KA.documento = DN.cod
>INNER JOIN
> dbo.Associacoes A ON KA.associacao = A.cod
>WHERE (KA.keyword IN
> (SELECT keyword
> FROM keywords_associacoes ka2,
>associacoes a2
> WHERE ka2.documento = @codigo_doc AND
>ka2.associacao = a2.cod AND a2.tabela = @relacao)) AND (KA.documento !=
>@codigo_doc) AND (A.tabela = 'Destaques')
>GROUP BY KA.documento, DN.data, DN.cod, DN.titulo
>ORDER BY COUNT(KA.keyword) DESC, DN.data DESC
>GO
>
>This procedure when i execute it in the SQL Analyzer runs
>instantaniously,
>but in PHP hangs till timeout.
>can anyone tell me what i must do to solve my problem?
>
>
>
>
>Hugo Alexandre Dias
>Eng. Sistemas Informática
>[EMAIL PROTECTED]
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail:
>[EMAIL PROTECTED]
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
