| 00:01.55 | wps | WAHOO! |
| 00:01.57 | wps | it's fixed!!! |
| 00:16.09 | Utah_Dav1 | wps: what bug was that? |
| 00:16.44 | wps | oops… didn't realize I typed that in here |
| 00:16.57 | wps | that was supposed to be in #byumuc |
| 00:16.58 | wps | sorry |
| 00:17.26 | wps | the update previous to this made it so that you could not select three stars in when creating a by-rating smart playlist |
| 00:17.40 | *** join/#uphpu drewbono (n=andrew@128.187.149.116) |
| 00:22.05 | *** part/#uphpu Utah_Dav1 (n=boucha@0-2pool130-130.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 01:40.40 | *** join/#uphpu _psychic_ (n=_psychic@128.187.139.192) |
| 03:21.34 | *** join/#uphpu bigdog_ut (n=bigdog@207.135.132.13) |
| 03:21.34 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 03:23.52 | *** topic/#uphpu by bigdog_ut -> new poll on website: march presentation topic | Utah PHP User Group | www.uphpu.org |
| 04:33.25 | *** join/#uphpu dataw0lf (n=dataw0lf@70.103.239.58) |
| 05:58.27 | *** join/#uphpu _psychic_ (n=_psychic@c-24-2-78-210.hsd1.ut.comcast.net) |
| 06:44.04 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 07:01.03 | *** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com) |
| 13:49.10 | *** join/#uphpu jsmith (n=jsmith@smithfam.dsl.xmission.com) |
| 15:06.57 | *** join/#uphpu wps (n=wps@38.119.178.10) |
| 15:06.57 | *** mode/#uphpu [+o wps] by ChanServ |
| 15:12.48 | *** join/#uphpu drewbono (n=andrew@128.187.150.158) |
| 16:09.11 | *** join/#uphpu Utah_Dave (n=boucha@0-2pool130-215.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 16:31.01 | *** join/#uphpu _psychic_ (n=_psychic@128.187.171.255) |
| 16:34.53 | *** join/#uphpu drewbono (n=andrew@128.187.150.158) |
| 17:00.05 | *** join/#uphpu drewbono (n=andrew@128.187.173.114) |
| 17:12.23 | *** join/#uphpu eco_ (n=eco@gnuk.net) |
| 17:13.05 | *** join/#uphpu eco (n=eco@gnuk.net) |
| 17:26.53 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 17:32.57 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 19:25.45 | wps | would anyone be interested in having Pete Ashdown speak at a UPHPU meeting? |
| 19:26.48 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 19:31.38 | Utah_Dave | is he the xmission guy? |
| 19:33.21 | wps | yes |
| 19:33.33 | wps | I don't know anything about him, except… |
| 19:33.53 | wps | "He's the founder of XMission and **cough** Democratic candidate for the US Senator (running against Orrin Hatch). He's got a great head for technical issues in government, although I'm not sure how much else we'd agree on." |
| 19:36.25 | Utah_Dave | I think it would be cool to have him come. |
| 19:47.36 | *** part/#uphpu mindjuju (n=Administ@216.20.238.225) |
| 19:56.24 | *** join/#uphpu jakea (n=jakea@128.187.178.125) |
| 19:58.13 | *** join/#uphpu mindjuju (n=Administ@216.20.238.225) |
| 19:58.39 | tierra | stealing ideas from PLUG? =) |
| 19:58.57 | wps | they contacted us |
| 19:59.57 | tierra | just seeing if UPHPU wanted to join them for pashdown's presentation? |
| 20:00.50 | tierra | err... that was UVLUG that's putting it on actually |
| 20:00.54 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 20:01.44 | wps | no, I think that either Pete or someone representing him asked a UVLUG presidency member if we would be interested… he wasn't about to speak for us, so he emailed me |
| 20:03.06 | tierra | now your confusing me |
| 20:04.56 | wps | Someone asked a UVLUG presidency member if UPHPU would be interested in having Pete speak to us. That presidency member passed this on to me and asked me if I wanted him to give that person my contact info (inferring that we would be interested). |
| 20:05.41 | tierra | oh, ok |
| 20:07.15 | wps | if Pete himself or someone representing him is soliciting him to speak though, then it sounds like he has an agenda (especially since he is currently running for office) |
| 20:07.58 | tierra | my next question I was about to ask is what he'd be speaking on... |
| 20:08.07 | wps | I have no idea |
| 20:08.21 | tierra | it's definately peaked my interest though |
| 20:18.46 | *** join/#uphpu dataw0lf (n=dataw0lf@70.103.239.58) |
| 20:24.12 | *** join/#uphpu drewbono (n=andrew@128.187.185.37) |
| 20:24.50 | dataw0lf | meh, harmonyip. |
| 20:27.04 | dataw0lf | wps: and I would definitely be interested in hearing Ashdown speak. A Utah democratic candidate with even a tiny chance? Hurrah! |
| 20:27.27 | wps | k |
| 20:46.14 | drewbono | Anyone have a google analytics invite for me? :-) |
| 20:46.16 | drewbono | Pretty please? |
| 20:50.55 | dataw0lf | one sec |
| 20:54.05 | drewbono | dataw0lf: andrew.jacobs@gmail.com if you have one |
| 20:56.16 | *** join/#uphpu _psychic1 (n=_psychic@71.32.228.156) |
| 20:57.39 | dataw0lf | drewbono: I thought I had one, but apparently not. the guy who gave me one got one two days later though so I'll email you one as soon as I receive it. |
| 21:07.14 | Utah_Dave | drewbono: I have analytics account, but I don't see anywhere where I can send an invite |
| 21:08.23 | dataw0lf | Utah_Dave: They'll email you invites. |
| 21:08.56 | Utah_Dave | oh, then I don't have an invite. Sorry, drewbono. |
| 21:10.24 | dataw0lf | They just started giving invites to users this week, normally you just signed up and waited to make it through the queue |
| 21:13.28 | *** join/#uphpu drewbono (n=andrew@128.187.143.114) |
| 21:48.33 | Utah_Dave | The meeting is tonight, right? |
| 21:59.16 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 22:03.49 | *** part/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 22:09.10 | *** join/#uphpu niquil (i=niquil@71-37-73-229.slkc.qwest.net) |
| 22:17.18 | macnewbold | Utah_Dave: yes meeting tonight 7pm |
| 22:17.21 | macnewbold | normal place |
| 22:17.33 | Utah_Dave | cool |
| 22:52.06 | Utah_Dave | macnewbold: have a second for a mssql question? |
| 22:52.21 | macnewbold | sure |
| 22:52.27 | macnewbold | though I'm not that great with mssql |
| 22:52.31 | macnewbold | I avoid it whenever I can |
| 22:52.37 | macnewbold | mindjuju might be able to help, too, IIRC |
| 22:53.03 | Utah_Dave | me, too. I've been forced to grab some data from one of our vendor's mssql databases |
| 22:53.23 | Utah_Dave | OK, I can connect to the database just fine. |
| 22:53.26 | mindjuju | sorry, just tuning in ~ what up? |
| 22:53.34 | macnewbold | Utah_Dave has a mssql question |
| 22:53.38 | macnewbold | he was just starting |
| 22:53.56 | Utah_Dave | I'm trying to connect from a FC4 box to a Win2k box running mssql |
| 22:54.25 | Utah_Dave | I've finally got freetds and all that working. I can connect successfully to the database |
| 22:55.09 | Utah_Dave | I'm getting a Warning: mssql_query(): message Invalid object name ' dbo_VB..." on line 16 |
| 22:55.34 | Utah_Dave | I can connect the database through MS Access on my workstation and I know the table is there. |
| 22:55.47 | Utah_Dave | I'm kind of at a loss as to why the query is failing. |
| 22:57.20 | Utah_Dave | I'm selecting the database fine, too. |
| 22:57.27 | macnewbold | hm |
| 22:57.52 | mindjuju | one thing that looks funny off the bat is the dbo_vb that should likely read dbo.vb (assuming the database object is called vb) |
| 22:57.54 | macnewbold | what's dbo_VB...? I've never seen that anywhere |
| 22:58.15 | macnewbold | watch uppercase/lowercase maybe? |
| 22:58.19 | macnewbold | we have to allcaps our queries |
| 22:59.11 | Utah_Dave | well, when I look at the database tables through Access those are the names of the tables |
| 22:59.20 | Utah_Dave | dbo_VB_GuestFiles |
| 22:59.32 | Utah_Dave | that's a full name of one of the table |
| 22:59.37 | Utah_Dave | s/tables |
| 23:01.12 | mindjuju | going to check something out, i try to stay away from access if at all possible, but access is notorius for trying to take the thinking away from the programmer. |
| 23:01.13 | mindjuju | bfb |
| 23:01.14 | Utah_Dave | I think these are just views that our vendor has created for us. They won't actually let us into their database |
| 23:01.14 | mindjuju | brb |
| 23:02.21 | Utah_Dave | k |
| 23:03.24 | Utah_Dave | can you do a "SHOW TABLES" with mssql? |
| 23:05.33 | mindjuju | sorry bout that, k its what i was think Utah_Dave |
| 23:05.46 | mindjuju | Access is trying to dumb down everything so that it makes more sense to everybody |
| 23:06.01 | mindjuju | in so doing, it is taking a table name of salesTable |
| 23:06.08 | mindjuju | and calling it dbo_salesTable |
| 23:06.27 | mindjuju | because objects in MSSQL are technically called dbo.xxx or in this case dbo.salesTable |
| 23:06.30 | mindjuju | does that make sense? |
| 23:06.44 | mindjuju | so the name of the table isn't dbo_VB, it's vb |
| 23:07.04 | mindjuju | Not a big fan of MS Access |
| 23:07.29 | Utah_Dave | ok, let me try that out. |
| 23:09.07 | macnewbold | ~lament MSSQL |
| 23:09.10 | macnewbold | ~lart MSSQL |
| 23:09.35 | Utah_Dave | :) |
| 23:09.44 | Utah_Dave | ok, I'm on the SQL Query Analyzer |
| 23:10.00 | Utah_Dave | I think you're right mindjuju |
| 23:10.07 | mindjuju | i'm a big fan of Query Analyzer |
| 23:10.48 | Utah_Dave | When I do a "SELECT * FROM Files" I get a permission denied error. ugh |
| 23:11.27 | mindjuju | i'm guessing your not using SA for MSSQL, which you shouldn't be, but do you have a login that has rights to query that table? |
| 23:11.27 | Utah_Dave | I'm using the same credentials I used with Access |
| 23:11.55 | Utah_Dave | I don't know why it won't let me select |
| 23:12.35 | mindjuju | wait! |
| 23:12.46 | mindjuju | in query analyzer, it sets the database to master as default |
| 23:12.58 | mindjuju | make sure that you choose the database with the tables you want |
| 23:13.21 | mindjuju | you'll see that in the top bar about in the middle |
| 23:14.09 | Utah_Dave | I've got the correct database selected |
| 23:14.52 | Utah_Dave | I'm still getting the same permission denied. I just edited my freetds.conf and set tds_version to 8.0 and now I'm getting that same error from my php script |
| 23:15.06 | Utah_Dave | I'm going to have to found out why that is |
| 23:15.40 | mindjuju | i've actually got an offsite meeting i've got to bolt to, but i'll give it a think. are you going to the PHP meeting tonight? |
| 23:16.33 | Utah_Dave | I should be there. |
| 23:16.55 | Utah_Dave | can I do a SHOW TABLES from the sql query analyzer? |
| 23:17.59 | Utah_Dave | actually, mindjuju I think these are views that the vendor set up for us, so we don't have direct access to their tables. |
| 23:18.44 | *** join/#uphpu jsmith (n=jsmith@smithfam.dsl.xmission.com) |
| 23:19.57 | Utah_Dave | mm. this is so frustrating. This just reminds me why I hate developing w/windows |
| 23:24.59 | Utah_Dave | the frustrating thing is that with the same credentials, I can do a link in Access and view the table with no problem. |
| 23:25.31 | Utah_Dave | but when I do a select in the Query Analyzer, or with php, I get a SELECT permission denied. |
| 23:25.47 | Utah_Dave | Well, maybe I need to go home and sleep on it and try again tomorrow. |
| 23:34.21 | synic | my |
| 23:34.40 | synic | uh. |
| 23:34.41 | synic | yeah. |
| 23:34.43 | synic | wrong window |
| 23:38.26 | *** join/#uphpu wps (n=wps@38.119.178.10) |
| 23:38.27 | *** mode/#uphpu [+o wps] by ChanServ |
| 23:52.18 | *** join/#uphpu drewbono (n=andrew@c-24-2-95-76.hsd1.ut.comcast.net) |
| 23:59.30 | *** join/#uphpu _psychic_ (n=_psychic@c-24-2-78-210.hsd1.ut.comcast.net) |