| 18:09.33 | *** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 18:09.33 | *** topic/#uphpu is Geek Lunch Next Friday @ Shanghai Cafe @ 12:30p - see website for details | Utah PHP Users | uphpu.org |
| 18:09.34 | *** mode/#UPHPU [+v jbot] by ChanServ |
| 18:09.39 | mindjuju | welcome jbot |
| 18:09.50 | mindjuju | ~lart custom PHP builds |
| 18:09.50 | jbot | takes custom PHP builds to the vet for a "special" visit |
| 18:10.15 | wps | there we go |
| 18:10.32 | synic | ~lart PHP builds |
| 18:10.32 | jbot | shoots PHP builds in the head |
| 18:11.34 | wps | why would you ever build a version of PHP that didn't include all of the functions? |
| 18:12.39 | mgeary | oh |
| 18:12.50 | mgeary | you mean hacking the source code? |
| 18:12.57 | mgeary | i just compile a version that includes the modules i need |
| 18:13.03 | mgeary | i don't mess with the source |
| 18:13.06 | wps | amen |
| 18:13.44 | mgeary | thought you meant custom build vs. from a package management system |
| 18:13.45 | wps | we have had to write custom versions of many functions because they don't exist in our build |
| 18:13.56 | wps | rediculous |
| 18:17.08 | dataw0lf | ridiculous* |
| 18:17.24 | wps | thanks |
| 18:17.28 | *** join/#uphpu bradym (n=bradym@Qst4FC.quinstreet.com) |
| 18:17.28 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 18:21.16 | PoeticIntensity | does anyone know of a good description of the use of 'HAVING' in SQL? |
| 18:21.36 | PoeticIntensity | I believe I have a need to use it for the first time in my life. |
| 18:21.54 | PoeticIntensity | and basically, I want to make sure I know what it means. |
| 18:23.41 | PoeticIntensity | hrm.... |
| 18:23.55 | PoeticIntensity | looks like it's just a "where clause" for a "group by"... |
| 18:24.01 | PoeticIntensity | not what I need. :-\ |
| 18:27.38 | mindjuju | PoeticIntensity - what up? |
| 18:27.44 | mindjuju | i mean with your SQL question |
| 18:27.48 | PoeticIntensity | still processing.... |
| 18:28.02 | mgeary | PoeticIntensity: having processes the results *after* joins and wheres have been applied |
| 18:28.03 | PoeticIntensity | gotta create a mean table...... |
| 18:28.34 | PoeticIntensity | mgeary, according to the postges docs, the "having" clause is a grouped function. |
| 18:28.41 | PoeticIntensity | http://www.postgresql.org/docs/current/static/sql-select.html |
| 18:28.47 | PoeticIntensity | might be different in mysql. |
| 18:29.25 | synic | whoa, ravetrax just got nsfw. |
| 18:29.26 | mgeary | might be, but it's generally only used when you apply a group, but i don't know if it *can't* be used w/o "group" |
| 18:32.08 | PoeticIntensity | docs say if it is used w/o a group, but query is "group-ified". |
| 18:32.09 | PoeticIntensity | anyway. |
| 18:32.18 | PoeticIntensity | uhh... |
| 18:32.22 | PoeticIntensity | lemme rephrase in english. |
| 18:32.24 | PoeticIntensity | (monday) |
| 18:32.42 | PoeticIntensity | if it's used without a group, the query is processed as if it were a group. |
| 18:32.52 | PoeticIntensity | docs explain it pretty well. |
| 18:39.18 | Jacob_Kerr | Hey I have a flat file db that I opened with a notepade and at the very start of the DB there |
| 18:39.24 | Jacob_Kerr | s something that says: dbtype 3.0267 |
| 18:40.06 | Jacob_Kerr | Does that look familiar? |
| 18:41.20 | Jacob_Kerr | if it was MS Access you think my windows vista would recognize it? |
| 18:42.24 | mindjuju | Jacob_Kerr - can't speak about Vista, but i know in XP and below if you don't have MS Access, the comp WON'T recognize |
| 18:42.34 | Jacob_Kerr | k. |
| 18:42.47 | mindjuju | though, you can have programs that use an mdb file without having MS access |
| 18:42.48 | Jacob_Kerr | but it has a .db extension so it's prob not MS Access hu.. |
| 18:42.58 | Jacob_Kerr | it could be a million and one things :( |
| 18:43.40 | Jacob_Kerr | all I know is at the begining of the file it has "dbtype 3.0267" and I can not open it with my SQLite program so I do not think it's SQLite. |
| 18:44.40 | mindjuju | do you know what application created the file? |
| 18:45.47 | Jacob_Kerr | Not yet, but that's prob. where I need to go to find out what kind of database this is eh... |
| 18:46.37 | mindjuju | well, check this out and it might help you narrow - http://filext.com/file-extension/db |
| 18:46.47 | Jacob_Kerr | k, thanx. |
| 18:47.14 | Jacob_Kerr | hehe that's the page I'm on ;) |
| 18:47.22 | mindjuju | oh, too funny |
| 18:47.34 | mindjuju | it's a pretty good site, have used it in the past |
| 18:48.00 | Jacob_Kerr | I got it from a google result. |
| 18:51.32 | PoeticIntensity | ok.... |
| 18:51.38 | PoeticIntensity | I've got a mind-bending SQL question. |
| 18:52.11 | PoeticIntensity | Does a "group-by" affect sub-queries? |
| 18:52.44 | PoeticIntensity | such as "SELECT (sub-query-select) FROM table WHERE where-clause GROUP BY group. |
| 18:52.57 | PoeticIntensity | does the outer group-by have any affect on the sub-query? |
| 18:53.26 | PoeticIntensity | man.... it must be a Monday. |
| 18:56.07 | PoeticIntensity | no doubt. |
| 18:56.18 | PoeticIntensity | it's barely noon and my head is already hurting. |
| 18:56.57 | PoeticIntensity | yup.... |
| 18:57.00 | PoeticIntensity | I just answered my own question. |
| 18:57.04 | PoeticIntensity | and it was the wrong answer. |
| 18:57.07 | PoeticIntensity | dangit. |
| 18:57.30 | PoeticIntensity | the answer is "no, it does not". |
| 18:57.32 | mindjuju | what was the answer, cause I thought no |
| 18:57.38 | mindjuju | yeah |
| 18:57.40 | PoeticIntensity | (beat ya to it) |
| 18:58.17 | PoeticIntensity | ah well... back to the drawing board. |
| 18:58.55 | *** join/#uphpu timinator (n=timothy@c-67-171-118-199.hsd1.ut.comcast.net) |
| 18:59.06 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 18:59.53 | timinator | only if I get a communicator pin |
| 18:59.54 | timinator | :) |
| 19:00.19 | timinator | that means that jbot looks like Worf |
| 19:01.53 | mindjuju | i guess that means thebigdog would be riker |
| 19:02.20 | mindjuju | i don't know about Wesley |
| 19:02.32 | mindjuju | he's kinda smarmy |
| 19:02.34 | WesleyCrusher | mindjuju: too bad, I rock |
| 19:03.28 | WesleyCrusher | mindjuju: http://wilwheaton.typepad.com/ |
| 19:04.17 | timinator | LOL |
| 19:04.29 | QContinuum | ~tunafart in bathroom |
| 19:04.30 | jbot | ACTION eats a week-old tuna sandwich with relish and walks over to in bathroom, leg raised, to let 'em rip. |
| 19:04.37 | timinator | LOL |
| 19:05.01 | timinator | and the lunch whistle blows |
| 19:05.20 | *** part/#uphpu eggyknap (n=jtolley@ip67-88-113-150.z113-88-67.customer.algx.net) |
| 19:06.01 | QContinuum | herlo, you should be Geordi |
| 19:06.17 | WesleyCrusher | herlo isn't WesleyCrusher |
| 19:06.37 | WesleyCrusher | QContinuum: besides, I like my eyes |
| 19:07.07 | QContinuum | yeah, but Geordi isn't smarmy and knows a heck of a lot |
| 19:07.15 | QContinuum | fungus should be data |
| 19:07.21 | WesleyCrusher | http://wilwheaton.typepad.com/wwdnbackup/2007/12/drm-so-stupid-i.html |
| 19:07.34 | WesleyCrusher | WesleyCrusher: I want to punch babies |
| 19:07.55 | fungus | Woot |
| 19:08.01 | QContinuum | k, that brings will wheaton +1 in my book for hating DRM |
| 19:08.23 | herlo | QContinuum: he's a true geek |
| 19:08.38 | QContinuum | yeah, but he's smarmy |
| 19:08.45 | QContinuum | and smug |
| 19:09.16 | QContinuum | Geordi and Data were far better |
| 19:09.36 | SunSparc | ~dict smarmy |
| 19:09.38 | Jacob_Kerr | does the "Aestiva H2O database" sound familiar to anyone? |
| 19:10.05 | QContinuum | heh, yup |
| 19:10.11 | Jacob_Kerr | "H2O's 4GL database" |
| 19:10.21 | SunSparc | Jacob_Kerr: No familiarity here. |
| 19:10.31 | QContinuum | SunSparc - did you ever watch ST : TNG ? |
| 19:10.48 | herlo | you should listen to his podcasts: http://itc.conversationsnetwork.org/shows/detail220.html |
| 19:11.01 | SunSparc | QContinuum: Yes, all of them all the time. |
| 19:11.09 | herlo | QContinuum: if you've never listened to them, you might not think he's so smarmy |
| 19:11.19 | herlo | and smug |
| 19:11.23 | Jacob_Kerr | "Fourth Generation Language" |
| 19:11.23 | herlo | ~dict smug |
| 19:11.29 | herlo | :) |
| 19:11.40 | QContinuum | well, Will i've only seeing on TNG and a couple of times on The ScreenSavers |
| 19:11.47 | QContinuum | but Wesley was smarmy |
| 19:12.17 | QContinuum | er, that made no sense, Will i've seen on the ScreenSavers, he seemed decent enough |
| 19:12.37 | QContinuum | but Wesley was smarmy, sorry, was reading that article he wrote about DRM |
| 19:13.27 | SunSparc | Yeah, the character he played was a kid. Perhaps smarmy was on the script. |
| 19:13.37 | herlo | right |
| 19:15.03 | QContinuum | but Data on the other hand, the only thing that could beat Data in pure thinking power, was Future Data |
| 19:15.19 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 19:15.19 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 19:15.24 | QContinuum | like in the Series Finale when they were trying to figure out how to close the AntiTime hole |
| 19:20.02 | SunSparc | Data rocks! |
| 19:20.15 | QContinuum | v true |
| 19:20.39 | QContinuum | and don't forget he wiped out the Borg Queen in First Contact (best of the star trek movies) |
| 19:20.47 | SunSparc | Brent Spiner on the other hand is a bit of a weirdo |
| 19:21.10 | SunSparc | Perhaps that is why he played Data so well. |
| 19:21.19 | QContinuum | i haven't seen him in anything else but TNG, Independence Day, and heard one of his songs on the "ole yellow eyes" album |
| 19:22.05 | SunSparc | Jacob_Kerr: Why were you asking about H2O's database? |
| 19:22.41 | Jacob_Kerr | Just was hoping I could extract the data from it some how and I do not know the language.. |
| 19:23.22 | Jacob_Kerr | I would love to be able to import the data into a mysql database. |
| 19:23.43 | SunSparc | I would assume you could use SQL on it, if you could interface with it. |
| 19:23.59 | Jacob_Kerr | hmm. |
| 19:24.10 | Jacob_Kerr | Well I bet PHP does not do that hu? |
| 19:24.17 | Jacob_Kerr | can I interface with it via PHP? |
| 19:24.21 | SunSparc | Try checking on #mysql. Could be that someone may know. |
| 19:24.32 | *** join/#uphpu jac_ (n=jac_@66.7.114.125) |
| 19:24.34 | Jacob_Kerr | k, thanx |
| 19:24.38 | SunSparc | np |
| 19:24.44 | jac_ | Hello! |
| 19:25.10 | SunSparc | Uh oh, Jac is here... |
| 19:25.23 | jac_ | what do you mean uh oh?! |
| 19:25.27 | SunSparc | :) |
| 19:25.45 | SunSparc | ? |
| 19:25.47 | jac_ | ;) |
| 19:25.54 | SunSparc | Did I say "uh oh" out loud? |
| 19:26.30 | SunSparc | So I could do this: /me slaps jac_ |
| 19:26.34 | jac_ | no, you didn't, but you typed it |
| 19:26.37 | SunSparc | and you would not mind? |
| 19:26.49 | jac_ | oh, I forgot I was ignoring you, dang |
| 19:26.53 | SunSparc | lol |
| 19:26.59 | QContinuum | Jacob_Kerr - did you see they have some kind of install here for that DB |
| 19:27.06 | QContinuum | http://h2o.aestiva.com/references/free_downloads.html |
| 19:28.44 | Jacob_Kerr | yeah |
| 19:28.58 | QContinuum | it's curious |
| 19:29.15 | QContinuum | suppose to allow for server side interaction with DB without PHP and other sever side lang |
| 19:29.34 | Jacob_Kerr | oh nice.. |
| 19:30.13 | QContinuum | well, curious, not sure about nice yet |
| 19:32.01 | QContinuum | it looks like a half step between HTML and a server side language - http://h2o.aestiva.com/references/products/wp_integration.html |
| 19:32.40 | QContinuum | but where php has advantages is that it is significantly more robust, free, etc |
| 19:34.09 | QContinuum | jacob_kerr - check this out - http://h2o.aestiva.com/references/H2O_family.html |
| 19:34.47 | Jacob_Kerr | Thanx man. |
| 19:35.23 | Jacob_Kerr | I just iinstalled the server with apache on my system :) |
| 19:35.26 | QContinuum | i wonder if their max table record is 99,000 ( 99k ) or 99,000,000 (99,000 k) |
| 19:37.13 | jac_ | I'd assume the latter. |
| 19:37.20 | jac_ | 99k isn't much |
| 19:37.34 | jac_ | and that's for the professional edition |
| 19:37.36 | QContinuum | totally agree |
| 19:37.47 | QContinuum | except did you see the max records for the H20 ver? |
| 19:37.50 | QContinuum | 500 |
| 19:37.57 | thebigdog | hehe |
| 19:38.02 | jac_ | yeah, more along the lines of a trial version |
| 19:38.06 | jac_ | bleh |
| 19:38.42 | QContinuum | sup thebigdog |
| 19:38.50 | thebigdog | not much |
| 19:39.11 | jac_ | oh, yeah, here's the a quote from the text before the tables "The database engine supports data tables of up to 99 million records." |
| 19:39.25 | thebigdog | wow that is it |
| 19:40.42 | synic | heh, qps on our mysql server average = 600 right now. |
| 19:40.49 | synic | it's having a hard time. |
| 19:41.16 | jac_ | wow |
| 19:41.30 | thebigdog | i load tables with 25million records to start them up |
| 19:42.46 | QContinuum | ~thebigdog |
| 19:42.46 | jbot | hmm... thebigdog is the postgreSQL guru, a GWAR groupie, or secretly loves AOL, or a lover of cursors |
| 19:43.03 | QContinuum | yup thebigdog is the SQL guru |
| 19:44.08 | thebigdog | yes |
| 19:44.17 | thebigdog | but man only 99m that is not that many |
| 19:44.40 | thebigdog | too bad ff does not ahve a css debugger |
| 20:12.49 | Jacob_Kerr | I keep trying to join #seo and Xchat keeps putting an extra # on the room "##seo" |
| 20:13.28 | thebigdog | cause that is a forward |
| 20:13.37 | thebigdog | the channel name has 2 ## in it |
| 20:13.50 | thebigdog | so the irc server is forwarding you to the right channel |
| 20:14.00 | thebigdog | man im so tired |
| 20:14.18 | thebigdog | so if i start typing crap then im asleep @ the wheel |
| 20:14.22 | thebigdog | so if i start typing crap then im asleep @ the mouse |
| 20:21.25 | Jacob_Kerr | k, thanx. |
| 20:32.30 | *** join/#uphpu jsmith-teaching (i=jsmith@nat/digium/x-1dd04815c0f403ba) |
| 20:32.30 | *** mode/#UPHPU [+v jsmith-teaching] by ChanServ |
| 20:32.33 | mgeary | hey, someone help me with a rsync command-- |
| 20:33.02 | mgeary | i usually just --exclude things i don't want, but i'm now in a case where it'd be a lot simpler to manual include certain subdirectories |
| 20:33.09 | mgeary | i'm getting hung up on the syntax |
| 20:33.39 | *** join/#uphpu timinator (n=timothy@c-67-171-118-199.hsd1.ut.comcast.net) |
| 20:33.39 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 20:34.18 | thebigdog | rsync --include=pattern |
| 20:34.22 | mgeary | well yeah |
| 20:34.28 | mgeary | here's what i have-- |
| 20:34.33 | synic | or --files-from might be easier |
| 20:35.15 | mgeary | rsync -rave ssh --delete --include="images/*" --exclude="*" user@server.com:/path/to/www/htdocs/ /path/to/httpdocs/ |
| 20:35.28 | mgeary | i know for a fact that there is an image file that should come over |
| 20:35.30 | mgeary | but it's not |
| 20:35.45 | thebigdog | well your excluding everything |
| 20:35.51 | mgeary | i do know that the includes need to come before the excludes |
| 20:35.53 | thebigdog | that might have pres over include |
| 20:36.03 | thebigdog | synic has a great idea |
| 20:36.10 | thebigdog | i would create a file with the files you want |
| 20:36.19 | thebigdog | create it with find and grep and > |
| 20:36.29 | mgeary | ugh |
| 20:36.43 | mgeary | that kind of defeats the purpose |
| 20:36.56 | thebigdog | modify your exclude then i would think |
| 20:38.41 | mgeary | ah HA! |
| 20:38.47 | mgeary | got it |
| 20:39.01 | mgeary | rsync -rave ssh --delete --include="images/" --include="images/*" --exclude="*" user@server.com:/path/to/www/htdocs/ /path/to/httpdocs/ |
| 20:39.09 | mgeary | have to include the directory AND the contents separately |
| 20:43.20 | Jacob_Kerr | man they cuss allot in the #php and #mysql room |
| 20:44.38 | thebigdog | hehe |
| 20:45.31 | synic | they cuss a lot in #* |
| 20:45.41 | synic | except here and #utah |
| 20:45.55 | Jacob_Kerr | LOL |
| 20:46.31 | Jacob_Kerr | I do not blame them this sh#$ makes me want to f%$#@ing cuss to.. |
| 20:46.46 | synic | whoa nelly |
| 20:46.48 | *** join/#uphpu kingsol_ (n=kingsol@64.0.192.139) |
| 20:47.18 | Jacob_Kerr | LOL |
| 20:47.33 | *** part/#uphpu kingsol_ (n=kingsol@64.0.192.139) |
| 20:49.54 | unum | is there a funtion to swan a two dimensional array around |
| 20:50.03 | unum | so that rows become columns and vice versa |
| 20:50.08 | unum | s/swan/swap |
| 20:51.05 | bradym | http://us2.php.net/array_flip |
| 20:52.05 | synic | in #python you can cuss, but you can't say "lol" |
| 20:52.21 | unum | sounds like the python users I know |
| 20:52.32 | unum | bradym: that's not quite what I'm trying to do |
| 20:52.40 | Jacob_Kerr | LOL |
| 20:53.12 | unum | that exchanges keys for values |
| 20:53.45 | bradym | oops.. i managed to miss the "two dimensional" part.. read too fast |
| 21:17.41 | QContinuum | here i go! |
| 21:17.43 | QContinuum | oops! |
| 21:18.17 | thebigdog | hehe |
| 21:24.34 | herlo | Jacob_Kerr: that's the nature of *most* programmers |
| 21:24.44 | herlo | Jacob_Kerr: swearing in other channels, that is |
| 21:24.44 | Jacob_Kerr | hehe |
| 21:27.11 | QContinuum | i'm such a rat |
| 21:27.17 | Jacob_Kerr | Sweet I got that h20 4GL Database I was talking about exported to CVS :) |
| 21:27.56 | QContinuum | i think you mean CSV unless you mean you routed it through a pharmaceutical store |
| 21:28.34 | Jacob_Kerr | Yeah |
| 21:30.38 | herlo | QContinuum: or through a version control system :) |
| 21:30.52 | herlo | which is actually viable |
| 21:31.14 | timinator | hey, how can I call a function by reference? |
| 21:31.24 | timinator | like this: $admin_custom->$_REQUEST["mode"] |
| 21:31.55 | fungus | That might not work due to the array key thing. |
| 21:31.57 | timinator | but that's not really working |
| 21:32.05 | timinator | ah, is that it? |
| 21:32.08 | fungus | but $admin_custom->$mode(); would work |
| 21:32.13 | timinator | how's this: $admin_custom->{$_REQUEST["mode"]} |
| 21:32.27 | fungus | perhaps, but never tried that way. |
| 21:32.48 | timinator | that worked, thx |
| 21:34.15 | fungus | be careful to validate that input. Unless you don't care if they run any of the functions on that object |
| 21:35.34 | thebigdog | if MS doesnt need to worry about security then timinator shouldnt have to worry.... :) |
| 21:35.49 | thebigdog | worry/care |
| 21:37.37 | timinator | LOL |
| 21:38.06 | timinator | they can call any functions on that... that's the point :) |
| 21:40.31 | dataw0lf | what you should do is have everyone who tries to log into an IM system actually log into "I_AM_SO_GAAAAAAAY" or something like that |
| 21:40.34 | dataw0lf | that'd be sweet |
| 21:41.07 | QContinuum | heh |
| 21:41.12 | timinator | LOL |
| 21:41.22 | dataw0lf | just mangle the login packets then let the stream return to normal |
| 21:43.36 | jac_ | are you writing an IM system Tim? |
| 21:43.43 | jac_ | timinator: |
| 21:43.55 | timinator | no, I'm just kidding |
| 21:44.13 | timinator | I've already built an IM system |
| 21:44.16 | timinator | :) |
| 21:44.28 | jac_ | did you replace the one I did? |
| 21:44.32 | jac_ | or just fix it ;) |
| 21:45.01 | timinator | jac_ == jacob? |
| 21:45.05 | jac_ | yuppers |
| 21:45.13 | timinator | no, that's the one I meant |
| 21:45.43 | jac_ | I built a XMPP/Jabber library in actionscript 3 since then :) |
| 21:45.55 | timinator | nice |
| 21:45.58 | jac_ | but the ajax one is cooler |
| 21:46.07 | timinator | ya, fo sho |
| 21:46.22 | jac_ | how's that project going? |
| 21:46.36 | jac_ | haven't had an update in awhile |
| 21:46.42 | timinator | It's alright.... I'm still writing code to pay my bills though :( |
| 21:47.04 | timinator | the lumber market is down in a bad way |
| 21:47.14 | timinator | so, we're holding out till things get better |
| 21:47.26 | timinator | then I'll be IRC'ng from bora bora |
| 21:47.28 | timinator | :) |
| 21:47.28 | jac_ | dang |
| 21:47.36 | jac_ | haha nice |
| 21:47.48 | QContinuum | bora bora, that's where i'm headed |
| 21:48.23 | timinator | no way! |
| 21:48.26 | QContinuum | when i make a billion dollars, that is |
| 21:48.32 | timinator | ah, gotcha |
| 21:48.44 | timinator | won't take a billion for me |
| 21:48.54 | jac_ | just a few million huh? |
| 21:49.05 | timinator | yep |
| 21:49.14 | timinator | that'd be good enough |
| 21:49.18 | *** join/#uphpu kingsol_ (n=kingsol@64.0.193.254) |
| 21:49.28 | timinator | although, it'd be a round trip ticket |
| 21:49.37 | QContinuum | i wonder if they have high speed out there |
| 21:49.42 | timinator | w/ a billion, I would just buy a 1 way |
| 21:49.49 | timinator | dunno |
| 21:50.07 | timinator | it'd have to come by satellite, I'd think |
| 21:50.12 | QContinuum | yeah |
| 21:50.45 | timinator | a client of mine just got married, and had his honeymoon down there |
| 21:50.52 | timinator | for 10 days or so |
| 21:51.23 | timinator | he said it's incredible |
| 21:51.30 | QContinuum | i don't think you ought to have a honeymoon in an exotic place, i think you should go somewhere nice, but not crazy expensive. 5 year anniversary or 10 year, bora bora |
| 21:51.59 | jac_ | I suppose it depends on how much money you have when you get married. |
| 21:52.14 | timinator | I still get grief about not having a Jacuzzi tub in our hotel room |
| 21:52.15 | timinator | :) |
| 21:52.17 | QContinuum | well, not a matter of money, but of likely activities, if you get my drift |
| 21:52.30 | *** part/#uphpu kingsol_ (n=kingsol@64.0.193.254) |
| 21:52.37 | timinator | w/ 10 days, you'll have time for ALL activities |
| 21:53.03 | timinator | :) |
| 21:58.16 | *** join/#uphpu TheDruidXpawX (n=cgoudie@charon.thna.net) |
| 22:05.10 | timinator | gotta go |
| 22:08.02 | *** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com) |
| 22:08.02 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 22:10.03 | thebigdog | timinator and his half days |
| 22:11.33 | QContinuum | lucky guy |
| 22:13.28 | *** join/#uphpu fungus (n=olsonl@2001:5c0:8fff:fffe:0:0:0:1647) |
| 22:13.28 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 22:29.13 | QContinuum | hmmm... europe v bora bora |
| 22:29.28 | unum | so I have two tables with a one to many relationship between them. I want ever entry in the first table(the one) to have an entry in the second table(the many). Right now I have a bunch of entries in the first table with out a corresponding entry in the second table. I have a default value I want to add to the second table for each value in the first table that doesn't already have one. |
| 22:29.36 | unum | is there a way to do this with just an sql query |
| 22:29.42 | unum | or will I need to write a script |
| 22:29.52 | unum | I guess the script is only like 5 lines... |
| 22:30.14 | QContinuum | what database? |
| 22:31.31 | unum | postgres |
| 22:32.38 | QContinuum | http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=27 |
| 22:32.47 | QContinuum | has all kinds of hawt sql code |
| 22:32.51 | QContinuum | yours is on there |
| 22:33.15 | QContinuum | what items are in one table that are not in another |
| 22:33.57 | unum | I had forgotten about select into |
| 22:36.21 | *** part/#uphpu TheDruidXpawX (n=cgoudie@charon.thna.net) |
| 22:54.22 | QContinuum | wow - finally something i can spend my Best Buy gift card on - http://www.bestbuy.com/site/olspage.jsp?skuId=8312471&type=product&id=1174091772696 |
| 22:55.13 | SunSparc | Hmmm, good price. |
| 22:55.41 | QContinuum | yeah, i can get 2 spindles and use up my GC of $15 |
| 22:55.51 | QContinuum | been carrying that thing since Christmas last year |
| 22:57.02 | SunSparc | Or put that money toward the Orange Box |
| 22:57.15 | QContinuum | it's crazy to think that 1 DVD stores 4,700 floppies |
| 22:57.24 | QContinuum | i'd have to have an xbox 360 first |
| 22:57.31 | SunSparc | Or a Mac or a PC |
| 22:57.33 | SunSparc | :) |
| 22:58.07 | SunSparc | It is crazy to think that DVD's do not hold much anymore, comparatively speaking. |
| 22:59.34 | QContinuum | true that, that some games span several DVDs |
| 23:00.04 | QContinuum | fungus! was just going to ask what was the most that people spanned data over floppies |
| 23:00.39 | QContinuum | actually win 95 came on 30+ floppies, if i recall correctly |
| 23:01.01 | fungus | I once tried to backup to 50 floppies once, after win95, but gave up on backing up at that point. |
| 23:01.04 | SunSparc | Yeah, I was just trying to think if I remembered that correctly. |
| 23:01.25 | QContinuum | 50 floppies! |
| 23:02.15 | fungus | Yeah, I think I got to about disk 20 or so, had an error and was forced to start over. |
| 23:02.21 | fungus | Not very fun |
| 23:02.43 | SunSparc | load, 'jumpman', 8, 1 |
| 23:02.45 | SunSparc | run |
| 23:03.18 | QContinuum | k, this is sadistic to the Nth degree - http://www.annoyances.org/exec/forum/win95/1117572971 |
| 23:03.49 | SunSparc | Freak! |
| 23:03.57 | SunSparc | Forget about it. |
| 23:04.50 | QContinuum | yeah, no doubt, i'd pitch the laptop if it were me, heck! my 4 year old has a p3 lap with a DVD drive |
| 23:04.59 | QContinuum | question was from 2 years ago |
| 23:06.59 | QContinuum | hey, didn't they make CDroms that connected via parallel Port? seems like if was going to install win 95 i'd go that way |
| 23:08.09 | SunSparc | Yeah or just use the thing as a paperweight. |
| 23:10.38 | jsmith-teaching | boat anchor! |
| 23:11.05 | herlo | Anvil! |
| 23:11.45 | SunSparc | white elephant gift! |
| 23:11.59 | QContinuum | white elephant gift, that's too funny |
| 23:12.08 | SunSparc | :) |
| 23:13.16 | mgeary | ugh |
| 23:13.37 | mgeary | headphones are pressing new frames into brain....must....resist.... |
| 23:13.43 | SunSparc | Congratulations |
| 23:15.01 | SunSparc | You are going to need a bigger jar |
| 23:38.24 | *** part/#uphpu jac_ (n=jac_@66.7.114.125) |
| 23:40.23 | QContinuum | 10 mile range walkie talkie - uniden - $8 - http://www.unidendirect.com/itemdetail.cfm?item=GMR1035-2&tabid=1 |
| 23:41.44 | mgeary | so, i think i'm going to get my wife a photocopier for christmas |
| 23:41.53 | mgeary | but i don't really want a printer/scanner/copier |
| 23:42.01 | mgeary | 'cause i don't have a place to hook it up to my network |
| 23:42.08 | mgeary | any recommendations? |
| 23:42.25 | jsmith-teaching | mgeary: Many of them now do wireless ;-) |
| 23:42.35 | mgeary | well, that would be find, actually |
| 23:42.36 | fungus | Most PSC's can operate w/o a network. |
| 23:42.44 | fungus | or can do wireless. |
| 23:42.46 | mgeary | fungus: yeah, but then i'm paying for something i'm not using |
| 23:43.02 | fungus | I say go PSC + wifi |
| 23:43.09 | mgeary | can you recommend one? |
| 23:43.25 | mgeary | http://www.costco.com/Browse/Product.aspx?Prodid=11179931&whse=BC&topnav=&browse=&lang=en-US |
| 23:43.26 | fungus | not really. :( |
| 23:43.27 | mgeary | maybe |
| 23:44.11 | fungus | oh, you are looking laser, med-hi end |
| 23:44.27 | mgeary | well, i'm looking sub-$300 |
| 23:44.43 | fungus | I was thinking 100-200 cheapo stuff. |
| 23:44.51 | fungus | I'm a cheap skate. |
| 23:44.54 | mgeary | heh |
| 23:46.07 | QContinuum | laser is the cheapo way to go, if you look at long term |
| 23:46.08 | *** join/#uphpu jsmith-teaching (i=jsmith@nat/digium/x-2084136e49a264f3) |
| 23:46.08 | *** mode/#UPHPU [+v jsmith-teaching] by ChanServ |
| 23:46.12 | mgeary | yeah |
| 23:46.16 | SunSparc | mgeary: what will she/you use it for? Just making copies of things? Scanning photos? |
| 23:46.36 | mgeary | yeah, mostly copying things |
| 23:46.37 | QContinuum | i've literally stopped counting after 6 reams through my current toner, have replaced once |
| 23:46.53 | QContinuum | you can't get near that on ink jet |
| 23:47.18 | mgeary | wouldn't touch ink jet |
| 23:47.28 | QContinuum | has gone a loooooonnnnnnnng way |
| 23:47.33 | mgeary | that Canon looks good, but it doesn't have wifi |
| 23:48.01 | QContinuum | i was just looking at the canon you listed, that's not a bad price for that |
| 23:48.07 | QContinuum | and I like canon |
| 23:48.07 | mgeary | yeah |
| 23:51.04 | SunSparc | But it is InkJet |
| 23:51.20 | SunSparc | Depends on your needs |
| 23:55.15 | mgeary | i've never tried to use a scanner over a network. anyone done that? |
| 23:55.24 | mgeary | or do they generally only scan via USB? |
| 23:55.42 | QContinuum | our company network does that |
| 23:55.47 | mgeary | hmm |
| 23:56.02 | QContinuum | you give it an ftp address or network user/pss and it saves it where teh UNC points |
| 23:56.59 | mgeary | so, given that this Canon doesn't have wifi, and i'm on an Apple Airport at home, can anyone recommend a setup that lets me put this copier in the basement and access it via wifi? |
| 23:57.23 | QContinuum | for color printing, we bought the canon i9000 a while ago and really enjoyed it, then Sams v Costco got into their digital print wars and I stored the i9000 until the war is over |
| 23:57.26 | SunSparc | Plug it into the back of the AirPort |
| 23:57.38 | QContinuum | but in the mean time, you can beat the price per print from Costco or Sams |
| 23:57.39 | mgeary | can't plug it into the Airport, have another printer there |
| 23:57.54 | SunSparc | Do you have the AirPort Extreme? |
| 23:58.03 | SunSparc | The square one? |
| 23:58.15 | mgeary | no, just the base station |
| 23:58.24 | SunSparc | The round one? |
| 23:58.25 | mgeary | i could get an Extreme, i suppose |
| 23:58.28 | mgeary | yeah, the cone |
| 23:58.32 | mgeary | rounded cone |
| 23:58.36 | fungus | Don't all/most Airports have USB ports for printers. |
| 23:58.40 | SunSparc | Ah, yeah, the cone only handles one printer |
| 23:59.25 | SunSparc | The new AirPorts have one USB port but you can put a hub on it. I have two usb drives and a printer on my AirPort. |