[sqlalchemy] scalar() works with outerjoin()?

2015-02-01 Thread Dennis
Does scalar() work with outerjoin()?

I have an outerjoin sql statement that will only return 1 row.
I used scalar(), but then I could not get the column values of the 2nd 
table.

I fixed it, but just wondering if scalar() and outerjoin() are not to be 
mixed in the same sql statement?

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.


Re: [sqlalchemy] scalar() works with outerjoin()?

2015-02-01 Thread Dennis Fogg
oh, I found the function:  first()
which seems to work fine with joined queries.

On Mon, Feb 2, 2015 at 12:21 AM, Dennis dennisf...@gmail.com wrote:

 Does scalar() work with outerjoin()?

 I have an outerjoin sql statement that will only return 1 row.
 I used scalar(), but then I could not get the column values of the 2nd
 table.

 I fixed it, but just wondering if scalar() and outerjoin() are not to be
 mixed in the same sql statement?

 --
 You received this message because you are subscribed to a topic in the
 Google Groups sqlalchemy group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/sqlalchemy/si-gRQnxPWk/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 sqlalchemy+unsubscr...@googlegroups.com.
 To post to this group, send email to sqlalchemy@googlegroups.com.
 Visit this group at http://groups.google.com/group/sqlalchemy.
 For more options, visit https://groups.google.com/d/optout.


-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.