Re: Two tables, which did not match?

2002-03-29 Thread Daniel Smith
At 10:55 AM + 3/29/02, DL Neil wrote: >> We can hit: >> a) no collection >> b) a collection that hasn't had any photos moved/uploaded to it yet, >or.. >> c) a collection with one or more photos (the "normal, everything's >fine" case) >Let us know how you get on! Thanks again DL, my first s

Re: Two tables, which did not match?

2002-03-29 Thread Daniel Smith
At 10:55 AM + 3/29/02, DL Neil wrote: >> Scenario: >> - two tables, one for photos, and one for collections >> - zero or more photos can belong to a collection >> - the database may not know the collection_id requested >> (i.e. the user on the browser side did something to request >>

Re: Two tables, which did not match?

2002-03-29 Thread DL Neil
Daniel, > I have a question about determining which case > occurred when there are no matches - using two tables. > > Scenario: > - two tables, one for photos, and one for collections > - zero or more photos can belong to a collection > - the database may not know the collection_id requested >

Two tables, which did not match?

2002-03-28 Thread Daniel Smith
I have a question about determining which case occurred when there are no matches - using two tables. Scenario: - two tables, one for photos, and one for collections - zero or more photos can belong to a collection - the database may not know the collection_id requested (i.e. the user on th