Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

RE: [PHP-DB] odbc and inner joins... From: Andrew Hill (ahill <email protected>)
Date: 07/05/01

David,

This is most likely related to an issue in the cursor library of PHP that we
are working diligently to resolve.
To assist, could you please:
        1. open a support case at http://www.openlinksw.com/support/suppindx.htm
        2. generate an ODBC trace by adding the following lines to your odbc.ini on
the linux client:
                        DebugFile=/tmp/openlink.out
        3. paste the file into the case or send it to
technical.support <email protected> ATTN:Casenumber

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers

> -----Original Message-----
> From: David W. Jablonski [mailto:dave <email protected>]
> Sent: Thursday, July 05, 2001 12:13 PM
> To: php-db <email protected>
> Subject: [PHP-DB] odbc and inner joins...
>
>
> I'm trying to use odbc_do with a select statement that uses inner joins.
> When I type the Select statement directly into the query window for MSSQL
> 2000 the query runs fine.
>
> I use the same select statement through odbc
> and I get this error: Warning: SQL error: [OpenLink][ODBC][Driver]Syntax
> error or access, SQL state 37000 in SQLExecDirect in
> /home/httpd/site.somewhere/htdocs/file.php on line 32.
>
> This only happens when I add the inner join on my select statement. If I
> don't use a inner join through odbc I can get a connection and a
> recordset returned so my connection works fine. I add the inner join and
> I get the error. The inner join is joining two tables from the same
> database so I'm not even crossing databases.
>
> Here is my select statement: Select Table1.Column1, Table1.Column2 from
> Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID;
>
> If I leave out everything after the INNER JOIN the select statement
> works. Any help would be much appreciated.
>
> PHP 4.0.4/Apache 1.3.14/Openlink ODBC for
> glibc2.1/SQL2000
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>