Thanks for the explanation. I got it now. This is one more example
that the "S"
in SQL was never meant to stand for "Standard" :-)...
Ben
On Nov 9, 1:39 pm, jason kirtland <[EMAIL PROTECTED]> wrote:
> Bruza wrote:
> > By using "%s", does
> MysqlDB uses "format" style bind parameters, i.e. "%s". if youd like
> SQLAlchemy to convert ":c1" to an appropriate bind param for MySQL,
> use c.execute(text('select * from t_test where c1=:c1'), {'c1':1}).
>
> On Nov 9, 2007,
This is driving me nuts... The very very simple SQL query below using
":parameter"
always gives me syntax error. However, the same query using constant
'1' then it
works fine. I hope this is not because some stupid mistake I made at
4:00 AM...
Can anybody help?
Thanks,
Ben
>>> c.execute('selec
y I can configure my current SA (version
0.4.0)?
Thanks again,
Ben
On Nov 2, 7:21 am, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On Nov 2, 2007, at 12:41 AM, Bruza wrote:
>
>
>
> > I am quite baffled by the "deferred loading" behavior on a class
> > member
I am quite baffled by the "deferred loading" behavior on a class
member in the following code (see below). Looks like if I create an
object (t1) with some field (c2) having None as value, then after I
save, commit, and closed the object in a SQLAlchemy session, I cannot
update the c2 field. It wil