| 00:12.56 | *** part/#uphpu Utah_Dave (n=boucha@0-2pool130-215.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 00:23.15 | drewbono | so no meeting today? |
| 00:30.42 | fungus | Yes there is a meeting today. |
| 00:30.58 | fungus | http://uphpu.org/calendar_event.php?eid=20060215130602266 |
| 00:37.14 | *** join/#uphpu wps (n=wps@65.73.113.199) |
| 00:37.15 | *** mode/#uphpu [+o wps] by ChanServ |
| 00:55.31 | mindjuju | Utah_Dave, you still around? |
| 00:56.19 | mindjuju | Well, in case you come back... |
| 00:57.28 | mindjuju | You can't do mysql's show tables, but you can do sp_help to see all objects (tables, sp, etc) |
| 00:57.38 | mindjuju | or you could |
| 00:57.39 | mindjuju | select name from <database name>..sysobjects where xtype = 'U'; |
| 01:12.53 | *** join/#uphpu usynic (n=synic@pdpc/supporter/student/synic) |
| 02:22.33 | *** join/#uphpu _psychic_ (n=_psychic@c-24-2-78-210.hsd1.ut.comcast.net) |
| 02:34.15 | *** part/#uphpu _psychic_ (n=_psychic@c-24-2-78-210.hsd1.ut.comcast.net) |
| 02:34.26 | *** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com) |
| 03:46.38 | *** join/#uphpu niquil (i=niquil@71-37-73-229.slkc.qwest.net) |
| 04:08.56 | *** join/#uphpu drewbono (n=andrew@c-24-2-95-76.hsd1.ut.comcast.net) |
| 04:49.50 | *** join/#uphpu drewbono (n=andrew@c-24-2-95-76.hsd1.ut.comcast.net) |
| 07:16.00 | *** join/#uphpu RyanE (n=ryan@rberick.dsl.xmission.com) |
| 09:47.31 | *** join/#uphpu cycokilr (i=cycokilr@c-67-166-124-68.hsd1.ut.comcast.net) |
| 14:56.00 | *** join/#uphpu _psychic_ (n=_psychic@128.187.154.144) |
| 14:58.43 | *** join/#uphpu wps (n=wps@38.119.178.10) |
| 14:58.43 | *** mode/#uphpu [+o wps] by ChanServ |
| 15:26.52 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool138-37.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 16:01.49 | *** join/#uphpu bigdog_ut (n=bigdog@207.135.132.13) |
| 16:01.49 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 16:02.52 | mindjuju | Utah_Dave, you around? |
| 16:03.03 | Utah_Dave | yeah |
| 16:03.08 | Utah_Dave | what's up? |
| 16:03.25 | mindjuju | i got a project dumped on me just as I was leaving for the meeting yesterday. sorry i dogged ya last night. |
| 16:03.41 | mindjuju | i just noticed that you were logged out when i answered your question about show tables |
| 16:03.46 | mindjuju | want me to post it again? |
| 16:04.12 | Utah_Dave | yeah, that would be great |
| 16:04.46 | mindjuju | You can't do mysql's show tables, but you can do sp_help to see all objects (tables, sp, etc) |
| 16:04.47 | mindjuju | <PROTECTED> |
| 16:04.47 | mindjuju | <PROTECTED> |
| 16:06.40 | Utah_Dave | I'm not quite getting what you're saying. do "sp_help" at the command line? |
| 16:07.12 | mindjuju | sorry, sp_help in query analyzer |
| 16:08.05 | Utah_Dave | oh, OK. |
| 16:08.41 | mindjuju | seems like last night you were having problems seeing anything in query analyzer, that you could see in access |
| 16:08.50 | mindjuju | something about limited access to the database as i recall |
| 16:08.56 | Utah_Dave | I think part of the problem I was having yesterday is the way our vendor set up these tables for our use. I think they set up the permissions so they could be view only through odbc. when I do the queries with mssql function, nothing happens. |
| 16:09.36 | Utah_Dave | I set up unixODBC and run the queries through that and I just got the odbc_tables() function to work. Now I'm putting together a select query to see what happens. |
| 16:15.34 | Utah_Dave | YESSS! I got it working!!! What a pain. |
| 16:16.48 | Utah_Dave | mindjuju: are there any major SQL gotchas I should be aware of? I'm used to using MySQL mostly |
| 16:22.23 | mindjuju | pagination |
| 16:22.29 | mindjuju | not available in MSSQL |
| 16:25.48 | Utah_Dave | yeah, no LIMIT clause |
| 16:27.01 | bigdog_ut | you could use a between clause if it has it |
| 16:28.35 | Utah_Dave | it seems dumb to me that you can't limit the number of results. I have tables with hundreds of thousands of entries, I don't think I want to have to run all of them across the wire when I only want the first one |
| 16:29.02 | bigdog_ut | does mssql support cursors? that would be the way to do it |
| 16:29.15 | bigdog_ut | cursors are fare better than limits |
| 16:29.29 | Utah_Dave | Oh, I think it might. I seem to remember seeing functions for that on php.net. I'll go look |
| 16:32.17 | Utah_Dave | I found somewhere that you can do "SELECT TOP 5 * FROM table" |
| 16:32.38 | Utah_Dave | It gives back 5 results, but I'm not sure if their the results I want |
| 16:32.49 | bigdog_ut | if you have thousands of records though and you want to have access to them you should use cursors |
| 16:32.58 | bigdog_ut | cursor will nto requery the db each time |
| 16:33.13 | bigdog_ut | keeps the previous query open for access |
| 16:35.21 | Utah_Dave | thanks, bigdog_ut. I'll look into how cursors work with mssql |
| 16:36.17 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 16:58.21 | mindjuju | good ole' Bigdog, knows the answers to everything SQL |
| 16:58.52 | bigdog_ut | sometimes |
| 17:03.03 | macnewbold | bunch of slackers - most of y'all missed the meeting last night |
| 17:03.15 | wps | what was the turn out? |
| 17:03.28 | macnewbold | including Mike our host, there were 6 of us there |
| 17:03.33 | wps | yikes |
| 17:03.43 | wps | poor publicity |
| 17:03.50 | wps | on my part |
| 17:03.51 | wps | sorry |
| 17:04.01 | macnewbold | Utah_Dave, Richard Miller, fungus and myself, John Talbot(sp?) and Mike |
| 17:04.23 | macnewbold | John had just returned from So.Cal. Linux Expo, and gave us the report |
| 17:04.29 | macnewbold | crazy stuff going on |
| 17:04.43 | Utah_Dave | mac did a great job on the presentation. John's report was pretty cool |
| 17:05.02 | macnewbold | we decided that we're not posting slides for the slackers who wouldn't bother to show up |
| 17:05.11 | macnewbold | there were at least 3 who said they'd come but didn't |
| 17:05.27 | macnewbold | including one who said he'd bring a few slides and present them |
| 17:06.25 | RyanE | I would have liked to have come, but no babysitter. |
| 17:08.41 | mindjuju | i promise on a stack of O'Reily tech books that I got a project on my way out ~ 6:30p |
| 17:09.02 | mindjuju | i should have done the office space thing and bailed out of the office out the back |
| 17:09.12 | mindjuju | or used some other trickery |
| 17:33.05 | *** join/#uphpu el_gaucho (n=bigdog@207.135.132.13) |
| 17:33.05 | *** mode/#uphpu [+o el_gaucho] by ChanServ |
| 17:33.46 | *** kick/#uphpu [bigdog_ut!n=bigdog@207.135.132.13] by el_gaucho (el_gaucho) |
| 17:44.06 | Utah_Dave | mindjuju: thanks for helping me with connecting to my mssql server. it's working great now. |
| 17:59.40 | *** join/#uphpu bigdog_ut (n=bigdog@207.135.132.13) |
| 17:59.40 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 18:00.23 | *** join/#uphpu drewbono (n=andrew@c-24-2-95-76.hsd1.ut.comcast.net) |
| 18:08.17 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 18:15.42 | mindjuju | k, if i have already defined a list as being upper roman, and need to switch back to numeral , how do i do that? in CSS? can't seem to find an li style for numbers |
| 18:17.52 | mindjuju | oh, decimal, for some reason i was thinking decimal was something else |
| 18:24.50 | *** join/#uphpu jsmith (n=jsmith@smithfam.dsl.xmission.com) |
| 18:24.50 | bigdog_ut | man when im not here things are quiet! |
| 18:35.50 | mindjuju | ~melvin bigdog_ut |
| 18:35.52 | jbot | ACTION pulls bigdog_ut underwear up to the ceiling...and smiles |
| 18:36.04 | *** part/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 20:57.05 | jsmith | Oh yeah? |
| 20:57.06 | jsmith | Specs? |
| 21:05.12 | bigdog_ut | 3.2ghz p4ht preston |
| 21:05.24 | bigdog_ut | new asus motherb 1024fsb |
| 21:05.26 | bigdog_ut | 2 gig ram |
| 21:05.36 | bigdog_ut | nvidia 128 g4 |
| 21:05.45 | bigdog_ut | new tower |
| 21:05.50 | bigdog_ut | runs like a champ |
| 21:10.36 | *** join/#uphpu drewbono (n=andrew@128.187.156.155) |
| 21:11.29 | Utah_Dave | fun |
| 21:16.35 | bigdog_ut | adding another 2 gig in a month |
| 21:31.42 | *** join/#uphpu drewbono (n=andrew@128.187.144.153) |
| 21:33.06 | RyanE | I'm sure my 'top-of-the-line' system is probably worse than the system bigdog_ut is replacing. :) |
| 21:35.20 | bigdog_ut | i cant wait till i have 4gigs...not sure what to do |
| 21:35.25 | bigdog_ut | since i run gentoo |
| 21:35.53 | bigdog_ut | i have watched a dvd, emerged, ran eclipse, and compiled java at the same time |
| 21:35.55 | bigdog_ut | with no issues |
| 21:36.06 | bigdog_ut | i think heaven is like this |
| 21:36.11 | bigdog_ut | just a little bit better |
| 21:36.37 | bigdog_ut | with the new controllers i had some issues |
| 21:36.41 | bigdog_ut | but figured that out |
| 21:37.46 | bigdog_ut | the new ich7's on the mb are a little new for linux and the new pci-e nic through me for a loop with the livecd |
| 21:38.01 | bigdog_ut | but other than that it rocks...i cant wait to move to sata drives |
| 21:41.52 | jsmith | I can't wait to move from 5-1/4" floppies to 3-1/2" floppies |
| 21:42.07 | jsmith | Oh, and maybe I can spring for some of those new RLL drives... |
| 21:53.27 | *** join/#uphpu ChanServ (ChanServ@services.) |
| 21:53.27 | *** mode/#uphpu [+o ChanServ] by irc.freenode.net |
| 21:58.01 | bigdog_ut | yeah when i get more memory and sata drives i will be the evy of the block |
| 22:00.27 | Utah_Dave | hey, has anybody here had any experience with the Yahoo! UI Library? |
| 22:07.54 | tierra | eco just got 3 brand new Seagate 3.0Gb/s 250gb drives, despite the fact that I still have more storage space (I think), I was rather jealous |
| 22:08.31 | tierra | I take that back, he does have more than me now |
| 22:08.36 | tierra | just barely |
| 22:09.03 | eco | Excluding my dieing 200GB drive, I'll have 1200GB (4 drives of which, are in a RAID5) |
| 22:09.10 | eco | :D |
| 22:09.33 | eco | I'll finally be able to fit the entire McGyver series! |
| 22:09.41 | jsmith | Utah_Dave: No, but some of the underlying stuff reminds me of the OpenRico stuff -- but maybe that's just because the OpenRico guys went to work for Yahoo. |
| 22:09.44 | eco | Or is it MacGyver...whatever. |
| 22:11.03 | Utah_Dave | jsmith: yeah. I'm downloading it right now to give it a little test run |
| 22:11.43 | jsmith | Utah_Dave: Let me know how it goes, eh? |
| 22:11.53 | Utah_Dave | I'll do that. |
| 22:12.43 | Utah_Dave | the thing that piqued my interest to actually try it out was a comment they made on their blog how they work real hard to make it as cross-browser compatible as possible. |
| 22:12.49 | RyanE | Utah_Dave: I'm using the slider control. Seems to work well. |
| 22:12.58 | RyanE | Works on Konqueror, Firefox Windows / Linux, IE |
| 22:13.06 | RyanE | Not Opera / Win, strangely enough |
| 22:13.13 | Utah_Dave | I hate dealing with that kind of stuff and if this works how they say, then I'll let those Yahoo engineers fight that battle |
| 22:13.20 | RyanE | yep |
| 22:30.35 | *** join/#uphpu drewbono (n=andrew@128.187.144.153) |
| 22:32.02 | Utah_Dave | well, so far the demos look pretty good. |
| 22:42.05 | *** join/#uphpu drewbono (n=andrew@128.187.144.153) |
| 23:16.19 | *** join/#uphpu niquilhome (i=niquil@71-37-73-229.slkc.qwest.net) |
| 23:45.35 | *** part/#uphpu Utah_Dave (n=boucha@0-1pool138-37.nas28.salt-lake-city1.ut.us.da.qwest.net) |