db->get(’entries’) producing SELECT * FROM (entries) which causes an error 42000 on SQL Server 2005

db->get(‘entries’) producing SELECT * FROM (entries) which causes an error 42000 on SQL Server 2005

Posted: 05 May 2009 12:47 PM

[ Ignore ]

Summer Student

Total Posts: 2

Joined 05-05-2009

I’m using an ODBC database connection on a Mac to an SQL Server 2005 machine. I’m using the demo blog example from the video.

A Database Error Occurred
Error Number: 42000

[FreeTDS][SQL Server]Incorrect syntax near ‘)’.

SELECT * FROM (entries)

When I try run that select statement directly in my SQL Server machine it complains about the parenthesis as well. It needs to be:

SELECT * FROM entries

Thanks in advance for any redirection/advice if this is user configurable or something.

Profile

cwt137

Posted: 05 May 2009 03:15 PM

[ Ignore ] [ # 1 ]

Grad Student

Total Posts: 63

Joined 01-18-2009

you don’t need the parenthesis

Profile

mal

Posted: 06 May 2009 09:59 AM

[ Ignore ] [ # 2 ]

Summer Student

Total Posts: 2

Joined 05-05-2009

I know, they are automatically added - that query is autogenerated - how do I get rid of them?

Profile

cwt137

Posted: 06 May 2009 12:33 PM

[ Ignore ] [ # 3 ]

Grad Student

Total Posts: 63

Joined 01-18-2009

please post your code so we can see what’s wrong.

Profile

AquilaX

Posted: 30 June 2009 01:48 PM

[ Ignore ] [ # 4 ]

Summer Student

Total Posts: 1

Joined 06-30-2009

The bug is in db/drivers/odbc/odbc_driver.php

function _from_tables($tables)
    {
        if ( ! is_array($tables))
        {
            $tables = array($tables);
        }
        
        return '('.implode(', ', $tables).')';
    } 

The brackets should be configurable, I think, because the tables are enclosed in different characters for different databases.

Profile

‹‹ Missing param in User Guide Random database error ››

Username		Remember Me?
Password		forgot password?

Post Marker Legend
	New posts	Hot Topic with new posts	New Poll	Moved Topic	Sticky topic
	No new posts	Hot Topic with no new posts	Old Poll	Closed Topic	Announcements

Visitor Statistics
The most visitors ever was 819, on March 11, 2010 11:15 AM
Total Registered Members:	120533	Total Logged-in Users:	30
Total Topics:	126595	Total Anonymous Users:	5
Total Replies:	665538	Total Guests:	405
Total Posts:	792133