| 00:24.48 | *** join/#asterisk-doc MikeJ__ (n=ircatjer@adsl-69-209-167-100.dsl.sfldmi.ameritech.net) |
| 00:49.01 | *** join/#asterisk-doc MikeJ[Laptop] (n=ircatjer@adsl-69-209-167-100.dsl.sfldmi.ameritech.net) |
| 01:17.07 | *** join/#asterisk-doc MikeJ[Laptop] (n=ircatjer@d14-69-8-30.try.wideopenwest.com) |
| 02:27.55 | *** join/#asterisk-doc MikeJ[Laptop] (n=ircatjer@d14-69-8-30.try.wideopenwest.com) |
| 09:46.03 | *** join/#asterisk-doc asteriskDOTbz (n=logger@pbxtech.com) |
| 13:19.16 | *** join/#asterisk-doc MikeJ[Laptop] (n=ircatjer@mi.origenfinancial.com) |
| 13:51.16 | *** join/#asterisk-doc blitzrage (n=blitzrag@asterisk/documenteur-extraordinaire/blitzrage) |
| 13:51.16 | *** mode/#asterisk-doc [+o blitzrage] by ChanServ |
| 14:58.06 | *** join/#asterisk-doc jsmith (n=jsmith@64.0.192.254) |
| 14:58.06 | *** mode/#asterisk-doc [+o jsmith] by ChanServ |
| 16:24.55 | blitzrage | jsmith: you sent me info? I don't think I ever saw it... |
| 16:31.22 | blitzrage | DB table creation question: I have multiple phone numbers (DIDs). I need to create a table which allows me to assign multiple users to a single DID, and have multiple DIDs... I can't seem to picture how that table would look like... |
| 16:58.50 | jsmith | Three tables |
| 16:59.02 | jsmith | table one: People |
| 16:59.07 | jsmith | table two: DIDs. |
| 16:59.31 | jsmith | table three: a JOIN table -- it would only have two columns... the person_id and the did_id. |
| 16:59.50 | jsmith | Then you could do JOINs to find your information, like this: |
| 17:00.17 | blitzrage | LOL!!!! |
| 17:00.40 | blitzrage | I can't believe I asked that question 10 mins ago and NOW like 5 people tell me the same thing at the same time :) |
| 17:01.19 | jsmith | SELECT person_id, person_name, did_id, did_number FROM people LEFT JOIN people_to_DID ON people.person_id = people_to_DID.person_id LEFT JOIN did ON did.did_id = people_to_DID.did_id; |
| 17:01.43 | blitzrage | gah! :) |
| 17:01.50 | blitzrage | thx Jared - you're the man :) |
| 17:04.47 | jsmith | What? You are proclaiming your love for the Local channel? Gah.... |
| 17:05.14 | blitzrage | the Local channel is awesome |
| 17:05.22 | jsmith | Does it actually work now? |
| 17:05.23 | blitzrage | I don't even need macro's anymore :) |
| 17:05.26 | blitzrage | seems to |
| 17:05.28 | jsmith | Last time I tried it, it was so buggy... |
| 17:06.01 | blitzrage | yah, seems to work pretty good now for me |
| 17:06.10 | blitzrage | huh? |
| 17:06.19 | jsmith | Didn't you kill bugbot? |
| 17:06.26 | blitzrage | nope - let me look at his logs |
| 17:06.34 | blitzrage | why would I ever kill it on purpose? |
| 17:06.54 | blitzrage | gah! the screen session doesn't exist |
| 17:07.44 | *** join/#asterisk-doc bugbot (n=bugbot@CPE0050babe0330-CM00122570228c.cpe.net.cable.rogers.com) |
| 17:08.22 | blitzrage | heh |
| 17:19.12 | blitzrage | person_id and person_name go in one table, and did_id and did_number go into another table, right? |
| 17:19.21 | blitzrage | hence the "person" and "did" at the beginning |
| 17:21.30 | jsmith | Exactly. |
| 17:21.45 | blitzrage | you select 4 fields FROM person though.... |
| 17:21.46 | jsmith | And the third table has a list of person_ids and did_ids. |
| 17:21.53 | jsmith | Fine, whatever... |
| 17:22.25 | jsmith | Select as many or as few columns as you want. |
| 17:22.39 | jsmith | The secret is to JOIN the three tables together to get the data you want. |
| 17:22.42 | blitzrage | so: SELECT person_id, person_name FROM people AND did_id, did_number FROM dids ? |
| 17:23.00 | jsmith | No. |
| 17:23.11 | jsmith | Here, let me do it this way: |
| 17:24.21 | jsmith | SELECT P.person_id, P.person_name FROM people as P LEFT JOIN people_to_dids AS PD ON P.person_id = PD.person_id LEFT JOIN dids AS D on D.did_id = PD.did_id; |
| 17:25.39 | jsmith | You select all the people (and their associated columns), and JOIN that to the "people_to_dids" table, making sure the two people_id columns match. Then you take that and join it to the did table, making sure the did_ids match. |
| 17:27.31 | blitzrage | once I get my head around this and totally understand it, it'll make more sense :) |
| 17:27.42 | jsmith | Hold on, I'll send you a quick tutorial. |
| 17:27.46 | blitzrage | schweeeet |
| 17:27.54 | blitzrage | I found this one: http://www.w3schools.com/sql/sql_join.asp |
| 17:28.03 | jsmith | http://www.w3schools.com/sql/sql_join.asp |
| 17:32.09 | blitzrage | lol |
| 17:32.12 | blitzrage | awesome :D |
| 17:47.47 | jsmith | Their example on the RIGHT JOIN sucks, so be sure to read the explanation closely. |
| 17:48.14 | blitzrage | yah, the LEFT JOIN looks like what I need... |
| 17:48.39 | jsmith | Yup... |
| 17:48.53 | jsmith | Hence the reason I used LEFT JOIN in my killer SQL statement. |
| 17:51.58 | blitzrage | implemented* |
| 20:12.27 | blitzrage | jsmith: if I do an UPDATE with values which don't exist, I'm going to get an error right? |
| 20:12.40 | jsmith | No. |
| 20:12.52 | blitzrage | it'll just do an INSERT for me? |
| 20:13.01 | jsmith | No. |
| 20:13.10 | blitzrage | darn |
| 20:13.28 | jsmith | If you say UPDATE foo SET bar="baz" WHERE foobar="foobaz" |
| 20:13.41 | jsmith | And you don't have any foobars in the foo table with the value of foobaz. |
| 20:13.45 | blitzrage | because I have a blank table - I want to check to see if certain values exist, and if they do, UPDATE, if not, INSERT them |
| 20:13.51 | jsmith | It will simply return. |
| 20:13.56 | blitzrage | ah gotcha |
| 20:13.58 | jsmith | REPLACE INTO |
| 20:14.03 | jsmith | it's your friend. |
| 20:16.05 | blitzrage | hrmmm... *googles* |
| 20:16.46 | blitzrage | oh... is REPLACE INTO MySQL specific? |
| 20:26.18 | blitzrage | hrmmmm... seems there an EXISTS() |
| 20:34.02 | jsmith | REPLACE INTO very well could by MySQUEAL specific |
| 20:34.14 | blitzrage | thats what I've seen so far |
| 20:34.31 | blitzrage | I think I'm going to do a SELECT and see if it returns any rows, and if it does, then UPDATE, else, INSERT |
| 20:35.07 | jsmith | That's the typical way. |
| 23:58.33 | *** join/#asterisk-doc MikeJ[Laptop] (n=ircatjer@d14-69-8-30.try.wideopenwest.com) |