Joachim,
Are you using OpenLink drivers?
If so, please verify if you can run the query using the OpenLinkODBC SDK
sample "odbctest" application. If you can, then this issue is specific to
PHP. Please trace this from the $ODBCINI file via
[ODBC]
Debugfile=/tmp/odbc.out
You can reply with the output of this. Please reply to
[EMAIL PROTECTED]
Best regards,
--
Stephen Schadt
Technical Support Consultant
OpenLink Software
http://www.openlinksw.com
"Joachim Schade" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> I use PHP 4.0.6 with iODBC and Apache 1.3.20 on a Linux System to connect
a
> MS SQL-Server Database on a Windows NT 4 System.
> For example, the query "SELECT * FROM test" works successfully. But when I
> try to add a ORDER BY clause in this statement like "SELECT * FROM test
> ORDER BY name" the result ist always only 1 row although there are more
rows
> in the table.
> As the ORDER BY problem when I add a DISTINCT in the statement it dosn't
> works too.
>
> Who can help me?
>
> Thanks Joachim
>
>
>
--
PHP Database 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]
