| 00:42.14 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 04:44.05 | *** join/#uphpu synic (n=synic@65-103-227-121.slkc.qwest.net) |
| 06:19.00 | *** join/#uphpu bigdog_ut (n=bigdog_u@207.135.132.13) |
| 06:19.00 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 17:23.05 | *** join/#uphpu synic (n=synic@65-103-227-121.slkc.qwest.net) |
| 18:58.09 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 20:03.42 | macnewbold | ~yow |
| 20:47.22 | *** join/#uphpu bigdog_ut (n=bigdog_u@207.135.132.13) |
| 20:47.22 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 20:47.45 | bigdog_ut | whatz up? |
| 20:49.25 | wps | howdy |
| 20:49.35 | *** topic/#uphpu by wps -> Utah PHP Users Group | uphpu.org |
| 20:49.42 | wps | got my birthday present two days early |
| 20:49.51 | bigdog_ut | oh cool..new laptop? |
| 20:50.11 | wps | nope |
| 20:50.13 | wps | camp stove |
| 20:50.13 | wps | http://cabelas.com/cabelas/en/templates/product/standard-item.jsp?_DARGS=/cabelas/en/common/catalog/item-link.jsp_A&_DAV=MainCatcat20075&id=0006318514260a&navCount=17&podId=0006318&parentId=cat20110&navAction=push&catalogCode=IF&rid=&parentType=index&indexId=cat20110&hasJS=true |
| 20:50.21 | bigdog_ut | oh |
| 20:50.42 | macnewbold | nice |
| 20:50.52 | wps | 90,000 BTUs |
| 20:50.54 | wps | oh-yeah |
| 20:50.54 | macnewbold | happy bday |
| 20:50.57 | wps | thanks |
| 20:51.09 | macnewbold | the scouts are going to have a field day with that one |
| 20:51.14 | wps | yup |
| 20:51.26 | macnewbold | I can almost hear a Tim-Taylor-style grunt coming from wps' general direction |
| 20:51.37 | wps | oh-oh-oh |
| 20:52.33 | wps | I fell so empowered that I know how to compile PHP myself now |
| 20:52.37 | wps | :) |
| 20:52.44 | bigdog_ut | lol |
| 20:52.46 | bigdog_ut | nice |
| 20:52.57 | wps | I love bigdog_ut's external file approach |
| 20:53.18 | bigdog_ut | yeah it is easy to do |
| 20:53.30 | wps | I am surprised at how many people sign up for an account on the website but never actually log in… ever |
| 20:53.30 | bigdog_ut | then you have a backup and reference for the last one |
| 20:53.37 | wps | exactly |
| 20:53.50 | wps | every once in a while I purge the accounts of people that have never logged in |
| 20:54.02 | wps | we had 460 accounts before the purge and now only 375 |
| 20:54.09 | bigdog_ut | the cool thing is to then have it in cvs |
| 20:56.51 | bigdog_ut | i tend to always do that with config files |
| 20:57.04 | bigdog_ut | then you can see the changes you make over a time period |
| 21:00.04 | bigdog_ut | everyone have a good thanksgiving? |
| 21:00.11 | wps | I did |
| 21:02.41 | bigdog_ut | i have been lookin over the church's mp3 resources and the id3 tags are so jacked up |
| 21:02.49 | wps | completely |
| 21:02.50 | wps | jack |
| 21:02.53 | wps | jacked |
| 21:03.01 | diskotec|w | was anyone up shopping this morning at 5am? |
| 21:03.08 | wps | I have emailed them several times asking them fix them before posting them |
| 21:03.10 | bigdog_ut | no way |
| 21:03.14 | wps | no way |
| 21:03.20 | diskotec|w | wives? |
| 21:03.24 | diskotec|w | my wife was |
| 21:03.25 | bigdog_ut | shows a lack in quality assurance |
| 21:03.27 | bigdog_ut | nope |
| 21:03.30 | wps | or, if they don't have the time or the desire, to let someone like me do it first |
| 21:03.34 | bigdog_ut | she wanted to sleep |
| 21:03.43 | wps | bigdog_ut, I have all of them with the ID tags fixed/correct if you want a copyu |
| 21:03.48 | diskotec|w | yeah....bed was too warm for me to leave it. |
| 21:03.49 | bigdog_ut | but i was up hangin christmas lights this morning |
| 21:04.04 | bigdog_ut | wps that okay...im doing it now and converting to ogg |
| 21:04.12 | bigdog_ut | im suprised they dont do ogg over mp3 |
| 21:04.31 | diskotec|w | ogg better compression? |
| 21:05.01 | bigdog_ut | compression is variable..where mp3 is not |
| 21:08.52 | diskotec|w | I haven't tried, nor do I have any ogg files to try....does windows media player play ogg files? |
| 21:09.12 | bigdog_ut | if you have the right codec for it...winamp plays them |
| 21:11.14 | bigdog_ut | diskotec|w, it is ogg vorbis is the file compression |
| 21:11.23 | bigdog_ut | they have a website you can check out |
| 21:11.34 | bigdog_ut | but ogg is a variable bit rate instead of a constant |
| 21:11.44 | bigdog_ut | so you still get highs when you need them and lows |
| 21:11.58 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 21:23.03 | diskotec|w | thanks bigdog. I'll check it out. |
| 21:23.59 | bigdog_ut | np |
| 21:24.13 | bigdog_ut | and the license is different is another huge reason |
| 21:25.32 | diskotec|w | what app rips a cd into an ogg format? |
| 21:25.45 | bigdog_ut | on linux there are a few |
| 21:25.49 | bigdog_ut | not sure about windows |
| 21:25.53 | bigdog_ut | there are some though |
| 21:26.13 | bigdog_ut | i just use cygwin on windows and use the linux tools |
| 21:28.03 | diskotec|w | ok...just thought I'd ask. (its not that I don't like to google but it's that I'd rather use something like this on a recommendation than blindly downloading something that might be inferior to something else out there) |
| 21:28.18 | bigdog_ut | np |
| 21:28.26 | bigdog_ut | i use the linux tools on windows |
| 21:28.34 | bigdog_ut | but im sure there are windows gui ones |
| 21:29.51 | diskotec|w | they didn't give you permission to install linux at work yet? or will that be awhile before they consider it. |
| 21:30.13 | bigdog_ut | me? |
| 21:30.28 | diskotec|w | yeah....didn't they give you a windows cd a few months back? |
| 21:30.40 | diskotec|w | tell you to put windows on your box? |
| 21:30.50 | bigdog_ut | yes |
| 21:31.22 | diskotec|w | if I'm not mistaken, you had gentoo running....right? |
| 21:31.28 | bigdog_ut | so i install cygwin for now |
| 21:31.32 | diskotec|w | yeah |
| 21:31.34 | bigdog_ut | that is correct |
| 21:32.58 | *** join/#uphpu dataw0lf (n=stderr@66.219.227.114) |
| 21:47.59 | *** join/#uphpu Utah_Dave (n=boucha@c-24-10-151-252.hsd1.ut.comcast.net) |
| 22:34.44 | diskotec|w | Ryan...are you around? |
| 22:47.58 | bigdog_ut | whatz up diskotec|w ? |
| 23:00.49 | diskotec|w | just have a sql question |
| 23:01.38 | diskotec|w | ryan gave me an example and it made sense when I quickly scanned through it...then when I went over it again, I'm confused again. |
| 23:01.39 | bigdog_ut | shot |
| 23:02.06 | diskotec|w | this is what he said... |
| 23:02.38 | diskotec|w | if you want to show all the PC's that have the same Speed and RAM, you can do: |
| 23:02.39 | diskotec|w | <PROTECTED> |
| 23:03.03 | bigdog_ut | k |
| 23:03.19 | bigdog_ut | that is a self join |
| 23:03.26 | bigdog_ut | whatz the question |
| 23:03.47 | diskotec|w | to me, it seems like the last two .. a.model != b.model and a.model < b.model .... would give a blank result |
| 23:04.08 | diskotec|w | 0 lines returned |
| 23:04.09 | bigdog_ut | technically no |
| 23:04.21 | bigdog_ut | but i would do one or the other |
| 23:04.21 | diskotec|w | or however its worded |
| 23:04.37 | bigdog_ut | != or <> |
| 23:05.35 | diskotec|w | so... a.model != b.model ...would give a result? Thats the part I'm confused on. |
| 23:05.43 | bigdog_ut | yes |
| 23:05.58 | bigdog_ut | cause you dont have all the same models |
| 23:06.09 | bigdog_ut | if you did then it would not return anything |
| 23:06.44 | diskotec|w | isn't PC a and PC b the same information? |
| 23:07.12 | bigdog_ut | not necessarily |
| 23:07.23 | bigdog_ut | it could be at a certain time...but not always |
| 23:08.27 | diskotec|w | I can completely see how the whole statement would make sense if it was different information but I was under the impression that they are the same. |
| 23:08.48 | bigdog_ut | not every row is the same |
| 23:09.23 | bigdog_ut | you are doing a self join so that are talking one row (a) and looking at another row (b) |
| 23:09.34 | bigdog_ut | now they could be the same row or they could not |
| 23:11.42 | bigdog_ut | diskotec|w, does that make sense |
| 23:11.50 | diskotec|w | sorry, I'm just trying to picture this in my head...takes me awhile sometimes if I'm not understanding the whole idea. |
| 23:12.37 | diskotec|w | I'm currently learning about joins and such....so I'm still a newbie on this stuff. |
| 23:13.04 | bigdog_ut | here check this out |
| 23:13.13 | bigdog_ut | http://www.metrokc.gov/gis/kb/Content/SQLTipJoin.htm |
| 23:14.21 | bigdog_ut | which db are you using? |
| 23:14.23 | diskotec|w | I did a trace on a built in report and just trying to read the statement it produces so I can slighly modify it. |
| 23:14.39 | diskotec|w | slightly |
| 23:14.42 | bigdog_ut | whatz the sql and i can show you |
| 23:14.48 | diskotec|w | mssql |
| 23:16.09 | diskotec|w | the one I gave you was an example Ryan gave me...not something I pulled off in a trace. the trace had similar information and the a b and c confused me |
| 23:16.28 | bigdog_ut | those are table aliases |
| 23:17.08 | bigdog_ut | you can alias tables and columns (fields) from rows (records) |
| 23:19.06 | bigdog_ut | does that make sense |
| 23:19.11 | diskotec|w | I'll give that web page a read over and I'll ask you questions if I have any after. (if you don't mind) thanks. |
| 23:19.16 | diskotec|w | yeah |
| 23:19.20 | diskotec|w | kinda |
| 23:19.32 | bigdog_ut | np |
| 23:19.36 | bigdog_ut | just ask away |
| 23:20.01 | bigdog_ut | that webpage is oracle specific so take it with a grain of salt |
| 23:20.08 | bigdog_ut | especially on outer joins |
| 23:23.28 | diskotec|w | real quick, do you know anything about Crystal Reports? If so, is it possible to key in straight sql code to produce a report? |
| 23:23.38 | bigdog_ut | y |
| 23:23.47 | bigdog_ut | and y |
| 23:25.20 | diskotec|w | Well....using Crytal to make the printed output look somewhat nice to a CFO.....if there is another FREE app then I'm all ears...err...eyes. If it is possible, I haven't found where to put it in. |
| 23:26.27 | diskotec|w | It looks like Crystal wants you to put in Crystal functions. |
| 23:27.11 | bigdog_ut | there should be a sql screen that allows you to put in sql straight |
| 23:27.11 | diskotec|w | I'm having a hard time figuring out SQL let alone having to learn and translate into Crystal functions. |
| 23:27.47 | bigdog_ut | crystal is a beast...if your not familiar with sql then crystal will be extremely difficutl |
| 23:28.06 | diskotec|w | ok....I thought I had found that SQL screen but when I keyed in a simple select statement I got an error |
| 23:29.16 | bigdog_ut | what is the error? |
| 23:30.05 | diskotec|w | heh... I did that Wednesday morning, I'd have to go back and rekey it in to find out and get back with you. |
| 23:30.43 | diskotec|w | well...for now, I'll read the web page you gave me |
| 23:31.20 | bigdog_ut | k |
| 23:31.26 | diskotec|w | thanks again |
| 23:31.32 | bigdog_ut | http://www.microsoft.com/technet/technetmag/issues/2005/05/HowITWorksSQLJoins/default.aspx |
| 23:36.53 | diskotec|w | the hospital I work for is going to send me to a t-sql training sometime in the spring....until then I'm sorry for asking newbie questions. I wish they were using an opensource database but I guess since they are paying I'll go. =) |
| 23:37.17 | bigdog_ut | np...ask away...that is how you learn |
| 23:37.40 | bigdog_ut | most dbs are similar in queries...so you are okay |
| 23:40.23 | diskotec|w | thats what it seems like so far to me in my quest for more db knowledge. It seems like where they differ the most is on the back end....like MAYBE stored procs and such. |
| 23:40.39 | bigdog_ut | yeah |
| 23:41.12 | bigdog_ut | most you can do different types of query syntax...but the standard way seems to work across the dbs |
| 23:43.27 | diskotec|w | cool.... I'm off to dinner... I'll be back in a bit. |
| 23:43.34 | bigdog_ut | k |