RE: [PHP-DB] odbc and inner joins...
| From: | Andrew Hill | Date: | Thu, 05 Jul 2001 19:42:47 +0000 |
| Subject: | RE: [PHP-DB] odbc and inner joins... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10093@lists.php.net to get a copy of this message | ||
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@openlinksw.com 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@weccusa.org]
> Sent: Thursday, July 05, 2001 12:13 PM
> To: php-db@lists.php.net
> 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@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>