ODBC SQL Server Queries with MAX(), ORDER BY and Procedures... don't work?
| From: | Guille -bisho- | Date: | Fri, 14 Jul 2000 13:11:54 +0000 |
| Subject: | ODBC SQL Server Queries with MAX(), ORDER BY and Procedures... don't work? | ||
| Groups: | php.windows php.windows | ||
| Request: | Send a blank email to php-windows+get-1299@lists.php.net to get a copy of this message | ||
Hello.
I'm using PHP 4.0 RC1 in a IIS 4.0 as ISAPI module.
I'm using PHPlib for the queries.
When I do a query like:
SELECT MAX(row)...
SELECT ... ORDER BY
SELECT ... GROUP BY
The query does not retrieve data. Doing it directly to the database with MS
Query or Interdev the query works well.
Also procedures doesn't work well:
declare @nom char(25)
declare @apell char(25)
exec validate '$login', '$password',@nombre=@nom output,@apellidos=@apell
output
select nombre=@nom,apellidos=@apell
It doesn't return nothing. Is asp, the same query works well.
I have used ORDER and so on with PHP & Postgres under linux without problem.
Is this a limitation of the ODBC driver or what is happening here?
Please, answer also to my private email.
Thanks!
--
\|||||||/ Guillermo Pérez Pérez
< o o > - bisho@onirica.com
\ L / - bisho@eurielec.etsit.upm.es
-oOOo-------oOOo-
Onírica: Análisis, diseño e implantación de soluciones informáticas
http://www.onirica.com