So I think I have the where clause setup right now but I can't seem to
get it to work. currently I am using it like so:
db.query("child", new String[] {"_id", "title"}, whereClause, null,
null, null, null);
my where clause looks like so:
String whereClause = "select * from child join association on
association.childid = child._id where association.parentid = 'guid'";
where I replace 'guid' with my passed in guid for the lookup parent
guid.
I think I am doing it wrong since I get a error about a syntax error
near "select". I don't believe I am allowed to use the where in this
location but I can't find a function that will take it.
What should I be using?
On Apr 6, 12:59 pm, "Dan U." <[EMAIL PROTECTED]> wrote:
> I haven't tested this but it should be something like...
>
> select child.* from child join association on child.guid =
> association.child_guid where association.parent_guid = ?
>
> And of course, you should change child.* to be whatever columns you
> need and the ? should be your particular parent guid.
>
> On Apr 6, 10:24 am, SnowDrifter <[EMAIL PROTECTED]> wrote:
>
> > I am trying to figure out how to create a where clause (I think that
> > is what I need) to filter one table with the data from another table.
>
> > I have three tables. One is for "parents" one is for "children" and
> > one is for associations between these two tables. The way I have done
> > this is using GIUD identifiers to identify the parents and children.
> > In the association table I just have GUID pairs to show the
> > association.
>
> > So a parent or child table might look like so:
> > GUID, title, data
>
> > and the association table might look like so:
> > GUID(parent), GUID(child)
>
> > so I want to be able to do a query that does a query against the child
> > table and returns only a cursor of children that are associated with a
> > particular parent.
>
> > I can't seem to find any good tutorials on how to do such a thing.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
Announcing the new M5 SDK!
http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
