yah or that.

more than one way to do it !  crap, cancel the project !

On Dec 31, 2005, at 1:38 AM, Robert Leftwich wrote:

Jonathan Ellis wrote:
How can I tell select about an SQLEngine for performing queries not bound to
a table?  I'd like to write something like
from sqlalchemy import *
engine = create_engine(...)
timestamp = select([func.now()], engine=engine).scalar()

Not sure if it's exactly what you need but you can use execute() directly on the engine:

timestamp = engine.execute('select now()', {}).fetchone()[0]

Robert



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to