#mysql

30 December 2007

Total 14 pages. You are browsing page 14/14.

First :: Prev :: [...] [10] [11] [12] [13] [14] :: Next :: Last

23:47 <****> javaJake: I try to identify the event that has a unique character. In my case, it was a class event. it had a class subject, a location, a teacher, a date/time. I desinged my tables to match that.
23:47 <****> Ah, I see
23:48 <****> I have more than one teacher, and more than one times. :)
23:48 <****> Oh, and teachers teach more than one thing
23:48 <****> all normal, still listen to what threnody says
23:48 <****> javaJake: but each teaching event has a location, a date/time, a subject and one (or more) teachers.
23:49 <****> I see, so you're storing all the information from each side of the relation in one table?
23:49 <****> Or a lot anyway
23:51 <****> javaJake: then I can query all the classes taught by a teacher within a date range. etc
23:51 <****> Yea
23:51 <****> javaJake: or outside a date range
23:53 <****> http://pastebin.ca/839253 anyone think they can give me a hand, for some reason I can't get the logic through my head right now, I'm just being a dumb dumb right now.
23:53 <****> actually, let me modify this example, one bit
23:54 <****> http://pastebin.ca/839254
23:54 <****> there we go.
23:56 <****> threnody, I like the idea, but unfortunately it's a little too late in the development process for that. :(
23:56 <****> I'm just about ready to be done with the last revision of this small project, so.
23:57 <****> javaJake: I understand. try the NOT IN (your subquery) and see if that leads to something.
23:57 <****> threnody, just about to work, just need to figure out the NOT NULL bit...
23:57 <****> Question, Examples, etc are in pastebin ^
23:59 <****> threnody, my idea works! Woohoo! XD
--- Log closed Mon Dec 31 00:00:01 2007

Total 14 pages. You are browsing page 14/14.

First :: Prev :: [...] [10] [11] [12] [13] [14] :: Next :: Last