[sqlalchemy] Re: execute() is not returning multiple result sets from stored procedure call

2009-05-10 Thread Rodney Haynie
Ah, thank you so much. Yes MySQLDB does support multiple result sets. So off to the raw cursors i go. Michael Bayer wrote: I dont know that MySQLdb (the adapter we use) supports multiple result sets ?you'd have to check its documentation. but in general SQLAlchemy's API doesnt

[sqlalchemy] Basic Search Engine

2009-05-10 Thread Nicholas Dudfield
Greetings, I have been using SQLA for a few months. For admin CRUD index pages I have been using a naive search_keywords function as seen at end of message. Instead of using a primitive shlex.split, which incidentally is not unicode friendly, and one crude search_type (AND|OR) I'd like to use

[sqlalchemy] Re: Basic Search Engine

2009-05-10 Thread Michael Trier
It may not be what you want but have you explored our full text search support through the use of the match operator? On May 10, 2009, at 6:13 AM, Nicholas Dudfield ndudfi...@gmail.com wrote: Greetings, I have been using SQLA for a few months. For admin CRUD index pages I have been

[sqlalchemy] Re: 0.5.3 ORM, MSSQL and FreeTDS: Invalid Cursor State exception?

2009-05-10 Thread Michael Bayer
I love that we're putting this level of thought into the issue. I also hate that the state of MSSQL requires us to put this level of thought into the issue.that said, carry on ! On May 9, 2009, at 4:21 PM, Rick Morrison wrote: There are some differences on what happens then the MS

[sqlalchemy] Re: Basic Search Engine

2009-05-10 Thread Paul McGuire
On May 10, 5:13 am, Nicholas Dudfield ndudfi...@gmail.com wrote: Greetings, I have been using SQLA for a few months. For admin CRUD index pages I have been using a naive search_keywords function as seen at end of message. Instead of using a primitive shlex.split, which incidentally is

[sqlalchemy] Re: Basic Search Engine

2009-05-10 Thread fluence
@Michael No, I'm about as new to sql as I am to sqlalchemy. I'll have to look into it. Thanks @Paul Thanks, I'll look into that. I had found searchparser.py but was just wondering if anyone had already adapted it to work with sqlalchemy querys. On May 11, 8:21 am, Paul McGuire