00:01.31 | *** join/#uphpu bigdog_ut (n=bigdog@208.177.146.102.ptr.us.xo.net) |
00:01.31 | *** mode/#UPHPU [+o bigdog_ut] by ChanServ |
00:09.34 | Utah_Dave | cool |
00:15.20 | *** join/#uphpu brasto (n=brasto@71-32-234-54.slkc.qwest.net) |
00:24.28 | *** join/#uphpu jnbek (n=jnbek@c-24-10-178-17.hsd1.ut.comcast.net) |
00:26.36 | *** join/#uphpu herlo (n=herlo@67.151.4.130) |
00:26.47 | herlo | Utah_Dave: so what's up? |
00:27.01 | herlo | Utah_Dave: sorry about the disconnect, crappy internet at hotels... |
00:44.59 | Utah_Dave | that's ok. Just working a little late today |
00:45.01 | Utah_Dave | how's NJ? |
00:45.59 | herlo | ahh, it's alright. |
00:46.13 | herlo | been enjoying training this week... |
00:49.36 | Utah_Dave | cool. I spent half the day choosing hardware for a couple of new servers. It's been a lot of fun |
00:50.49 | herlo | oh yeah, like what? |
01:01.53 | Utah_Dave | we're getting a great external SATA raid. Probably about 2 terabytes or so of hard drive space |
01:01.53 | Utah_Dave | then we're getting 2 servers |
01:01.53 | Utah_Dave | probably going with 2 dual core Xeons w/8 gigs of ram |
01:01.53 | Utah_Dave | each |
01:01.54 | herlo | is this for work? |
01:01.54 | Utah_Dave | yeah |
01:01.54 | Utah_Dave | one will be a production server and the other will be a development server. |
01:01.54 | herlo | oh good. I thought your personal servers were going to blow away my home 2TB setup... |
01:01.54 | Utah_Dave | :) I wish |
01:01.55 | Utah_Dave | herlo: I've spent a few hours looking over the code for Bamboo Invoice this week. It uses codeigniter and it helped a lot to understand how the whole framework works |
01:01.55 | herlo | cool... |
01:01.55 | *** part/#uphpu brasto (n=brasto@71-32-234-54.slkc.qwest.net) |
01:05.49 | *** join/#uphpu atoponce (i=aaron@gateway/gpg-tor/key-0xFC04088F) |
01:34.11 | *** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
02:14.34 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
02:18.29 | *** part/#uphpu herlo (n=herlo@67.151.4.130) |
04:17.45 | *** join/#uphpu burnin (n=burnin@42dbe40a.dsl.aros.net) |
04:39.56 | atoponce | next meet on the 19th? |
06:55.22 | wps | yes, atoponce |
07:51.03 | *** join/#uphpu RyanE (i=Piadas@rberick.dsl.xmission.com) |
12:03.51 | *** join/#uphpu atoponce (i=aaron@gateway/gpg-tor/key-0xFC04088F) |
12:51.15 | *** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
13:06.54 | *** join/#uphpu atoponce (i=aaron@gateway/gpg-tor/key-0xFC04088F) |
14:00.38 | *** join/#uphpu brasto (n=brasto@71-32-234-54.slkc.qwest.net) |
14:00.50 | *** part/#uphpu brasto (n=brasto@71-32-234-54.slkc.qwest.net) |
14:21.32 | *** join/#uphpu brasto (n=brasto@71-32-234-54.slkc.qwest.net) |
14:21.46 | *** part/#uphpu brasto (n=brasto@71-32-234-54.slkc.qwest.net) |
14:25.44 | atoponce | wps: what time and where? i couldn't find it on the site |
14:42.03 | *** join/#uphpu mindjuju (n=Administ@65-121-75-195.dia.static.qwest.net) |
14:42.50 | mindjuju | macnewbold |
14:48.47 | macnewbold | mindjuju: good morning! |
14:48.53 | mindjuju | hey, cool |
14:49.11 | mindjuju | you said digg the page before 9a, i'mg going to do it right now |
14:49.18 | macnewbold | sweetness |
14:49.19 | mindjuju | coolio? |
14:49.31 | mindjuju | here is the URL -- http://www.foronceandforall.com/2006/10/02/gradefix-students-dream-come-true/ |
14:50.00 | macnewbold | yes |
14:50.09 | macnewbold | that looks like the one |
14:53.11 | wps | atoponce, there is a link to the calendar feed on the meetings page |
15:01.30 | atoponce | is that the address of the meet in draper? |
15:02.09 | wps | yes |
15:03.01 | atoponce | cool. for a while, i was thinking utah valley. glad i won't be driving that far... :-)ยป |
15:08.07 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
15:10.34 | *** join/#uphpu terminator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
15:11.07 | mindjuju | hi person formerly known as timothy_, who up until this morning was known as timinator |
15:11.27 | terminator | ~hi mindjuju |
15:11.29 | jbot | Many greetings, mindjuju, most strange traveller, to this IRCdom of plenty. |
15:12.53 | timinator | brb |
15:12.59 | *** part/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
15:14.42 | *** join/#uphpu macnewbold (n=mac@69.2.248.251) |
15:14.42 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
15:16.06 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
15:16.47 | timinator | there we go -- timinator |
15:17.14 | timinator | and now the dutchman won't get his panties in a bunch |
15:17.17 | macnewbold | sweet - any digg users in here? http://digg.com/software/Free_web_based_app_launched_for_students_Gradefix_the_student_organizer |
15:17.34 | timinator | yes, mac.... already dugg |
15:17.44 | macnewbold | sweet, thanks! |
15:17.58 | macnewbold | I was #2 to digg it, and I guess the poster counts as #1, right? |
15:18.08 | timinator | wait, that's a new one... |
15:18.15 | macnewbold | yes |
15:18.15 | timinator | reading |
15:18.57 | timinator | I'm #3 |
15:19.04 | rabidSmurf | the name almost connotes some sort of hacking :) |
15:19.27 | macnewbold | yeah, good for grabbing attention :) |
15:19.34 | macnewbold | but it is 100% legal |
15:19.36 | macnewbold | guaranteed |
15:20.41 | rabidSmurf | I know |
15:20.48 | rabidSmurf | just hassling you |
15:21.47 | macnewbold | no, it's good |
15:21.54 | macnewbold | if it grabs attention, that's a good thing |
15:22.16 | rabidSmurf | I just want to know why it was released *after* I graduated... :) |
15:22.29 | mindjuju | yeah, true that |
15:22.30 | macnewbold | yeah, no kidding |
15:22.55 | mindjuju | well, i was thinking about going back in the spring to finish and get my bachelors |
15:23.38 | rabidSmurf | I actually get to read whatever books I want to now :) |
15:24.18 | mindjuju | what is your degree in rabidSmurf, who up until recently was known as _psychic_ ? |
15:24.27 | macnewbold | ah, no kidding? |
15:24.32 | macnewbold | well, then hi, rabidSmurf :) |
15:24.39 | rabidSmurf | BS, Information Technology |
15:24.51 | rabidSmurf | minor in Philosophy :) |
15:25.09 | mindjuju | i'm a poli sci major |
15:25.14 | rabidSmurf | sweet |
15:25.15 | macnewbold | I'm sorry? |
15:25.16 | rabidSmurf | where at? |
15:25.54 | mindjuju | well, i'm not going back to my original university in Virgina, but I'm likely to go to the U |
15:26.12 | rabidSmurf | poly sci was probably better in Virginia |
15:26.20 | mindjuju | was going to SVC |
15:26.37 | rabidSmurf | Is that the church school out there? |
15:26.45 | rabidSmurf | (sorta) |
15:26.48 | mindjuju | love poli sci, that's why dataw0lf and I always got into political arguments |
15:26.52 | mindjuju | yup, that the one |
15:27.05 | mindjuju | went there for 3 years |
15:27.18 | mindjuju | well 2 years and 1 year study abroad in Dalian, China |
15:27.28 | rabidSmurf | The thing I hated about econ and poli sci at the Y was that everyone was white, middle class mormons, so new ideas didn't go over very well. |
15:28.13 | mindjuju | too bad, i always wrote fun papers |
15:28.20 | rabidSmurf | I loved it |
15:28.29 | rabidSmurf | but some people in class just didn't get some things |
15:28.33 | rabidSmurf | good teachers |
15:28.35 | rabidSmurf | real good |
15:29.22 | mindjuju | i really ticked of a lot of people with a paper i wrote once about the shift from Manufactoring to Service in the US |
15:29.42 | rabidSmurf | knowledge working is in |
15:29.52 | mindjuju | the conclusion was that people who work in call centers now will just be as unemployable as factory workers are now |
15:30.16 | mindjuju | rather, people who work call centers now will in the future... |
15:30.35 | mindjuju | as those jobs will shift to India / China , etc |
15:30.56 | mindjuju | wrote it about 5 years ago off a couple of Forbes magazines and a paper from RAND |
15:31.05 | mindjuju | saying that kind of stuff REALLY makes people mad |
15:31.20 | rabidSmurf | hehe |
15:31.20 | rabidSmurf | most people don't like free trade arguments either |
15:31.40 | mindjuju | my point being, college education is critical for the masses |
15:31.56 | mindjuju | yeah, true that on free trade |
15:32.09 | timinator | what will be the next major occupation then? |
15:32.58 | mindjuju | For the masses? Hmmm... I didn't actually postulate on that. |
15:33.14 | timinator | :) |
15:33.46 | timinator | we're computer guys, we know and accept that things change |
15:34.01 | timinator | PHP wasn't even around when I was a kid |
15:34.10 | Utah_Dave | ~seen dataw0lf |
15:34.26 | jbot | dataw0lf <n=dataw0lf@70.103.239.58> was last seen on IRC in channel #utah, 141d 9h 37m 52s ago, saying: 'link seems dead, levi.'. |
15:34.38 | macnewbold | hehe |
15:34.43 | rabidSmurf | :( |
15:34.47 | macnewbold | yeah, "dataw0lf seems dead, levi" |
15:34.53 | macnewbold | poor guy |
15:34.56 | macnewbold | I kinda miss him |
15:34.58 | Utah_Dave | where is he? |
15:35.07 | mindjuju | cali |
15:35.08 | macnewbold | out of town I think now |
15:35.18 | macnewbold | long story |
15:38.43 | *** join/#uphpu herlo (n=herlo@ip-216-73-177-176.hqglobal.net) |
15:43.05 | macnewbold | noooooooo! |
15:43.09 | macnewbold | why! |
15:43.16 | mindjuju | why what? |
15:43.22 | macnewbold | the server we dugg is giving 403 errors now |
15:43.24 | macnewbold | :-( |
15:43.34 | macnewbold | http://www.foronceandforall.com/ |
15:43.41 | macnewbold | http://www.foronceandforall.com/2006/10/02/gradefix-students-dream-come-true/ |
15:44.27 | timinator | that stinks |
15:45.05 | timinator | do you have access to that server mac? isn't that your baby? |
15:47.12 | macnewbold | gradefix is fine |
15:47.18 | macnewbold | it's the server with this guys blog on it that is down |
15:47.43 | bigdog_ut | maybe it is getting hit too hard |
15:48.25 | macnewbold | well, with 7 diggs so far, I kind of doubt it |
15:48.34 | macnewbold | and I know every single person who dugg it still :( |
15:48.46 | bigdog_ut | lol |
15:49.35 | macnewbold | well, his main server is back up again |
15:49.45 | macnewbold | but the 404 redirect for the vanity perma-link isn't workign yet |
16:03.14 | mindjuju | yeah, first to smell it, dealt it |
16:03.34 | _psychic_ | ~fart bigdog_ut |
16:03.37 | jbot | ACTION farts in bigdog_ut's general direction |
16:03.46 | mindjuju | ~monkey bigdog_ut |
16:03.47 | jbot | ACTION flings poo at bigdog_ut |
16:03.47 | bigdog_ut | ~pimpslap _psychic_ |
16:03.48 | jbot | bigdog_ut pimpslaps _psychic_. ouch! |
16:04.04 | _psychic_ | what's with the bathroom humor in here today?! |
16:09.31 | macnewbold | YAY! digg target site back up now! |
16:09.45 | macnewbold | some of the bad comments are getting buried, |
16:09.48 | macnewbold | and the diggs are rising again |
16:41.52 | macnewbold | diggs not rising very fast... argh |
16:50.56 | *** join/#uphpu synic (n=squish@pdpc/supporter/student/synic) |
16:52.49 | mindjuju | brb |
16:52.52 | *** part/#uphpu mindjuju (n=Administ@65-121-75-195.dia.static.qwest.net) |
17:04.11 | *** join/#uphpu fungus (n=fungus@firebat.aros.net) |
17:13.18 | *** join/#uphpu herlo (n=herlo@ip-216-73-177-176.hqglobal.net) |
17:13.34 | *** join/#uphpu mindjuju (n=Administ@65-121-75-195.dia.static.qwest.net) |
17:24.49 | bigdog_ut | anyone watch south park last night |
17:24.55 | mindjuju | nope |
17:25.01 | mindjuju | was it the WoW one? |
17:25.04 | timinator | nope.... no tv |
17:25.52 | bigdog_ut | yep...very funny |
17:26.12 | mindjuju | yeah, saw the preview for it. looked funny |
17:29.45 | fungus | I saw it last night. Totally awesome. |
17:29.58 | fungus | I don't think I'll ever delete that episode from my tivo |
17:29.59 | bigdog_ut | lol |
17:30.15 | bigdog_ut | i downloaded it so i got a copy of it |
17:30.37 | mindjuju | 500g hdd $199 - http://www.tigerdirect.com/applications/searchtools/item-Details.asp?EdpNo=1723262&sku=THD-500A&CMP=EMC-TIGEREMAIL&SRCCODE=WEM1209C |
17:31.43 | fungus | 400g hdd $109 http://shop4.outpost.com/product/4596287?site=sr:SEARCH:MAIN_RSLT_PG |
17:31.58 | mindjuju | Zoinks! |
17:33.17 | fungus | http://dealnews.com/categories/Computer/Storage/Hard-Drives/Internal-Hard-Drives/473.html |
17:44.32 | fungus | ~lart mindjuju |
17:57.57 | *** join/#uphpu _psychic__ (n=_psychic@71.32.228.156) |
18:06.30 | fungus | mindjuju: is this yours? foronceandforall.com |
18:06.43 | mindjuju | nope, not my blog |
18:06.53 | mindjuju | why? |
18:07.20 | fungus | you posted a link to it on digg. Just curious. |
18:07.32 | mindjuju | ah, yeah, dugg off it, but not mine |
18:07.41 | mindjuju | i do have a political blog out there |
18:07.53 | mindjuju | but before anybody searches, it doesn't have my name nor my handle |
18:08.04 | fungus | link? |
18:08.15 | mindjuju | no way associated with me, that way i can speak freely about things |
18:10.53 | fungus | link plz. |
18:11.29 | timinator | who here runs a blog? |
18:12.12 | timinator | link plz |
18:12.19 | fungus | http://kittypee.com |
18:12.28 | burnin | lol |
18:14.55 | burnin | fungus: the white area isn't wide enough |
18:15.22 | burnin | fungus: looking at the PHP5 on Mac OSX 10.4 tiger post and the commands run over on the right. |
18:15.47 | fungus | ahh, i just stole that design recently. |
18:16.19 | fungus | I'll look for another design to steal. Thanks for the tip |
18:19.00 | _psychic_ | http://www.johndavidanderson.net/blog/ |
18:22.35 | timinator | thx guys |
18:26.40 | macnewbold | ours is http://gradefix.blogspot.com - not all that pretty, but functional and informative |
18:36.08 | wps | good now has a code search |
18:36.09 | wps | http://www.google.com/codesearch/advanced_code_search |
18:39.39 | _psychic_ | ouch: http://www.google.com/codesearch?as_q=register_globals&btnG=Search+Code&as_lang=php&as_license_restrict=i&as_license=&as_package=&as_filename=&as_case= |
18:40.07 | _psychic_ | interesting.. |
18:40.28 | timinator | holy moly |
18:41.04 | bigdog_ut | maybe it will help people get there crap together |
18:41.24 | fungus | I doubt it. |
18:41.51 | fungus | There are still some people who haven't upgraded their code from PHP3. |
18:42.09 | bigdog_ut | true...but that might be many factors for that |
18:42.30 | bigdog_ut | they might be locked into requirements or financial issues |
18:43.20 | fungus | possibly, but it really annoys me every time I upgrade php on my servers. |
18:44.29 | bigdog_ut | now that is true |
18:46.17 | bigdog_ut | for me i have not been impressed with the direction of php in the last year |
18:46.28 | bigdog_ut | im not too impressed with some of the guys they have |
18:47.51 | timinator | why do you say that bigdog_ut? |
18:48.29 | bigdog_ut | cause they dont have a clear milestone plan for development and they always have issues with stability and patches |
18:48.52 | bigdog_ut | stability is terms of stable releases that you can count on not patching for a while |
18:49.01 | bigdog_ut | perhaps freebsd team needs to smack them around |
18:49.32 | timinator | are you talking about PHP >4 |
18:50.09 | bigdog_ut | php5 mainly...php4 is pretty good |
18:50.23 | timinator | right on |
18:52.38 | timinator | what do you think should be on their development agenda? |
18:54.21 | bigdog_ut | they need to really think their oo object model for one |
18:54.46 | bigdog_ut | also they need to focus on getting everything thread safe |
18:54.49 | _psychic_ | Yeah it needs to be more like Java *cough* |
18:55.32 | timinator | :) |
18:55.45 | bigdog_ut | there are other oo object models than java |
18:55.47 | tierra | hehe, I just got this Gmail error message: "Arrgh! The page has been corrupted." |
18:56.01 | tierra | someone had some fun with that one |
18:56.17 | timinator | lol tierra |
18:56.40 | _psychic_ | I just wish for namespaces of some sort, and some sort of function naming convention |
18:56.57 | _psychic_ | PHP5 OO is just fine for me |
18:57.14 | _psychic_ | PHP5 core is threadsafe iirc, just some extensions aren't |
18:57.26 | bigdog_ut | many extensions are not |
18:57.33 | bigdog_ut | that is one major issue i have |
18:57.48 | _psychic_ | yeah |
18:57.55 | _psychic_ | which extension? |
18:59.20 | bigdog_ut | i would like the gd to be multithreaded for one |
19:00.00 | _psychic_ | is ImageMagik multithreaded? |
19:00.13 | _psychic_ | I wish PHP had some threading libs |
19:00.19 | _psychic_ | shared memory is hard to play with |
19:01.03 | *** join/#uphpu macnewbold (n=mac@69.2.248.251) |
19:01.03 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
19:01.37 | bigdog_ut | it might be but not sure |
19:02.03 | *** topic/#UPHPU by macnewbold -> Utah PHP Users Group | uphpu.org | Next Meeting: Thu. Oct. 19, 7pm, Place? Topic? |
19:07.16 | *** part/#uphpu herlo (n=herlo@ip-216-73-177-176.hqglobal.net) |
19:10.38 | macnewbold | I think wps already had someone for october, but I don't remember who or on what |
19:10.56 | bigdog_ut | here is my pres...google for 1st 2nd 3rd BCNF 4th normal forms |
19:11.35 | wps | Cole Joplin on Flash/PHP communications |
19:16.08 | mindjuju | i was just kiddin' flash / php sounds cool |
19:53.06 | _psychic_ | fungus: you lonnie? |
19:53.34 | mindjuju | yup |
19:55.28 | _psychic_ | just wondering who commented on my blog |
20:00.07 | fungus | Yup that was me. |
20:00.43 | _psychic_ | (I've responded) |
20:16.41 | Utah_Dave | macnewbold: I've noticed that Gradefix looks a bit similar to flyspray. Especially the task list |
20:18.01 | _psychic_ | anyone ever used these: http://us3.php.net/manual/en/ref.shmop.php ? |
20:19.37 | mindjuju | that was really funny |
20:44.02 | macnewbold | Utah_Dave: that's interesting, I never noticed that, nor was it planned |
20:44.44 | *** topic/#UPHPU by macnewbold -> Utah PHP Users Group | uphpu.org | Next Meeting: Thu. Oct. 19, 7pm, Cole Joplin on Flash/PHP communications |
20:45.18 | Utah_Dave | mostly just the list of tasks. I just noticed it because I looked at Flyspray earlier today, then I logged into my Gradefix account right after |
20:53.53 | macnewbold | yeah, that's cool - I guess it's a nice layout or something |
21:10.17 | *** join/#uphpu wps (n=wps@64.72.210.10) |
21:10.17 | *** mode/#UPHPU [+o wps] by ChanServ |
21:12.17 | mindjuju | k, this is good promo for people trying to convince others to not use MS products |
21:12.17 | mindjuju | http://www.youtube.com/watch?v=3atmWmWCwlw |
21:15.11 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
22:09.14 | beandog | any mssql users/gurus/stepchildren in here |
22:10.09 | beandog | actually this might just be a generic db question |
22:10.17 | beandog | If youre doing select func(foo) |
22:10.24 | beandog | You have to also do order by func(foo); |
22:10.36 | beandog | Is there someway to set output of func(foo) to @var |
22:10.41 | beandog | so I can just do order by @var? |
22:10.49 | macnewbold | no don't have to order by it if you don't want to |
22:10.53 | beandog | I'm writing a UDF here, I dont want to pass it twice. |
22:11.18 | macnewbold | in mysql at least, you can say "select func(foo) as bar from blah order by bar;" |
22:11.27 | beandog | macnewbold: okay, yah thats what I thought |
22:11.30 | beandog | mssql doesnt let you do that. |
22:11.30 | macnewbold | in mssql, you may need to leave the as out |
22:11.41 | beandog | SELECT FUNC(foo) AS bar ORDER BY bar; doesnt work |
22:11.47 | beandog | says bar doesn't exist. |
22:11.50 | macnewbold | so it doesn't let column name aliases work in the order clause? |
22:11.50 | macnewbold | doh |
22:11.52 | macnewbold | lame |
22:12.06 | beandog | the blessed magic of microsoft. |
22:12.12 | macnewbold | how about SELECT FUNC(foo) ORDER BY FUNC(foo); |
22:12.22 | macnewbold | it isn't likely to actually run the function twice |
22:12.30 | beandog | Well the problem is Im sticking FUNC(foo) in a view. |
22:13.26 | beandog | So I dont wanna do select * from view_foo and have to remember to do order by func(foo); |
22:13.35 | macnewbold | hm |
22:13.37 | beandog | er,w ait |
22:13.44 | beandog | the view should have already create the new column. |
22:13.45 | beandog | I think. |
22:13.47 | macnewbold | right |
22:13.47 | beandog | ............ |
22:13.56 | macnewbold | you should be able to order by the column once you have the view |
22:14.27 | macnewbold | the order by in the query to create the view (if you can do that?) would probably just specify the default data order in the view I'd guess |
22:14.38 | beandog | hmm thats worth a try. |
22:14.40 | beandog | brb |
22:15.03 | macnewbold | but mssql is unpredictable in some things (what it will do in situation x), though very predictable in others (crashing often for example, or just failing to do what it is told |
22:16.01 | macnewbold | the other day, mssql sent back an error saying |
22:16.30 | macnewbold | that it detected a deadlock between two query threads, and I got picked as the victim, so it killed my query. It ended with "Please try again." |
22:17.37 | beandog | yah I get that too |
22:17.45 | beandog | I really hate this database. |
22:18.03 | beandog | Well, that did work putting it in the view and selecting from the view then ordering by the colname |
22:18.06 | beandog | but it is INCREDIBLY slow. |
22:18.20 | beandog | 22 seconds to pull out 25 rows. |
22:18.47 | beandog | that ain't gonna work. |
22:19.01 | macnewbold | isn't that normal for mssql? |
22:19.04 | macnewbold | :-D |
22:19.06 | beandog | heheh |
22:29.47 | mindjuju | beandog, did you get your answer about mssql? |
22:31.05 | macnewbold | not one that worked :) |
22:31.24 | beandog | mindjuju: not really. mssql is teh suck |
22:32.04 | macnewbold | mj will help, he's an MSSQL kung fu master |
22:32.19 | mindjuju | k, first off there are special rules when using var in udf |
22:32.29 | mindjuju | like you can't use it straight out like you may want |
22:32.40 | macnewbold | (about the only MSSQL kung fu I know is the one fingered salute on the power button, so I can reboot it to install FreeBSD and MySQL) |
22:33.20 | mindjuju | beandog, what version ms sql? |
22:33.28 | mindjuju | 7, 2k or 2k5? |
22:33.39 | beandog | 2k |
22:33.55 | mindjuju | coolio, that's my strong one, i'm starting to learn 2k5 |
22:34.01 | mindjuju | give me quick sec to open books online |
22:34.04 | beandog | Ok |
22:34.33 | beandog | I'm all outta cookies |
22:40.30 | mindjuju | oh yeah, ugh, there is major weirdness |
22:41.19 | macnewbold | thanks for not tossing any cookies at mindjuju |
22:41.50 | beandog | heh |
22:43.07 | macnewbold | we just mopped the floors yesterday |
22:43.17 | macnewbold | after a big mess with some bigdog_ut brownies |
22:43.35 | bigdog_ut | oh yeah |
22:49.25 | mindjuju | beandog, i'm almost done here |
22:49.32 | mindjuju | just a few sec longer |
22:49.39 | mindjuju | the deal is though, that you can't use it straight off |
22:49.47 | mindjuju | you have to go through a case statement if you want to do it right |
22:49.57 | mindjuju | i know, it sounds jacked up, and truthfully it is |
22:55.06 | macnewbold | it's MSSQL, of course it is... ;) |
22:55.32 | beandog | oh my crap |
22:55.36 | beandog | sorry mindjuju was looking at something else |
22:55.41 | beandog | I think I found *another* php + mssql bug |
22:55.43 | timinator | I'm out guys... |
22:55.49 | timinator | have a good night all |
22:55.55 | beandog | Its making any columns where string = '' into string = ' ' |
22:58.06 | beandog | my freaking crap. |
22:58.09 | beandog | I *really* hate mssql. |
22:59.47 | _psychic_ | ~dhit mssql |
22:59.51 | jbot | ACTION appears right behind mssql and slaps him in the back of the head |
23:01.31 | mindjuju | beandog, i found the old page in my notes that i referred to to write a sproc |
23:01.37 | mindjuju | couldn't find the sproc, but the page is still up |
23:01.38 | mindjuju | http://databases.aspfaq.com/database/how-do-i-use-a-variable-in-an-order-by-clause.html |
23:02.00 | mindjuju | there are a copule good references, but i liked this one cause it explained all the whys |
23:04.10 | mindjuju | actually, beandog, just double checked my notes, and this is the last one i used |
23:04.11 | mindjuju | http://www.sqlteam.com/item.asp?ItemID=2209 |
23:04.19 | mindjuju | and this is what i based my nightmare on |
23:04.25 | mindjuju | DECLARE @SortOrder tinyint SET @SortOrder = 2 SELECT CompanyName, ContactName, ContactTitle FROM Customers ORDER BY CASE WHEN @SortOrder = 1 THEN CompanyName WHEN @SortOrder = 2 THEN ContactName ELSE ContactTitle END |
23:06.42 | mindjuju | now, i know, right now your making voodoo dolls of Bill Gates and dropping it into pits of punji sticks and truth is, i don't blame you. I remember saying several expliatives during the course of using a dynamic order by until i found the "right way" |
23:07.05 | *** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
23:07.22 | beandog | oh man. |
23:07.27 | beandog | I just found *another* fun MSSQL bug. |
23:07.33 | beandog | apparently '' = ' '; |
23:08.14 | beandog | select len(' '); |
23:08.17 | beandog | returns 0 |
23:08.19 | beandog | I kid you not. |
23:09.18 | beandog | -_- |
23:09.21 | beandog | what a nightmare |
23:09.22 | beandog | Ok |
23:10.35 | beandog | mindjuju: yah, that article covers the same options Ive been going over |
23:10.43 | beandog | I think Im just going to clean up the db structure instead. |
23:10.52 | beandog | That and make it an even *higher* priority to replace mssql w/postgres |
23:11.01 | beandog | What a piece of junk. |
23:11.25 | mindjuju | yeah, i was really mad when i was writing the sproc |
23:13.14 | beandog | I wonder if that LEN() bug is a new one. |
23:13.27 | beandog | Since its only running it on *some* of the hundreds of thousands of rows. |
23:13.40 | beandog | er, wait |
23:13.42 | beandog | maybe it isnt. |
23:14.07 | beandog | no, it was doing it on 100% of them |
23:14.14 | beandog | I guess I could use NULLs on varchars, but how freaking ugly is that? |
23:14.18 | beandog | gah. |
23:14.21 | beandog | death to sql server. |
23:17.31 | beandog | oh well |
23:17.37 | beandog | thanks for your help mindjuju, much appreciated. |
23:19.47 | mindjuju | yup |
23:49.34 | wps | http://static.flickr.com/19/106523826_0b434e6c78.jpg |
23:51.11 | fungus | OMGWTF! |
23:51.15 | fungus | yuck |