| 00:25.45 | *** join/#utah JoshH (~josh@firebat.aros.net) |
| 00:32.54 | nerdfred | Nick fixes printers |
| 00:38.58 | nerdfred | bring /msg gul_dukat |
| 00:39.12 | nerdfred | bring /msg gul_dukat so are you doing anything for Halloween? |
| 00:39.28 | gul_dukat | you're not /msg-ing me, you realize that, right? |
| 00:39.36 | gul_dukat | nerdfred: not sure |
| 00:45.31 | nerdfred | where could I buy some cheap glasses for a halloween costume right now. |
| 00:49.23 | Tene | gul_dukat: i have lots of experience, but little experience with fixing them, does that count? |
| 00:49.43 | gul_dukat | Tene: probably not as helpful... :) |
| 01:09.11 | *** part/#utah Mecworks (~marc@208.186.182.174) |
| 01:09.20 | *** join/#utah Mecworks (~marc@208.186.182.174) |
| 01:44.12 | *** join/#utah drewbono (~andrew@c-24-2-90-52.client.comcast.net) |
| 01:50.15 | gul_dukat | dilbert today reminds me of so many people i know |
| 02:02.05 | Nafai | Why's that? |
| 02:22.06 | *** join/#utah tensai (~tensai@zmonkey.org) |
| 02:22.52 | *** join/#utah tensai_ (~tensai@zmonkey.org) |
| 02:50.21 | brailsmt | you spend the first year getting them to talk, and then for the next 17 years they say things that embarrass the crap out of you... |
| 02:53.16 | gul_dukat | hmmmm... this would be a lot easier with pliers |
| 02:53.43 | brailsmt | pulling a tooth? |
| 02:53.51 | gul_dukat | feels like it |
| 02:54.22 | brailsmt | pulling your tongue? |
| 02:55.21 | gul_dukat | performing some "precise" maintenance on my printer |
| 02:59.51 | tensai | you actually decided to rip out the LED? we were just kidding you know. |
| 03:08.43 | gul_dukat | tensai: no... better |
| 03:08.50 | gul_dukat | i've pulled the whole top off the printer |
| 03:08.55 | gul_dukat | and it's actually improved so far |
| 03:28.52 | gul_dukat | hmmm... |
| 03:29.22 | gul_dukat | anyone ever had a printer pull every single piece of paper in the feeder through, and put it out, then complain about it being out of paper... |
| 03:29.31 | gul_dukat | when you were asking it to print a one-page document? |
| 03:29.54 | tensai | yes, when using an incorrect print driver |
| 03:31.20 | gul_dukat | hmm... |
| 03:31.37 | gul_dukat | cuz when i tell it to print the test page, it acts kinda weird, but it prints something out |
| 03:32.08 | gul_dukat | on page after page after page... |
| 03:32.13 | gul_dukat | on different parts of the page... |
| 03:32.21 | gul_dukat | with with different patters of random dots |
| 03:33.15 | gul_dukat | then it misfeeds and prints right onto the bottom of the printer |
| 03:34.07 | gul_dukat | if i wasn't quite as stubborn as i tend to be... i'd have gone with my dad's recommendation (go get a new printer) |
| 03:36.26 | gul_dukat | the other epson drivers that _should_ work with this printer won't |
| 03:36.39 | gul_dukat | they just sit there |
| 03:41.33 | *** join/#utah torriem (~torriem@c-67-164-203-109.client.comcast.net) |
| 04:02.20 | *** join/#utah bonez39 (~aint@166.70.243.110) |
| 04:03.53 | gul_dukat | why would etc-update be trying to update /etc/fstab and /etc/groups ? |
| 04:05.46 | gul_dukat | and /etc/rc.conf |
| 04:06.05 | brailsmt | gul_dukat: its probably pretty safe to ignore those... |
| 04:08.31 | gul_dukat | yeah... |
| 04:08.35 | gul_dukat | but they've come up twice in 2 days |
| 04:20.37 | *** join/#utah scott_ (scott@crackaddict.com) |
| 04:56.36 | *** part/#utah torriem (~torriem@c-67-164-203-109.client.comcast.net) |
| 04:58.08 | balrog | |roulette |
| 04:58.09 | ibot_ | balrog: chamber 1 of 6 => +click+ |
| 04:58.29 | gul_dukat | |roulette |
| 04:58.29 | ibot_ | gul_dukat: chamber 2 of 6 => +click+ |
| 04:59.47 | Maquis | ~kill gul_dukat |
| 04:59.49 | ibot | ACTION shoots a tachyon gun at gul_dukat |
| 05:01.22 | balrog | no fair. you can't come out of costume until monday |
| 05:02.02 | Maquis | one can only pretend to be a dirty cardassian for so long |
| 05:03.36 | balrog | quark |
| 05:03.48 | Maquis | ick... that's almost worse! |
| 05:03.59 | balrog | dax then |
| 05:04.05 | Maquis | hmm... |
| 05:04.30 | Maquis | let's think stargate... |
| 05:04.46 | major_carter | hmm.. |
| 05:04.56 | balrog | or just carter |
| 05:05.16 | major_carter | major carter is the second-coolest character on stargate |
| 05:05.40 | major_carter | beat only by daniel jackson :) |
| 05:06.57 | major_carter | my friend sent me an email with the subject line: "Eat drink and be merry for Monday shall never come" |
| 05:16.06 | *** join/#utah drewbono (~andrew@c-24-2-90-52.client.comcast.net) |
| 05:19.25 | brailsmt | <PROTECTED> |
| 05:30.57 | clark | traceroute |
| 05:53.58 | *** join/#utah linuxalien (~zorb@c-24-2-80-89.client.comcast.net) |
| 05:54.38 | *** join/#utah etahhhh (~etah@c-24-10-167-152.client.comcast.net) |
| 05:54.54 | *** join/#utah rufius (~suifur@suifur.linuxfordummies) |
| 06:00.24 | clark | well that's it. no more ink |
| 06:01.19 | *** join/#utah wps (~wade@208.186.134.102) |
| 06:06.45 | *** join/#utah rufius (~suifur@suifur.linuxfordummies) |
| 06:09.25 | *** part/#utah rufius (~suifur@suifur.linuxfordummies) |
| 06:12.51 | *** join/#utah spiderbiter (~jb@dpc693562074.direcpc.com) |
| 06:23.25 | *** join/#utah linuxalien (~zorb@c-24-2-80-89.client.comcast.net) |
| 06:31.11 | *** join/#utah rufius (~suifur@TopHat.linuxfordummies) |
| 06:55.51 | *** part/#utah Newsome (~sorenson@byu-gw.customer.csolutions.net) |
| 06:58.03 | spiderbiter | anyone have a sec to help with sql? |
| 07:06.44 | major_carter | spiderbiter: sure |
| 07:06.46 | major_carter | if i can |
| 07:06.48 | major_carter | :) |
| 07:06.51 | major_carter | what's the question |
| 07:07.30 | spiderbiter | looking to convert a flat data record into normalized tables |
| 07:07.36 | Maquis | sorry.. had to get out of my "costume" |
| 07:07.40 | spiderbiter | example ... |
| 07:08.05 | spiderbiter | [Table 1] first last DOB sex email_home email_work phone1 phone2 phone3 ... |
| 07:08.18 | spiderbiter | [Table 2] ID first last DOB sex |
| 07:08.28 | spiderbiter | [Table 3] |
| 07:08.33 | spiderbiter | ID email_home home |
| 07:08.40 | spiderbiter | ID email_work work |
| 07:08.44 | spiderbiter | etc. |
| 07:09.04 | Maquis | ok... so, you want to go from table 1 to the rest of the tables? |
| 07:09.14 | spiderbiter | yes, |
| 07:09.23 | spiderbiter | am I looking for insert selcet? |
| 07:10.04 | spiderbiter | table 1 has no id's |
| 07:10.31 | Maquis | this might not be the most efficient solution (or the best solution in any sense), but i think you could do this with a cursor... |
| 07:10.51 | Maquis | if you do insert select, i think you'd have to rely on some luck to hope that the IDs were matched up correctly |
| 07:11.03 | spiderbiter | assign IDs to table 2 and carry them through 3, 4 , 5 .. |
| 07:11.30 | Maquis | are there any duplicates as far as name,etc? |
| 07:12.02 | Maquis | do you have any identity fields in table1? |
| 07:12.03 | spiderbiter | don't thinks so |
| 07:12.18 | spiderbiter | no |
| 07:12.34 | Maquis | that would make things kind of different if you don't have identity fields... because then you'll have to match on multiple fields |
| 07:12.46 | spiderbiter | I imported a CSV |
| 07:13.06 | spiderbiter | but I could create a ID column on T1 |
| 07:13.21 | spiderbiter | then I'd start with what it assigns |
| 07:13.47 | Maquis | it seems to me that the easiest things would be first: id column on T1 or second: doing a cursor... |
| 07:14.06 | spiderbiter | don't know cursor |
| 07:14.51 | Maquis | cursors are slow... but they allow you to iterate through what you select, and work with each row individually.. |
| 07:15.11 | Maquis | i'd recommend seeing if it works with adding an id column (should work).... |
| 07:16.02 | spiderbiter | k |
| 07:16.21 | Maquis | what database? |
| 07:17.14 | spiderbiter | also MySQL docs don't seem to track version compatabilitys as well as php docs |
| 07:17.29 | spiderbiter | mysql |
| 07:17.39 | Maquis | yeah.. i don't know if mysql does cursors... |
| 07:18.01 | Maquis | at work over the summer, i've used m$sql, and that's where i learned my sql |
| 07:18.15 | spiderbiter | ah |
| 07:18.41 | spiderbiter | I assume MySQL 3.23.47 will do insert selects |
| 07:19.43 | Maquis | should... i haven't tried it yet... never have much time for doing my own stuff.. |
| 07:21.03 | spiderbiter | Here's the plan then ... |
| 07:21.05 | spiderbiter | INSERT INTO t2 (ID, first, last, DOB, sex) |
| 07:21.15 | spiderbiter | SELECT ID, first, last, DOB, sex FROM t1 |
| 07:21.53 | Maquis | yeah... |
| 07:22.39 | spiderbiter | the next part would be trickier |
| 07:22.45 | Maquis | why? |
| 07:23.17 | Maquis | insert into t3 (ID, email_home, home) select ID, email_home, home from t1 |
| 07:23.30 | Maquis | right? |
| 07:24.22 | spiderbiter | I would have to do it once for each phone type? |
| 07:24.28 | Maquis | although i guess you might want a "where email_home <> '' and home <> ''" |
| 07:24.50 | Maquis | spiderbiter: what do you mean by that? |
| 07:25.28 | spiderbiter | getting workphone homephone fax pager etc into (ID, number, type) |
| 07:25.33 | Maquis | s/and/or (in the where statement) |
| 07:25.57 | Maquis | you don't want those in different fields? |
| 07:26.10 | spiderbiter | nope |
| 07:26.10 | Maquis | ok... so then you need a select case statement then... |
| 07:26.48 | Maquis | no wait... |
| 07:26.52 | Maquis | select case won't work |
| 07:27.11 | spiderbiter | maybe I should just do once for each type |
| 07:27.33 | spiderbiter | 4 or 5 types |
| 07:27.52 | spiderbiter | minor change between statments |
| 07:27.57 | Maquis | sure... |
| 07:28.03 | Maquis | that would be easier... |
| 07:28.13 | Maquis | i'm assuming you won't be getting these csv files on a regular basis then? |
| 07:28.31 | spiderbiter | no |
| 07:28.36 | Maquis | (where i worked, these types of things would come on a regular basis) |
| 07:28.39 | spiderbiter | maybe |
| 07:28.42 | Maquis | ok... then yeah.. just do it that way... |
| 07:28.47 | spiderbiter | I'll give 'er a try |
| 07:28.51 | spiderbiter | thanks |
| 07:28.54 | Maquis | wait... |
| 07:29.06 | spiderbiter | yeah? |
| 07:29.07 | Maquis | do you want a separate row for each of the phone types? |
| 07:29.19 | spiderbiter | yes |
| 07:29.26 | Maquis | so, if the person has a home phone and a work phone, you want that to be two separate rows? |
| 07:29.29 | Maquis | ok... |
| 07:29.35 | spiderbiter | right |
| 07:29.38 | Maquis | so, then be sure that the ID field is not actually an identity field |
| 07:29.51 | spiderbiter | good point |
| 07:29.53 | Maquis | otherwise you'll have problems |
| 07:30.12 | Maquis | you migh want to stick a key of some sort on number & ID or something |
| 07:30.20 | Maquis | so that you know that you don't end up sticking the same data in twice |
| 07:30.21 | spiderbiter | UID or something! |
| 07:30.28 | Maquis | UID? |
| 07:31.10 | spiderbiter | ID, [user ID], .... |
| 07:31.35 | *** join/#utah drewbono (~andrew@c-24-2-90-52.client.comcast.net) |
| 07:31.35 | Maquis | that would work... but if you do that, be careful of the fact that it's called ID in the other table |
| 07:31.45 | spiderbiter | recordID, userID ... |
| 07:31.47 | spiderbiter | right |
| 07:31.53 | Maquis | and that can get annoying when you have fields that match tables, and arent' the same name |
| 07:31.57 | Maquis | it drove me crazy... |
| 07:32.09 | Maquis | we had history numbers to identify patients at the clinic i worked at |
| 07:32.25 | Maquis | and on some tables, it was listed as HXNum and others it was history... and others were other things |
| 07:32.30 | spiderbiter | maybe I'm bad but my convention is ID is always the record ID |
| 07:32.49 | Maquis | you're the one that's going to have to remember that :) |
| 07:33.07 | spiderbiter | np |
| 07:33.11 | spiderbiter | thanks again |
| 07:33.14 | Maquis | no prob :) |
| 07:33.19 | Maquis | good luck getting it all working |
| 08:01.17 | spiderbiter | CRAP! ..... Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14. |
| 08:08.06 | Maquis | does that mean no insert intos? |
| 08:08.13 | Maquis | that stinks! |
| 08:10.55 | Maquis | wait... |
| 08:10.55 | Maquis | that doesn't mean no insert intos |
| 08:10.55 | Maquis | that means you can't select from tableA into tableA... which would cause problems |
| 08:10.55 | Maquis | but if it's a really poor way to word no insert intos, then i'd suggest saving times by upgrading mysql if you can... and i wish you good luck if you can't... |
| 08:10.59 | Maquis | anyway, it's after 2... and i need sleep |
| 08:10.59 | Maquis | gnight all |
| 08:11.05 | *** join/#utah LinuxGeek (~linuxgeek@dont.bother.me.if.itdontwork.com) |