The SQL LIMIT clause that appears in various places of yii does not appear to be valid for SQL-89 or SQL-92 and furthermore specific to only certain databases like MySQL (correct me if I am wrong). This appears in more places than the database schema for specific databases. Is there a way short of edits to all the yii code to remove the application of this clause?
I have never had problems with this in my life, there is a factory pattern for the database connection so I dont think Its MySQL specific. so why is it you want to change this?
Because I’m using a database that doesn’t support it. LIMIT is not SQL-89 or SQL-92 compliant and not supported in every database. It’s not MySQL specific as there are others that support it but if the code that yii used was SQL89/92 compliant then it wouldn’t be an issue. So in order use yii you need a database that supports it or you have to hack the code.
Don’t know but it doesn’t appear to be in a standard.
I’m using PDO_ODBC and yii crashes.
Apparently not at the present.
That would be nice.
Probably but I don’t have a choice right now. I’m slowly chipping it out of all the sql. Don’t know what that will effect later. I’m sure to find out soon. The plus is that I have PDO_ODBC working!
No there is no way. I’m trying to interface with a legacy app. If I could get it all working under yii at some point then yes I would jump rather quickly. But I need to run the legacy app while developing yii.
No I wrote my own schema but it’s also in db/schema/CDbCommandBuilder.php. I don’t think we should need to touch that if we write a new schema should we?