I am trying to download the trunk from SVN and am getting this message
Error: MKACTIVITY of '/svn/!svn/act/b31d46c1-39f8-164f-
a712-4e3a3dd6a803': 400 Bad Request (http://code.djangoproject.com)
On May 5, 6:19 pm, Ivan Illarionov <[EMAIL PROTECTED]> wrote:
> Hi, Rahein,
>
> The Firebird patch
I am using FB 2 and am planning on going on to 2.1.
Any overly complex queries I will probably hand code, as I am pretty
familiar with pleasing FB's optimizer.
This project won't be ready for production for some time, probably going to
wait for Django to go 1.0 first anyway.
Thanks for all your
Hi, Rahein,
The Firebird patch and backend is against latest Django trunk and
depends on the newest Django features, especially new QuerySet/Query
classes. Please note that there are known bugs with very complex ORM
queries. It's also important to use the latest Firebird (> 2.0).
Earlier
Ahh that must be it, thanks. I am using 0.96.1. I am about to head out for
the day, but I will try it with the current trunk tomorrow.
Thanks for your help Ian.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
On Mon, May 5, 2008 at 1:53 PM, Rahein <[EMAIL PROTECTED]> wrote:
>
> I am really learning the internals of Django.
>
> I changed line 208 in db\models\base.py from:
>
> cursor.execute("SELECT 1 FROM %s WHERE %s=%%s LIMIT 1" % \
>
> to:
>
> cursor.execute("SELECT 1 FROM %s WHERE %s=%%s ROWS
Thanks for the quick reply Tim, see my other posts.
FB is probably the most SQL99 standard SQL DB, so usually the standard
statements work. I think FB 2.1 is going to support all 3 different
limiting syntax. I changed it to work with ROWS.
On May 5, 2:49 pm, Tim Chase <[EMAIL PROTECTED]> wrote:
I am really learning the internals of Django.
I changed line 208 in db\models\base.py from:
cursor.execute("SELECT 1 FROM %s WHERE %s=%%s LIMIT 1" % \
to:
cursor.execute("SELECT 1 FROM %s WHERE %s=%%s ROWS 1" % \
Shouldn't that FB patch have fixed this type of stuff? Did I apply it
wrong?
>> The real problem is when I try to access the database. I get
>> stack trace below. It looks like it is trying to use the
>> LIMIT keyword incorrectly.
As best I can tell, Firebird doesn't support the SELECT ... LIMIT
x OFFSET y" notation, but rather uses "SELECT FIRST x [SKIP y]
..." as
Well I changed \backends\firebird\base.py to print out the SQL
statement, it is:
SELECT 1 FROM "BOOKS_PUBLISHER" WHERE "ID"=%s LIMIT 1
Instead of LIMIT it should says ROWS. Any idea how to fix this?
--~--~-~--~~~---~--~~
You received this message because you
I am trying to get Django working with Firebird as the database
backend. I have done some searching and found kinterbasdb and the
firebird patch to get it to work with Django.
I am trying to follow the free books tutorial, but having problems.
First the creation of the tables in the DB didn't
10 matches
Mail list logo
