On Wed, May 10, 2006 at 12:32:53AM +0300, Gambit wrote:
> Hey Sandro,
>
> My understanding is, the from_obj isn't necessary here. Regardless, though,
> it works fine with it (or without it) as the resulting query isn't
> substantially changed. Adding the missing comma from the sample code and
> fixing the print statement so that it iterates through the 'R.mail' property
> gives me the correct values for 1419. What build are you using?
> -G
I was using 1413, now I updated to 1431.
My result is as follows:
[2006-05-09 23:57:16,334] [engine]: SELECT user_tbl.user_last_name AS
user_tbl_user_last_name, mail_tbl_9859.user_id AS mail_tbl_9859_user_id,
mail_tbl_9859.mail_address AS mail_tbl_9859_mail_address, user_tbl.user_id
AS user_tbl_user_id, user_tbl.user_name AS user_tbl_user_name FROM mail_tbl,
user_tbl LEFT OUTER JOIN mail_tbl AS mail_tbl_9859 ON user_tbl.user_id =
mail_tbl_9859.user_id WHERE user_tbl.user_id = mail_tbl.user_id AND
mail_tbl.mail_address LIKE ?
[2006-05-09 23:57:16,334] [engine]: ['%a%']
Sam [EMAIL PROTECTED]
Ted [EMAIL PROTECTED]
Ted [EMAIL PROTECTED]
As you can see [EMAIL PROTECTED] is not filtered throught
mail_tbl.mail_address LIKE 'a'
If you put more rows, you'll also see the doubled rows.
sandro
*:-)
--
Sandro Dentella *:-)
e-mail: [EMAIL PROTECTED]
http://www.tksql.org TkSQL Home page - My GPL work
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
