| 00:04.11 | wps | Utah_Dave, it comes in the phpicalendar package |
| 00:05.57 | wps | Utah_Dave, what was that question that you asked the other day about the XHTML diddy that I posted on the site? |
| 00:08.43 | wps | ~uphpu archives |
| 00:08.45 | jbot | somebody said uphpu archives was http://ibot.rikers.org/%23uphpu/, or http://uphpu.org/pipermail/uphpu/ |
| 00:09.25 | Utah_Dave | wps: thanks I found the phpicalendar package. I'm having problems getting it to work with evolution. |
| 00:10.13 | Utah_Dave | wps: as far as the XHTML. I was wondering if you did all the css files by hand, or if you had some nifty program to help you |
| 00:10.21 | wps | ah, yes |
| 00:10.26 | wps | yes, absolutely by hand |
| 00:10.31 | wps | there is no other way to code |
| 00:10.42 | wps | a program could never generate that kind of code |
| 00:11.16 | Utah_Dave | that's what I thought |
| 00:11.56 | wps | and I don't mean that in an arrogant way… it's just that good web design is custom, creative and cannot be generated |
| 00:12.23 | Utah_Dave | yeah |
| 00:12.25 | wps | if you are just slicing up images and slamming them into a one dimensional table… sure… use DreamWeaver |
| 00:12.51 | wps | but good web design is multi-dimensional and requires a different way of thinking |
| 00:13.07 | wps | and what I did there is barely an example of that, as it's not very complex |
| 00:13.20 | wps | most people have been and continue to approach the web in the wrong way |
| 00:14.29 | Utah_Dave | wps: as far as the WebDav to publish free/busy in Evolution. I'm using "http://www.mysite.us/users/david/cal/calendar/publish.ical.php" to publish to, but it's not working. |
| 00:14.49 | Utah_Dave | did you run into any issues using phpicalendar publish? |
| 00:15.25 | wps | now, but you have to configure it correctly |
| 00:16.35 | wps | did you configure config.inc.php ? |
| 00:16.47 | Utah_Dave | yeah, but I'd better check it again |
| 00:17.01 | wps | make sure that permissions are correct too |
| 00:25.53 | *** part/#uphpu Utah_Dave (n=boucha@0-2pool130-200.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 01:52.22 | *** join/#uphpu wps (n=wade@65.73.113.199) |
| 01:52.25 | *** mode/#uphpu [+o wps] by ChanServ |
| 05:35.09 | diskotec|w | anyone around? |
| 05:36.23 | *** join/#uphpu drewbono (n=andrew@c-24-2-95-76.hsd1.ut.comcast.net) |
| 05:37.48 | diskotec|w | drewbono...gotta minute?...or two? |
| 05:38.04 | drewbono | sure |
| 05:38.15 | drewbono | maybe even three |
| 05:38.16 | drewbono | :-) |
| 05:39.43 | wps | uphpu.org is doing better than ever in google |
| 05:39.47 | diskotec|w | in sql (specifically mssql) I've done a trace and found the use of *= and =* after the WHERE part of the statement....I thought anything after the WHERE part was supposed to be a condition...? If those are conditions I guess I don't understand what they do. (*= and =*) |
| 05:40.52 | diskotec|w | wps: cool....wish I knew enough to contribute :| |
| 05:41.12 | wps | ~google carrot |
| 05:41.53 | wps | that's too bad that jbot lost his googling powers |
| 05:42.12 | drewbono | diskotec|w: you got me |
| 05:42.12 | diskotec|w | jbot is google challenged I guess |
| 05:42.27 | diskotec|w | drewbono: ok...thanks anyway |
| 05:42.41 | wps | jbot's father banned him from googling |
| 05:42.46 | wps | he used to do it |
| 05:42.50 | drewbono | wps: was jbot googling for naughty things and got a filter smacked down on him? |
| 05:43.05 | wps | I heard that tim turned it off |
| 05:43.14 | wps | I guess it was too much load or something |
| 05:44.19 | diskotec|w | wps: do you know sql? If so, what are *= and =* supposed to do? The more I read about them the more I get confused. |
| 05:44.44 | wps | sorry man, my SQL skills are probably the weakest of anyone in the channel |
| 05:44.51 | wps | well, except jbot |
| 05:44.54 | wps | jbot is a hoser |
| 05:44.58 | diskotec|w | uh...sorry but I think I own that title already |
| 05:45.09 | wps | jbot, pick your nose |
| 05:45.21 | diskotec|w | heh |
| 05:45.26 | wps | jbot, go to sleep |
| 05:45.27 | jbot | go to sleep is, like, time to put your head down and dream |
| 05:46.18 | diskotec|w | what time does bigdog normally get here? |
| 05:48.08 | wps | not sure if he has a normal, but he did say that he'd be online later tonight, so he might show in a little bit |
| 05:48.21 | diskotec|w | thanks |
| 06:01.35 | *** join/#uphpu tierra (i=tierra@ibaku.net) |
| 06:01.36 | RyanE | diskotec|w: The *= and =* are Inner and Outer Joins |
| 06:01.58 | RyanE | they're nonstandard operators, usually used in older SQL. |
| 06:02.04 | RyanE | http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_4ox9.asp |
| 06:03.04 | RyanE | oops: they're both outer joins... |
| 06:03.14 | RyanE | the *= is a Left outer join, the =* is a Right outer join. |
| 06:03.31 | *** join/#uphpu tierra (i=tierra@ibaku.net) |
| 06:03.37 | RyanE | "Note Using this syntax for outer joins is discouraged because of the potential for ambiguous interpretation and because it is nonstandard. Instead, specify joins in the FROM clause." |
| 06:03.48 | RyanE | http://doc.ddart.net/mssql/sql70/sa-ses_3.htm |
| 06:07.23 | diskotec|w | RyanE: thanks, I did a trace and saw them in the WHERE part of the statement...software company programmed this report using *= and =* thanks for that reference....the docs I'm reading are confusing me...I'll read over the link you gave. |
| 06:10.38 | RyanE | ok. I'm pretty rusty on outer joins, but if you have any questions, go ahead and post 'em. |
| 06:10.49 | RyanE | outer joins are commonly used in reports... |
| 06:11.20 | RyanE | It allows for rows to be returned when a match is not found in one of the tables. |
| 06:12.15 | RyanE | i.e. let's say you have an Employee and their Work Dates. If you left outer join on Employee with Work Date, you show ALL employees, even if they don't have work dates in the where of work dates > some date... |
| 06:14.22 | diskotec|w | Employee and Work Dates are columns though...right? |
| 06:14.27 | RyanE | no, tables. |
| 06:14.44 | RyanE | they'd join on a column like EmployeeID |
| 06:18.06 | diskotec|w | heh...learning sql was easy until I got to joins =) (then again maybe trying to learn about joins by looking at these traces isn't a good idea) |
| 06:19.29 | RyanE | outer joins are quite different than 'regular' joins. |
| 06:19.34 | RyanE | and do take some learning |
| 06:19.37 | RyanE | but they can be handy. |
| 06:23.13 | RyanE | do you understand what I wrote above about how the outer joins work? |
| 06:24.37 | RyanE | want an example? |
| 06:25.02 | diskotec|w | at this point, I think I can say...I think so. heh. I'm going to read more on that page you referenced |
| 06:25.52 | RyanE | the way you do them in MySQL is like: select E.EmployeeID, E.Name, W.Start, W.End from Employee E LEFT JOIN WorkHours W on E.EmployeeID = W.EmployeeID |
| 06:26.22 | RyanE | you combine LEFT JOIN with 'on', instead of where E.EmployeeID *= W.EmployeeID |
| 06:26.33 | RyanE | I'm not sure how 'standard' MSSQL does it. |
| 06:30.28 | diskotec|w | columns you join probably have to be of the same type...right? (date, text x characters long, etc) |
| 06:30.52 | diskotec|w | not sure if I used the right terminology there |
| 06:30.53 | RyanE | yeah, if they aren't the same, one of them would have to be converted, which would likely cause a table scan. |
| 06:31.26 | RyanE | in other words, if you have a column that has to be converted, it won't use an index, because all the values have to be converted |
| 06:31.39 | RyanE | best to join on int IDs |
| 06:32.13 | RyanE | unique, indexed ints |
| 06:36.10 | diskotec|w | Thanks RyanE. I'm understanding it little by little. Time to go home now. I'll post questions tomorrow if I have any. |
| 06:36.21 | RyanE | ok. Later. |
| 15:07.24 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 15:34.16 | *** join/#uphpu dataw0lf (n=dataw0lf@66.219.227.114) |
| 16:02.57 | *** join/#uphpu wps (n=wade@38.119.178.10) |
| 16:03.00 | *** mode/#uphpu [+o wps] by ChanServ |
| 16:18.07 | *** join/#uphpu Utah_Dave (n=boucha@0-2pool130-238.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 16:34.33 | *** join/#uphpu jsmith (n=jsmith@64.0.193.147) |
| 16:36.50 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 17:29.49 | *** join/#uphpu jakea (n=jakea@128.187.163.84) |
| 17:57.59 | *** join/#uphpu Alphahawk (n=Alphahaw@70.56.105.158) |
| 19:07.46 | *** join/#uphpu fungus (n=fungus@firebat.aros.net) |
| 19:39.45 | *** join/#uphpu RyanE (n=ryan@rberick.dsl.xmission.com) |
| 21:02.22 | *** join/#uphpu osynic (n=synic@pdpc/supporter/student/synic) |
| 21:10.30 | *** join/#uphpu osynic (n=synic@pdpc/supporter/student/synic) |
| 22:14.29 | *** join/#uphpu Alphahawk (n=Alphahaw@70.56.105.158) |
| 22:16.31 | Alphahawk | question hoping someone might be able to answer here. I had a hdd crash with some mysql tables on it. I recoverd the files and now want to bring them into another mysql data base. Can anyone direct me as to where I can read up on how to do this? |
| 22:17.16 | synic | pretty sure you just need to put the files in the correct directory |
| 22:17.47 | Alphahawk | ok |
| 22:22.48 | RyanE | Alphahawk: I just had that happen to me. Fortunately, I had a nightly backup, and just backed up from that. It's a good idea to make a cron entry that does a dump of the database daily during a slow time... |
| 22:22.58 | RyanE | s/backed up/restored/ |
| 22:23.28 | Alphahawk | ya I know but unfortuanly I didnt realize this one was not being backed up |
| 22:23.51 | Alphahawk | Lost the whole hdd and had to use data recovery software and was able to get mysql files from it |
| 22:24.01 | RyanE | ouch. I didn't even *remember* that mine backs up nightly until I realized that it was damaged after this morning's power outage |
| 22:24.16 | RyanE | hope it works out for you. |
| 22:31.37 | Alphahawk | thanks synic it worked |
| 22:31.44 | synic | np |
| 23:16.49 | *** join/#uphpu synic (n=synic@66.239.17.226.ptr.us.xo.net) |