I have two tables.
I want to query for an entry where want to look for entries which have the
foreign key and the and a count. which doesn not seem to happen when I look to
pass the foreign key and the count.
something like this..
a=Entries.select(Entries.q.aCount==3,Entries.q.alpha==myalpha)
is there somthing otherwise available from sqlobject??
attaching the table structure here.
cheers
Vivek
class Alpha(SQLObject):
alphaname = UnicodeCol(length =
200,unique=True,notNone=True,alternateID=True)
#firstentry = ForeignKey('Entries')
entries = MultipleJoin('Entries')
#firstentry= SingleJoin('Entries.data')
class Entries(SQLObject):
title = UnicodeCol(notNone=True)
data = BLOBCol(length = 1000,notNone=True)
timestamp = DateTimeCol(default=datetime.now)
alpha = ForeignKey('Alpha')
aCount = IntCol(notNone=True)
ident = UnicodeCol(notNone=True)
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
