| 00:22.52 | *** join/#bzflag R0b0t1 (~Enigma@64-136-219-55.dyn.everestkc.net) |
| 00:22.52 | *** join/#bzflag R0b0t1 (~Enigma@unaffiliated/r0b0t1) |
| 00:24.52 | *** join/#bzflag MindstormsKid (~msk@Wikipedia/MindstormsKid) |
| 01:24.26 | *** join/#bzflag McSpider (~McSpider@xplr-ts-v10-208-114-191-42.barrettxplore.com) |
| 03:10.26 | *** join/#bzflag temporalD (~ATD@bzflag/serverop/TemporalDistraction) |
| 03:15.01 | *** join/#bzflag Anxuiz (~Anxuiz@pool-71-188-251-103.sttlwa.fios.verizon.net) |
| 03:15.01 | *** join/#bzflag Anxuiz (~Anxuiz@unaffiliated/anxuiz) |
| 04:56.56 | *** join/#bzflag sirquine (~quine@c-67-186-15-145.hsd1.pa.comcast.net) |
| 05:17.25 | *** join/#bzflag spldart (~spldart2@bzflag/contributor/spldart) |
| 05:17.25 | *** mode/#bzflag [+v spldart] by ChanServ |
| 05:53.36 | *** join/#bzflag JeffM2501 (~JeffM@unaffiliated/jeffm2501) |
| 05:53.37 | *** mode/#bzflag [+v JeffM2501] by ChanServ |
| 07:12.43 | *** join/#bzflag Marzipan- (~Marzipan@p5B226648.dip.t-dialin.net) |
| 07:14.01 | *** join/#bzflag Marzipan (~Marzipan@bzflag/player/Marzipan) |
| 11:29.34 | *** join/#bzflag Upsetter (~Ups@88.130.174.20) |
| 11:39.59 | *** join/#bzflag nielsle (~nielsle@4135136-cl69.boa.fiberby.dk) |
| 12:46.03 | *** join/#bzflag TASAIRES (~TASAIRES@84.121.178.221.dyn.user.ono.com) |
| 13:45.55 | *** join/#bzflag bier (~bier@p54A5B54A.dip.t-dialin.net) |
| 13:46.38 | *** join/#bzflag bier|tp (~bier@p54A5B54A.dip.t-dialin.net) |
| 14:07.46 | *** join/#bzflag catking00 (ad034932@gateway/web/freenode/ip.173.3.73.50) |
| 14:20.50 | *** join/#bzflag jh` (jh@212-149-233-75.bb.dnainternet.fi) |
| 15:08.36 | *** join/#bzflag R0b0t1 (~Enigma@64-136-219-55.dyn.everestkc.net) |
| 15:08.36 | *** join/#bzflag R0b0t1 (~Enigma@unaffiliated/r0b0t1) |
| 15:15.46 | *** join/#bzflag spldart (~spldart2@c-98-201-129-128.hsd1.tx.comcast.net) |
| 15:15.46 | *** join/#bzflag spldart (~spldart2@bzflag/contributor/spldart) |
| 15:15.46 | *** mode/#bzflag [+v spldart] by ChanServ |
| 15:31.43 | *** join/#bzflag catking00 (ad034932@gateway/web/freenode/ip.173.3.73.50) |
| 16:09.00 | *** join/#bzflag temporalD (~a_temp_di@bzflag/serverop/TemporalDistraction) |
| 16:22.12 | *** join/#bzflag bryjen (~bryjen@63.147.94.149) |
| 16:22.12 | *** mode/#bzflag [+v bryjen] by ChanServ |
| 16:31.24 | *** join/#bzflag TASAIRES (~TASAIRES@84.121.178.221.dyn.user.ono.com) |
| 16:40.44 | *** join/#bzflag sirquine (~quine@c-67-186-15-145.hsd1.pa.comcast.net) |
| 16:58.07 | *** join/#bzflag JefferyM (~JefferyM@67-131-219-56.dia.static.qwest.net) |
| 16:58.07 | *** join/#bzflag JefferyM (~JefferyM@unaffiliated/jeffm2501) |
| 16:58.07 | *** mode/#bzflag [+v JefferyM] by ChanServ |
| 17:17.19 | JefferyM | why does everyone think TSs league site is closed source? |
| 17:20.02 | blast007 | because I think the SVN repo for it is down |
| 17:20.20 | blast007 | last I knew |
| 17:20.52 | JefferyM | I just got source for it |
| 17:20.55 | JefferyM | from the svn repo |
| 17:21.13 | JefferyM | dosn't mean it's closed source, just means the repo goes down every so often |
| 17:21.26 | JefferyM | SF used to go down a lot, didn't make BZ closed source |
| 17:25.10 | blast007 | ah, so it is back up now? |
| 17:25.25 | JefferyM | I just got code from it |
| 17:25.32 | JefferyM | want me to throw it in a google code repo? |
| 17:25.42 | JefferyM | or github? |
| 17:25.46 | JefferyM | then you'll all have a backup |
| 17:26.27 | JefferyM | and it's licensed under the LGPL, so no mater what it's availablity, it's open source :) |
| 17:30.14 | JefferyM | hell I can commit it to bz svn even ;) |
| 17:30.24 | JefferyM | even tho I think that sites like that should be seperate projects |
| 17:31.54 | blast007 | JefferyM: well, I just think he should set it up somewhere properly |
| 17:32.13 | JefferyM | where would be "properly" to you? |
| 17:32.20 | JefferyM | something like google code? |
| 17:33.38 | blast007 | yeah |
| 17:33.42 | blast007 | not on someone's VPS |
| 17:34.04 | blast007 | google code, sourceforge, github, whatever |
| 17:34.04 | JefferyM | so throw it in one and give him co-adminship :) |
| 17:34.26 | blast007 | heh |
| 17:34.31 | blast007 | be nice to not lose history though |
| 17:34.49 | JefferyM | so it'd just need an export from his server? |
| 17:34.56 | blast007 | yeah |
| 17:35.09 | JefferyM | has anyone asked for that or seen if he wants to move it? |
| 17:35.42 | JefferyM | or does the fact that people don't like his coding style prevented that? |
| 17:36.40 | JefferyM | but really if the VPS is stable then a SVN there is just as valid as one other places. |
| 17:36.43 | JefferyM | it's just a URL |
| 17:36.50 | JefferyM | if it's not stable then I understand |
| 17:36.59 | JefferyM | that's where GIT would come in better |
| 17:37.46 | JefferyM | goes back to trying to figure out how to get data from more then one table in a single query |
| 17:39.41 | Murielle | when you will have the solution, we will be happy if you could share it with us |
| 17:40.07 | BulletCatcher | Something like "SELECT w,x,y,z FROM table_a,table_b" ought to do it. |
| 17:40.20 | Murielle | damned!! you so right :) |
| 17:40.42 | *** join/#bzflag alezakos (~kongr45gp@ppp-2-85-50-46.home.otenet.gr) |
| 17:44.18 | *** join/#bzflag smoooth (~smoooth@cpe-098-024-240-002.ec.res.rr.com) |
| 17:44.41 | JefferyM | BulletCatcher, it's a little more complex then that |
| 17:45.08 | JefferyM | I have a table that has a record for a license and it has 2 fields that represent customer IDs |
| 17:45.24 | JefferyM | one for the customer who owns the license and another for who the reseller was |
| 17:45.37 | JefferyM | and then the other table has the customer IDs and the man readable company name |
| 17:46.13 | JefferyM | I want a query that can find license records based on some critiera ( options etc..) but return the man readable name instead of the ID |
| 17:50.14 | *** join/#bzflag catking00 (ad034932@gateway/web/freenode/ip.173.3.73.50) |
| 17:52.32 | *** join/#bzflag alezakos (~kongr45gp@ppp-2-85-50-46.home.otenet.gr) |
| 17:53.41 | BulletCatcher | It sounds like you need to join the tables, but don't have the matchin columns required to do so. |
| 17:54.20 | JefferyM | yeah I need to read up more on join |
| 17:54.56 | Murielle | and "where" |
| 17:54.58 | Murielle | could help |
| 17:56.24 | BulletCatcher | If the customer ID columns in the two tables are compatible then you can join using them: WHERE table_a.cust_id = table_b.cust_id |
| 17:58.52 | JefferyM | ok |
| 17:58.59 | JefferyM | I have never used join before |
| 17:59.16 | BulletCatcher | That WHERE clause will cause an implicit join. |
| 17:59.20 | JefferyM | and yeah all customer IDs are compatable |
| 17:59.22 | JefferyM | ok |
| 18:02.05 | joevano | JefferyM: do you want human readable names for both customer and reseller? |
| 18:05.46 | joevano | select a.cust_num, b.name, a.reseller_num, c.name from sales a, customer b, customer c where a.cust_num =b.cust_num and a.reseller_num = c.cust_num |
| 18:06.34 | joevano | links the human readable name table twice to look up for both in the same query |
| 18:07.57 | JefferyM | joevano, then just do some other ANDs in the where for the rest of my query, like "AND a.option1=1" ? |
| 18:08.12 | joevano | JefferyM: yep |
| 18:08.18 | JefferyM | ok, thanks |
| 18:08.46 | joevano | np... any other questions feel free to ask I work in SQL most days |
| 18:09.36 | JefferyM | heh |
| 18:09.44 | JefferyM | I seem to be working in it full time these days |
| 18:09.49 | JefferyM | at least untill the end of the year |
| 18:10.19 | joevano | you probably figured it out, but the letters after the table names are aliases, and they are not limited to just a single character |
| 18:10.33 | JefferyM | yeah |
| 18:10.38 | joevano | sually it is better to make them actually mean something |
| 18:10.49 | JefferyM | like license_data ;) |
| 18:10.55 | joevano | especially on the difficult queries |
| 18:10.59 | joevano | yep |
| 18:11.41 | JefferyM | the fun part has been adding data verification code to all the sites I've been making, and finding all the bad data our sales and admin deps have been entering |
| 18:11.52 | joevano | and if the table name is descriptive there is no need for them except when linking multiple copies of the same table |
| 18:12.12 | JefferyM | "so... why do 348 licenses have no records in our accounting system?" |
| 18:13.06 | joevano | that's easy.... counterfeits ;-) |
| 18:13.15 | JefferyM | sadly no.. just screwups |
| 18:13.20 | JefferyM | they are valid licenses |
| 18:13.26 | JefferyM | we generated them |
| 18:13.38 | JefferyM | it's just the customerID was screwed up |
| 18:19.45 | *** part/#bzflag kierra (~jolie@unaffiliated/kierra) |
| 18:22.59 | *** join/#bzflag Thumper_ (~Thumper@about/essy/coffeeAddict/Thumper) |
| 18:22.59 | *** mode/#bzflag [+v Thumper_] by ChanServ |
| 18:27.56 | *** join/#bzflag xaver (~xaver@pD9ED79E2.dip.t-dialin.net) |
| 18:38.56 | *** join/#bzflag lodxcol (~lodxcol@unaffiliated/lodxcol) |
| 19:02.12 | *** join/#bzflag Upsetter1 (~Ups@88.130.155.44) |
| 19:04.35 | *** join/#bzflag sirquine (~quine@GARKBIT.WV.CC.CMU.EDU) |
| 19:25.57 | *** join/#bzflag TASAIRES (~TASAIRES@84.121.178.221.dyn.user.ono.com) |
| 20:28.30 | *** part/#bzflag Upsetter1 (~Ups@88.130.155.44) |
| 20:42.04 | *** join/#bzflag sirquine (~quine@GARKBIT.WV.CC.CMU.EDU) |
| 21:00.25 | *** join/#bzflag McYukon (~McYukon@xplr-ts-v10-208-114-191-42.barrettxplore.com) |
| 21:36.36 | *** join/#bzflag Scythio (~Scythio@d53-64-195-246.nap.wideopenwest.com) |
| 22:28.06 | *** join/#bzflag MindstormsKid (~msk@Wikipedia/MindstormsKid) |
| 22:41.10 | *** join/#bzflag Guest600 (ad034932@gateway/web/freenode/ip.173.3.73.50) |
| 22:59.39 | *** join/#bzflag me1 (~ausom@bzflag/player/Me1) |
| 23:21.47 | *** join/#bzflag sirquine (~quine@c-67-186-15-145.hsd1.pa.comcast.net) |
| 23:40.21 | *** join/#bzflag MindstormsKid_ (~msk@Wikipedia/MindstormsKid) |