[sqlalchemy] Query problem with chars acute or grave

2007-12-07 Thread Expo
I'am using SA 0.3.11 with MySql 5.0 through MySQLdb latest stable version and I don't get results when searching string with chars acute or grave like è, é, à. I haven't found flags on SA or MySQLdb for support exotic chars, I have miss something ?

[sqlalchemy] Re: Connecting to a Microsoft Access Database

2007-10-17 Thread Expo
On Oct 16, 11:13 pm, Eddie [EMAIL PROTECTED] wrote: Having problems all day connecting and tried various apps just in case... is there anyway I could get someone to zip and host this really quick? Error * PROPFIND request failed on '/sqlalchemy/trunk' PROPFIND of '/ sqlalchemy/trunk':

[sqlalchemy] Check object existence into a session

2007-10-17 Thread Expo
How I can chek if a orm class is in a session ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group,

[sqlalchemy] Re: Connecting to a Microsoft Access Database

2007-10-13 Thread Expo
On Oct 13, 2:13 am, Eddie [EMAIL PROTECTED] wrote: engine = create_engine('mssql://VMCPDB', echo=True) I think thi line is the error. Like previous post you should use access:// URI not tested: engine = create_engine('access://VMCPDB', echo=True)

[sqlalchemy] Field with constant

2007-07-03 Thread Expo
If I would make a select with a field set to a constant like this: SELECT 1 AS field FROM foo how is the select()'s field definition ? I'v tried with: select([1], from_obj=[foo]) but field has no name. --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] Re: Problem on autoload with MS-SQL

2007-06-01 Thread Expo
Patch applied now and wokr like is expected. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this

[sqlalchemy] Copy Select object

2007-06-01 Thread Expo
What is the best way for create a clone of Select object except for columns list ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] Re: Sqlalchemy and py2exe...

2007-05-30 Thread Expo
On 29 Mag, 18:07, pdamoc [EMAIL PROTECTED] wrote: Hello, I've tried packing an app I've made with py2exe and run into trouble... first it was an EGG issue, I've fixed that installing everything as a directory next came the sqlite issue... I simply cannot get it to work after I build

[sqlalchemy] Problem on autoload with MS-SQL

2007-05-29 Thread Expo
With this code I get an error first time I autoload a table: from sqlalchemy import * import pydobc engine = create_engine('mssql://user:[EMAIL PROTECTED]/db', module=pyodbc) meta = BoundMetaData(engine) Table('table_x', meta, autoload=True) # Get error first time Table('table_x', meta,

[sqlalchemy] Remove columns from Select object

2007-05-15 Thread Expo
I have a sqlalchemy.sql.Select object where I want to remove some columns and execute the result. I've tried with remove method of columns property but when execute() is called the ResultProxy contains all the original columns. Is the right way to remove columns or exist another method ?