Yes Mike, thanks for the link. Am I to understand that SA does not
figure out whether to quote the placeholder based on the type of the
data?
I was hoping if the data supplied was a string, that it would quote
the data.
On Mar 1, 3:30 pm, "Michael Bayer" <[EMAIL PROTECTED]> wrote:
> text("select * from usersearches where searchschedule=:dayno",
> engine=myengine).execute(dayno=5) ?
>
> that would be here:
>
> http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_textual_textua...
>
> On Mar 1, 10:20 am, "metaperl" <[EMAIL PROTECTED]> wrote:
>
> > This would seem to be an easy obvious task, but searching both this
> > newsgroup and the SQLAlchemy.org website do not turn up any docs on
> > the process.
>
> > I want to get a result proxy for executing this SQL, in the processing
> > binding the variable dayno to searchSchedule:
>
> > def load(sa, dayno):
> > """take SQLALCHEMY_OBJECT and a day_number and return
> > a RESULT_PROXY consisting of all records satisfying query"""
>
> > sql = """
> > SELECT
> > *
> > FROM
> > UserSearches
> > WHERE
> > searchSchedule = ?
> > """
>
> > === call to create my SA object ===
>
> > from sqlalchemy import *
>
> > class sa(object):
>
> > def __init__(self, ip="4.12.18.4", db="DATA", engine_echo=True):
>
> > url = 'mssql://perl2:[EMAIL PROTECTED]:1433/%s' % (ip, db)
> > print "Connection url", url
> > self.engine = create_engine(url)
> > self.engine.echo=engine_echo
> > self.metadata = BoundMetaData(self.engine)
--~--~---------~--~----~------------~-------~--~----~
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, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
