irclog2html for #uphpu on 20061114

00:00.06mindjujutierra, that line works for me in IE 7
00:01.00tierraI can't get it working no matter how I put it in there...
00:01.32mindjujuwow
00:01.48mindjujuhey, is the code somewhere public or can I see what you got?
00:02.06mindjujuand is it identical to the line I sent a couple of days ago?
00:03.05tierrahttp://www.phoenixcpm.com/productInfo/overview.php <- on the gray menu, the 'Overview', 'PPM in Action', etc items should highlight on hove
00:03.08tierrahover
00:04.47tierraI tried a line identical to yours first, and have tried about 20 different ways now in different orders, etc...
00:04.57mindjujusure as day
00:05.15tierrait's works perfect in Firefox and pretty much all other browsers
00:05.31tierra-'s
00:06.19tierrahmmm, I just got another hint as to why it may not be working
00:06.45tierrait'll take a minute to investigate though
00:09.09*** join/#uphpu jsmith-away (n=jsmith@h460507c2.area3.spcsdns.net)
00:09.09*** mode/#UPHPU [+v jsmith-away] by ChanServ
00:12.25tierraokay, that doesn't look like that was it
00:13.53tierraI'm determined to get this working without resorting to image replacement
00:21.46*** join/#uphpu dataw0lf (n=cyixevoa@dialup-4.245.102.80.Dial1.SanJose1.Level3.net)
00:43.17dataw0lfit's a shame that PHP doesn't use prototype based OOP, it seems more suitable than class based
00:50.53*** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net)
02:35.03*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
02:35.03*** mode/#UPHPU [+v beandog] by ChanServ
03:12.48*** join/#uphpu Utah_Dave (n=boucha@c-67-172-244-155.hsd1.ut.comcast.net)
03:12.48*** mode/#UPHPU [+o Utah_Dave] by ChanServ
03:23.43*** join/#uphpu alphahawk (n=alphahaw@207.224.222.86)
03:50.39*** join/#uphpu Utah_Dav1 (n=boucha@67.172.244.155)
03:59.55*** join/#uphpu Utah_Dave (n=boucha@c-67-172-244-155.hsd1.ut.comcast.net)
03:59.55*** mode/#UPHPU [+o Utah_Dave] by ChanServ
04:05.45*** join/#uphpu Black_Chaos (n=kevin@oalug/member/blackchaos)
04:29.17mindjujucoolio!  was just wondering who else was here
04:29.55Utah_Daveyep, just doing a little reading
04:38.11*** join/#uphpu swb (n=designsi@box41.bluehost.com)
04:40.03*** join/#uphpu Utah_Dav1 (n=boucha@c-67-172-244-155.hsd1.co.comcast.net)
04:48.08*** join/#uphpu Utah_Dav2 (n=boucha@c-67-172-244-155.hsd1.ut.comcast.net)
04:54.35*** join/#uphpu designsimply (n=designsi@box41.bluehost.com)
05:03.56*** join/#uphpu Utah_Dave (n=boucha@c-67-172-244-155.hsd1.co.comcast.net)
05:03.56*** mode/#UPHPU [+o Utah_Dave] by ChanServ
05:12.32mindjujuoh wow, there is a Utah_Dave, Utah_Dav1 and a Utah_Dav2 just left.  Will the real Utah Dave please stand up?
05:14.32Utah_DaveI'm sitting in my living room where I don't get a very good connection to my wireless
05:14.49Utah_DaveI keep losing my connection
05:17.46*** part/#uphpu swb (n=designsi@box41.bluehost.com)
05:17.56*** join/#uphpu swb (n=designsi@box41.bluehost.com)
05:25.37*** join/#uphpu el_gaucho (n=bigdog@zeus.thebigdog.biz)
05:25.37*** mode/#UPHPU [+o el_gaucho] by ChanServ
05:26.46mindjujusup, el gaucho
05:27.16el_gauchoevenin
05:27.31el_gauchohow fars tha battle?
05:27.55mindjujunot too bad, u?
05:28.19el_gauchojust starting to work tongiht
05:28.26el_gauchotook a break to watch some movies
05:28.39mindjujuyou coming on thursday?
05:28.42el_gauchonope
05:28.49el_gauchowheer?
05:29.00mindjujuuphpu meet
05:29.06mindjujuin draper
05:33.56el_gauchonope i got too much too do
05:38.22*** part/#uphpu Utah_Dave (n=boucha@c-67-172-244-155.hsd1.co.comcast.net)
05:53.55*** part/#uphpu Black_Chaos (n=kevin@oalug/member/blackchaos)
06:36.48*** join/#uphpu fungus (n=fungus@dsl.myfungus.net)
06:36.48*** mode/#UPHPU [+o fungus] by ChanServ
09:12.09*** join/#uphpu olds (i=olds@antitech.xmission.com)
14:50.32*** join/#uphpu swb (n=designsi@box41.bluehost.com)
14:58.38*** join/#uphpu jsmith (n=jsmith@h460507c2.area3.spcsdns.net)
14:58.38*** mode/#UPHPU [+v jsmith] by ChanServ
15:02.23*** join/#uphpu wps (n=wps@64.72.210.10)
15:02.23*** mode/#UPHPU [+o wps] by ChanServ
15:09.41*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
15:09.41*** mode/#UPHPU [+v beandog] by ChanServ
15:21.38*** join/#uphpu Black_Chaos (n=user@oalug/member/blackchaos)
15:29.42*** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net)
15:29.42*** mode/#UPHPU [+o Utah_Dave] by ChanServ
15:48.44*** join/#uphpu herlo (n=herlo@class1-nat.gurulabs.com)
15:48.50*** mode/#UPHPU [+v herlo] by ChanServ
16:00.23Utah_Davehey, bigdog_ut.  morning
16:00.32bigdog_utwhatz up Utah_Dave
16:01.05Utah_Davenot much, just settling down for a nice quiet morning of coding. Boss is out of town!
16:18.04*** join/#uphpu brasto (n=brasto@71-32-236-165.slkc.qwest.net)
16:18.04*** mode/#UPHPU [+v brasto] by ChanServ
16:18.45brastocan anyone tell me why this page does not work in IE:
16:18.52brastohttp://flfn.org
16:19.10brastoI get a "big white nothing"
16:19.42brastoat least it's not a "big black nothing"
16:21.14brasto~lart Utah_Dave
16:22.44Utah_Daveouch!
16:23.10brastolol, at least it's not poo this time...
16:34.32Utah_Davebrasto: I'm not sure. in IE7 nothing shows up in the browser, but the source is all there.
16:37.20brastosame for version 6 sp2
16:37.27brastoand the page validates...
16:38.03Utah_Daveyeah, I just checked the validation. I'm not sure what's going on
16:38.30brastonote to all: w3c validator says: This Page Is Valid XHTML 1.0 Strict!
16:42.25macnewboldbeandog: you awake yet?
16:42.30beandogeh
16:42.31beandogsup.
16:42.35beandogwpmu is kinda cool.
16:44.04beandogwordpress++
16:49.38*** join/#uphpu cyco|w (n=cyco@66.114.120.2)
16:52.03*** join/#uphpu swb (n=designsi@box41.bluehost.com)
16:55.54brastok, it's a css thing
16:56.43mindjujuanybody know off hand what is the equivilant of top(IE) is in FF?
17:00.08mindjujubummer, guess not
17:01.11swbin css? top is the equivalend of top in ff... or I'm probably misunderstanding your questions completely
17:01.31mindjujuin JS
17:02.01mindjujuas in top.document.form.someElement.value
17:02.21swboic, I'm not sure then
17:04.25brastowait, it's a js problem (with the flfn.org issue)
17:19.06macnewboldI thought document was a "global" and could be accessed directly anywhere?
17:19.14macnewboldi.e. top is unneeded
17:20.27mindjujudepends on what your trying to access.  if your reaching from within one iframe into another iframe or a form on the parent, you have to say which DOM your in reference to
17:22.56oldsmindjuju: I think it's 'parent' if I understand your question correctly
17:24.40mindjujuthat's what i thought initially, but parent wasn't giving me access to the parent window.  i've got an ol' javascript alchemy book with a +10 for weird DOM question somewhere
17:25.01mindjujui'll have to dig it up and see
17:29.35oldshttp://www.faqts.com/knowledge_base/view.phtml/aid/877/fid/124
17:29.36beandogholy crap
17:29.38beandogNWN2 is out???
17:29.50beandog:D
17:30.31oldshttp://www.faqts.com/knowledge_base/view.phtml/aid/981/fid/124
17:30.37oldsthose might be helpful
17:32.20mindjujuyup, i was looking at the code and I think it's window.document for moz and top.document for IE
17:37.09Utah_Davewps: did you ever find an acceptable solution for project management software?
17:41.29wpsnope
17:41.32wpsnone exist
17:41.40mindjujuoh yeah, i totally forgot that wps was looking for something for projects.  turns out i just found a new project manager.  
17:42.10mindjujuthis is new to me, http://www.vasoftware.com/sourceforge/index.php
17:42.10wpsthere are a few projects with potential, but nothing that works
17:42.40mindjujui didn't read it all, but seems to be the PM that sourceforge uses or that sf implements or something with sf
17:42.45wpseven of the for-pay software
17:43.39mindjujuthough, i think it's suppose to be a major piece of software so may be more than wps is looking for
17:49.33tierrahttp://www.phoenixcpm.com/ <- best project management software evar! ;)
17:50.02tierrathough it's not likely to be what you're looking for as it's tailors more for construction project management
17:50.06tierra*tailored
17:51.15mindjujui should of thought of phoenixcpm!
17:51.17tierrawhat exactly are you looking for as far as project management anyway?
17:52.09mindjujuwe was just working on that JS yesterday -- plus what we were talking about after the thai resturant
17:53.11oldscom4 and I are working on some project management stuff
17:54.31tierraproject management, or bug tracker? http://bbs.zzq.org/viewtopic.php?t=1617
17:54.42tierraor both?
17:55.09wpsnot bug tracking
17:55.16wpsthere are plenty of apps that do that and do it well
17:55.37tierranot really, I agree with the post I just linked, all bug trackers suck
17:55.47wpsproject management… projects… with tasks… groups… assignments… deadlines… dependancies… calendar
17:56.49mindjujuand that is oss all the way
17:59.29Utah_DaveI've been scouring the "Internets" all morning
18:21.08oldstierra: both
18:21.25oldsit started out as a bug tracker, but has sorta evolved into project management
18:29.48herloUtah_Dave: don't you mean the interwebs?
18:30.32mindjujuinterwebs?  you mean there is more than just AOL?
18:32.26herlomindjuju: of course, there's compuserve
18:34.46mindjujuwell, ya'll 'd better not say anything to my maa-maw or my paa-paw cause they's still on the web tv
18:41.58herlothis time loudly
18:41.59jsmithBut the nice thing about AOL is that they send you an entire copy of the internet on CD every month
18:42.30macnewboldoh, is that what that is? I'll have to stop incinerating those
18:42.57herlojsmith: those are nice aren't they, I use them to decorate my Christmas tree
18:48.29olds¡
18:48.32oldserrf
18:48.34oldssry
18:57.39Utah_Davemaybe we could start a UPHPU Project Management solution.  I know we kind of started something a while back as a learning experience that never really got off the ground.
18:58.09macnewbolddo you refer to Phlyte?
18:58.55mindjujuPhylte : same great name, new destination
19:01.47mindjujulet's scope it out at thursday's meeting?  we could talk at my office or we could shimmy over to cafe rio and plan there
19:02.31Utah_Daveyeah, Phlyte.  But instead of having it be a "learning experience" let's run it like a real open source project
19:14.05oldshuzzah, some competition!
19:17.49Utah_DaveI'd like some of the features of Trac, FlySpray and ScrumWiki.  I'd like subversion/cvs integration.
19:18.09oldsthat's what com4 and I were going to do as well
19:18.18Utah_DaveMaybe I should just shut up and start coding
19:18.40oldsyou're welcome to pour over our code
19:19.18oldshttp://svn.zzq.org/listing.php?repname=anabasis&path=%2Ftrunk%2F&rev=0&sc=0
19:19.36oldswe went with adodb lite to support multiple db backends
19:20.15oldswe were actually looking at doing 2 different versions, a 'lite' which is bug tracking only, and a 'pro' which has the svn integration and is more of a full featured project manager
19:20.40Utah_Daveolds: do you have a working example/demo available?
19:20.44oldscom4 wanted to do the svn integration in python, but the rest of it is php
19:20.53oldsyea, there's not much too it though
19:20.55olds1 sec
19:21.22oldshttp://projects.twi.gs/anabasis/
19:21.42oldshmm, that's a little outdated
19:21.50oldslike a few revisions back I think
19:21.57oldsmaybe not
19:24.16Utah_Daveolds: it's looking pretty good. I like the light feel of it.
19:24.27oldswe're not that far into it  
19:24.30Utah_Daveare you guys still actively developing it?
19:24.35oldsyea
19:25.11oldsthe main requirements were anonymous bug submission (obviously validated using captchas or kittenauth)
19:26.09oldslightweight, somewhat easily deployable, fast (ajaxy), and the sepereation of admins from project developers
19:28.06oldsright now we're developing it against a sqlite db
19:30.14Utah_Davecool
19:31.53oldsI think the svn integration will be the biggest pain
19:31.56oldsbut maybe not
19:57.18oldsanyone have a job opening at their place of work?
19:57.56oldshow many hours
19:58.02oldsfull time?
19:58.03jsmithDepends... part time or full time
19:58.10jsmithWe've got a couple of openings.
19:58.11olds$$?
19:58.19jsmithDepends on the job and experience, etc.
19:58.28jsmithI think we put something on our webpage about it
19:58.31oldsmore than $10 ?
19:58.31jsmithwww.sokol-associates.com
19:58.37jsmithYeah ;-)
19:59.09oldsI don't live in Kansas City
19:59.22jsmithThat's OK -- neither do I ;-)
19:59.49oldsall the jobs on that page are in KC
20:01.01oldshmph
20:01.35jsmithOh :-(
20:01.45jsmithI didn't realize that Steve had changed them to be in KC
20:02.05jsmithIf it were the right candidate, I'll be he'd let them work from anywhere.
20:02.30oldswell I don't know shit about telephony
20:02.35oldsactually I know a little
20:02.39oldsbut not enough for a job
20:03.36oldsoops, sorry 'bout the curse there
20:07.49herlojsmith: I think he said that its recommended you live in KC
20:08.14jsmithAh...
20:20.28*** join/#uphpu fungus (n=fungus@firebat.aros.net)
20:20.38*** mode/#UPHPU [+o fungus] by ChanServ
20:23.27mindjujuugh, i just got one of them calls that nobody likes to get... my little bro just wrecked my car
20:28.52jsmithInsurance?
20:28.54jsmithType of car?
20:28.58jsmithAmount of damage?
20:29.52mindjujuhaven't seen it, guess it just happened.  i've got full coverage, he's got driver's insurance so it covers him and the car he drives since he's not an owner.  Hyandai Accent 2000
20:29.52oldsno, BMW M5, catastrophic
20:30.07oldsdamn
20:30.25mindjujuyeah, bmw m5, i'd be running to the scene to kick me some butt
20:32.55oldsUtah_Dave: if you decide on doing a project manager lemme know
20:42.58brastojs gurus, anyone know what's wrong with this:
20:42.59brastohttps://flfn.org/external.js
20:43.35brastoit causes the problem i brought up earlier - big white nothing in ie, but it works fine in all other browsers
20:44.05brastothe code is to open external links (marked with rel="external") in another window.
20:44.47brastoUtah_Dave - who's our JS guru?
20:45.42bigdog_utwhy not use links
20:45.49bigdog_utdocument.links[]
20:47.07brastowps, did you look at this PM tool: http://sourceforge.net/projects/themoses/
20:47.47brastobigdog_ut - how would I use it?
20:48.28bigdog_uti would probably add an id or class on the link tag with external value
20:48.36bigdog_utand then in your for loop do
20:48.47bigdog_uti < document.links.length;
20:48.58bigdog_utand then access them with document.links[i]
20:49.11wpsthat doesn't look like a PM app
20:49.14bigdog_utthat will create a link object you can access
20:49.22wpsit says that it is a calendar server
20:50.20brastowps, i meant this: http://sourceforge.net/projects/chironcalendar/
20:50.45brastoit is also a calendar server, but it mentions projects and managing planning for several people
20:54.08oldsI would change    if (anchor.getAttribute("href")    to      if (anchor.getAttribute("href")!=null
20:58.18brastobigdog_ut, I'll look into that soon - here's my current reference:
20:59.23brastohttp://sourceforge.net/projects/chironcalendar/
21:00.54brastoolds, i just tried that - still a big white nothing in ie
21:02.37brastodoh, bigdog_ut - wrong link here's the right one:
21:02.47brastohttp://www.sitepoint.com/article/standards-compliant-world
21:04.52bigdog_utput in some alserts and see if you are even getting to the stuff in ie to do the anchors
21:05.08bigdog_uti wonder if you are returning early
21:09.31brastofound the problem
21:09.46brastoI used a self close for the <script> tag
21:09.51brastoIE didn't like that
21:09.52bigdog_utlol
21:09.55bigdog_utno it does nto
21:13.08brasto~lart Internet Explorer
21:13.59brasto~Internet Explorer
21:14.08jbotit has been said that internet explorer is browser monopolistically merged with all versions of Windows since Win95OSR2, or sometimes seen on Macs
21:24.38*** join/#uphpu beandog__ (n=sdibb@c-67-182-234-30.hsd1.ut.comcast.net)
21:25.21*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
21:25.21*** mode/#UPHPU [+v beandog] by ChanServ
21:27.09*** join/#uphpu dataw0lf (n=cyixevoa@dialup-4.245.98.204.Dial1.SanJose1.Level3.net)
21:34.20dataw0lfbleh, parked domain
21:34.55dataw0lfanyone know of a PHP equivalent to the Python Challenge?
21:35.11oldsgo home n3wb
21:35.15*** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a)
21:35.15*** mode/#UPHPU [+o fungus] by ChanServ
21:35.48dataw0lfolds: y u so meen to me?
21:36.38brastoanybody know of php calendar software that automatically creates synced ics files?
21:37.07oldssynced?
21:37.08fungusphpicalendar is the only app I have tried.
21:37.22oldsI use Google Calendar, and I know you can export to ics
21:37.39oldsbut that's not really what you're looking for
21:38.22dataw0lfical produces ics files, doesn't it?
21:38.47oldsyea
21:39.16dataw0lfk
21:39.29Utah_Davedataw0lf: I haven't heard of something like the Python Challenge for PHP. That would be really cool. I started the Python Challenge a while back, it was fun
21:39.47dataw0lfphpchallenge.com is parked so *shrug*
21:39.56dataw0lfit would be nifty.
21:39.56oldsmacnewbold: I can do a tiny little presentation on differences between sqlite and mysql functions
21:40.03macnewboldwhat what?
21:40.18macnewboldah, on thursday?
21:40.22oldsI was just looking at the mailing-list about the meeting this thursday
21:41.42wpsmacnewbold: you want to send me a description of your presentation for me to put up on the site and to send out in an email?
21:44.48oldshttp://www.slcairport.com/
21:44.49oldspwnd
21:46.43dataw0lfI love how rednecks say 'diabetes'
21:47.29dataw0lfaww, slcairport is having problems with XML DOM.  That's a shame.
21:48.13oldsanyone know much about this agencyfusion.com place that posted a job on the board?
21:50.18macnewboldwps: I'd love to, if I could describe it, but so far I haven't even had time to decide what's in and what isn't
21:50.18dataw0lfagencybyte.com
21:50.40macnewboldolds: someone who worked there was at a UPHPU meeting several months ago
21:50.54macnewboldbut I don't know much more than what I've seen on their web site and in their job postings
21:50.59oldsyea
21:51.06oldsI think I'm going to send in my application
21:51.15macnewboldif you want to apply there, let me know, and I can refer you through a friend who knows the bossman
21:51.21oldsok
21:51.57oldsmy current job is kindof dailywtf.com appropriate
21:52.22oldserr
21:52.24dataw0lfheh, yea, mine too.
21:52.25oldsthedailywtf.com
21:54.19dataw0lfyesterday's dailywtf was loltastic.
21:54.20oldsplus that agencyfusion place is less than 15 blocks from my house
21:54.23oldsyea it was
21:55.13oldsRight now the entire operation at my work (not the web stuff) is done with Filemaker
21:55.24oldsall orders, accounting, etc
21:56.06dataw0lfjeez, I remember FileMaker from, like, the early nineties.
21:57.48brastoolds, by "synced" I mean "synchronized"
21:58.22oldsYea, I got that, I'm just not sure exactly what you mean
21:58.27brastodataw0lf, is ical open source, something i can download?
21:58.47dataw0lfphpicalender.net
21:59.05oldshttp://www.apple.com/macosx/features/ical/
21:59.07oldsthat's iCal
21:59.25macnewboldbrasto: ical is also a format for transferring calendar data
21:59.44macnewboldused by iCal, google calendar, outlook, phpicalendar.net, etc
22:02.06bigdog_utjsmith you there?
22:02.18jsmithI am here!
22:02.22dataw0lfyay!
22:02.35oldsThis is annoying. The UofU isn't offering Discrete Structures in the Spring.
22:03.17*** join/#uphpu cyco|w_ (n=cyco@66.114.120.2)
22:03.53brastoright, they made the standard for ics files - but i thought it was proprietary only for macs
22:04.23jsmithNope.
22:04.28brastoabove comment ^^^ was for macnewbold
22:06.09brastoolds, i mean that it uses a db backend, but also has an ical file synchronized with the web output generated from the db.
22:07.44brastomacnewbold - i don't have a mac, and it looks like ical is only for mac users
22:07.50macnewboldyeah, .ics files are often called "ical" format, as opposed to the "vcal" format
22:08.03macnewboldiCal the apple application is for macs only, yes
22:08.20macnewboldbut the format is accepted by many other calendar apps
22:08.43wpsbrasto: Apple iCal, Mozilla Calendar, Ximian, Evolution, KOrganizer, WinDates 5.0
22:08.46brastoright, that's why i want to use it with whatever php-driven calendar app i use
22:09.08brastobrb in 15 min
22:10.13dataw0lfwouldn't any ics producing application 'sync' it, by your definition then?
22:10.53dataw0lfI dunno, I use a calendar 'book'.  I update it with a 'pen'.  So I haven't worked with calendar formats much.
22:11.43macnewboldI'm not sure what brasto means by "software that automatically creates sync'd ics files"
22:11.54dataw0lfusing AJAX and wanting to update the clientside file every time the XML request is sent?
22:12.06Utah_DaveSQL question:
22:12.15Utah_DaveI have a result set that has a timestamp in each row.
22:12.25Utah_DaveIs it possible to have sql calculate the difference in seconds between the timestamp in each row and the timestamp in the row before it?
22:12.31Utah_DaveRight now I'm doing all the calculations in php, but it would be nice to have it done by the DB server.
22:12.42dataw0lfsure, you could do that.
22:13.02Utah_DaveI'm using mysql.  dataw0lf: how would I refer to the previous or next row?
22:13.09dataw0lfPL/SQL, you mean?
22:13.24dataw0lfMySQL, MySQL.. autoincrementing primary id?
22:14.08Utah_Daveno, just a normal select query
22:14.26Utah_Davesay I get back 4 rows
22:14.29Utah_Daveeach row has a timestamp
22:14.44dataw0lfwhat I mean is, have you produced the table with an autoincrementing primary id?
22:14.50Utah_Daveyes
22:15.11Utah_Daveyes, it has an autoincrementing primary id
22:15.18wpsmeeting Thursday @ 7: Database Design  |  UPHPU  |  uphpu.org
22:15.24dataw0lfput the logic in some sort of PL script to just look at the previous id then, etc
22:15.27*** topic/#UPHPU by wps -> meeting Thursday @ 7: Database Design | UPHPU | uphpu.org
22:16.02Utah_Daveok, so a stored procedure?  I can't figure out how to do it with a select statement
22:17.32oldsUtah_DAVE
22:17.40dataw0lfa UDF, or whatever
22:17.42oldserr Utah_Dave
22:17.51Utah_Daveok
22:17.55Utah_Daveolds: what's up/
22:17.56Utah_Dave?
22:18.16oldsyou should be able to do it like this
22:18.58olds(this is going to take a second to write)
22:19.49Utah_Daveok
22:22.21oldsSELECT TIMESTAMPDIFF(MINUTES,t1.timestamp_field,t2.timestamp_field), t1.id, t2.id FROM table AS t1, table AS t2 WHERE t1.id+1 = t2.id ORDER BY t1.id;
22:23.51Utah_Davesweet, let me go try that
22:24.06oldsthat might be a little bit off, but that's the idea
22:30.27dataw0lfgood job good job
22:31.27jsmith~wake bigdog_ut
22:31.37jbotACTION throws a barrel-full of ice water on bigdog_ut and shouts "GOOD MORNING!!!!"
22:32.28bigdog_ut~wake jsmith
22:32.30jbotACTION throws a barrel-full of ice water on jsmith and shouts "GOOD MORNING!!!!"
22:32.36dataw0lfhe's probably chasing down a shoplifter.  Over achiever.
22:32.39dataw0lfoh, nevermind.
22:33.40oldsmysql> SELECT TIMESTAMPDIFF(SECOND,t1.time,t2.time) AS difference FROM example AS t1, example AS t2 WHERE t1.id+1 = t2.id;
22:33.43oldsthat worked
22:33.47oldsjust tested it
22:34.11dataw0lfolds: ever seen Silver City?
22:34.22olds| 2006-11-14 15:31:47 |
22:34.22olds| 2006-11-14 15:31:53 |
22:34.23olds| 2006-11-14 15:31:47 |
22:34.23olds| 2006-11-14 15:31:53 |
22:34.25oldswoops
22:34.28oldsthose are the values
22:34.33oldsSilver City?
22:34.35herlodataw0lf: Silver City is out near Little Sahara
22:34.46dataw0lfit's a movie.
22:34.56oldsnope never seenz it
22:35.06dataw0lfyou should
22:35.39oldsUtah_Dave: there's a bunch of different ways to calculate time stamp differences in mysql, but I prefer the TIMESTAMPDIFF
22:36.42*** join/#uphpu dataw0lf- (n=cyixevoa@dialup-4.255.161.245.Dial1.SanJose1.Level3.net)
22:36.56dataw0lf-jiminy christmas, can I get some real internetz plz.
22:37.04oldsu suk
22:37.07olds:)
22:37.30dataw0lf-for a lil cash, yea.  
22:37.37dataw0lf-ha.  just kidding.
22:37.43dataw0lf-It's a John Sayles movie
22:37.45oldsno you're not
22:38.36dataw0lf-I'm in Nevada, draw your own conclusions.
22:38.51oldswhy Nevada?
22:39.17dataw0lf-good job here, like the Sierra Nevadas, I'm 15 miles from Tahoe, etc.
22:39.55oldswhich means you're close to Reno
22:40.29dataw0lf-I'm 5 miles outside of town
22:40.39dataw0lf-on the Mt Rose Hwy
22:40.42dataw0lf-which leads to Tahoe
22:43.08herlodataw0lf: it's also a township with no services on the way to Delta from Eureka in Utah
22:43.11brastomacnewbold, dataw0lf, olds, here's what I mean.  I want a web app, like webcalendar, that primarily uses MySQL, but generates ics files on the fly - like how phpGedView uses a database for its web pages, but automatically keeps an updated gedcom file.
22:43.44macnewboldah, okay,
22:43.50macnewboldso a web app that manipulates ICS files
22:44.02oldsbasically like google calendar
22:44.04macnewboldI'd use Google Calendar for that
22:44.26dataw0lf-herlo: intriguing!
22:44.59dataw0lf-never managed to get to Little Sahara
22:45.09oldsit's cool
22:46.07dataw0lf-I've been to the Big Sahara.  I don't like deserts, it's like all the cons of a beach and none of the pros
22:46.46brastoi'll have to look into google calendar more...
22:48.46dataw0lf-you know the Republicans are hurting if they're looking at Giuliani
22:48.55brastoUtah_Dave - you can compare one row to another row in a select statement with dataseek
22:49.22Utah_Daveolds: so does that query compare the timestamps from different rows?
22:49.32oldsyes
22:49.37oldsand returns the differences
22:49.41olds*difference
22:49.48oldsyou can do multiple though
22:51.48oldshttp://pastebin.ca/248716
22:52.39oldsthe value field does nothing
22:53.17dataw0lf-I hate misspellings in code.
22:53.34oldsdid I mispell something?
22:53.48dataw0lf-oh, no, talking about this code I'm auditing.
22:53.57dataw0lf-"$retern_val" ..
22:54.01oldsugh
22:54.02dataw0lf-things of this nature.
22:54.12oldsUtah_Dave: does that make more sense?
22:54.53oldsthere, formatted better: http://pastebin.ca/248719
22:57.49Utah_Davethat looks pretty good. It's working.  my problem now is that the id's aren't necessarily in numerical order and there may be gaps in the ID's due to people deleting events, etc
22:58.37oldsahh
22:58.49Utah_DaveI need to refer to the next row, regardless of the id num
23:00.41oldsyea
23:00.44oldslemme think of something
23:00.45Utah_Daveis it possible to give each row an autoincrementing number that numbers each row starting with 1?
23:00.56Utah_Davethen use that row number to do the comparison
23:02.09oldssure
23:02.19oldshow big is the table
23:03.18Utah_Daveright now it's about 200,000 rows. It grows by about 100,000 rows a year
23:06.29oldsgot it
23:06.47oldschange the last part of it to this:
23:06.48oldsWHERE t1.id<t2.id GROUP BY t1.id;
23:08.11macnewboldUtah_Dave: I don't know that you'll find a good and efficient way to do it in SQL, but doing it in PHP should be pretty easy, and more flexible
23:08.44oldshttp://pastebin.ca/248733
23:09.16oldsUtah_Dave: I assume that's what you were looking for
23:10.08Utah_Daveolds: sweet. that's exactly what I wanted
23:12.35Utah_Davedo I need the Group By?
23:12.43Utah_Daveor should that be ORDER BY
23:14.17oldsyou need the group by
23:14.34oldsotherwise it will calculate the difference between every other row
23:15.52oldshmmm, kinda does some weird stuff with lotsa rows
23:17.13Utah_Daveok
23:17.29Utah_DaveI'm testing some variations
23:17.38oldsthere we go
23:17.49oldsI got it (again)
23:18.27oldshttp://pastebin.ca/248737
23:18.59oldsuses a subselect
23:19.55oldshttp://pastebin.ca/248740   <-- that's the weirdness I was encountering
23:20.09macnewboldouch
23:20.13macnewboldbut not as bad as I thought it would be
23:20.28oldsThe Concat makes it uglier than it is
23:20.29olds;)
23:20.32macnewboldI wonder what the performance is like on 100,000 rows....
23:20.42oldsyea
23:20.46oldskinda curious myself
23:27.42Utah_Davesure is taking a long time
23:28.45Utah_Davea lot faster from the command line.
23:29.47olds100,000 rows inserted :)
23:31.01oldsis it for specific date ranges?
23:31.40Utah_Daveyeah
23:31.57Utah_Davewhat if we compared the timestamp fields instead of the id?
23:32.11oldshmmm
23:37.10oldsok
23:37.41oldshttp://pastebin.ca/248752
23:37.45oldstake out the GROUP BY
23:37.54oldsit's not necessary since we're using the subselect
23:38.26oldsand the LIMIT in the subselect isn't necessary
23:38.31oldsit doesn't actually do anything
23:38.39oldsI don't know why I put it in there :)
23:38.57olds(this is on the table with 100,000 rows)
23:40.11Utah_Daveok, just a sec
23:43.30Utah_Davewhy do you have a limit clause in the sub select?
23:43.43Utah_Daveis that so you're not comparing the whole table?
23:45.18oldssee above
23:45.24olds16:38 < olds> and the LIMIT in the subselect isn't necessary
23:45.24olds16:38 < olds> it doesn't actually do anything
23:45.24olds16:38 < olds> I don't know why I put it in there :)
23:45.55Utah_Daveoh, duh.  thanks
23:49.44Utah_Daverock on. I added the userid to the where clause on the subselect and and the query and it worked perfectly. and in 0.0010 seconds
23:49.54Utah_Daveawesome. Thanks for the help olds
23:50.42oldsnp
23:51.01Utah_Daveno wait, 0.8274 seconds.  But that's still plenty fast for what I'm doing with it.
23:51.40oldsmacnewbold: see, it can be done! ;)
23:52.42dataw0lf-.8274 seconds?  yech
23:54.02olds5 rows in set (14.68 sec)
23:54.37oldson a G5 w/2.5 GB of rams
23:55.48Utah_Daveolds: it's working great. I'm going to experiment some more for speed, but it's getting what I need.
23:56.08oldsk cool
23:56.51oldsI find calculating time differences is leaps  and bounds easier in mysql than in php
23:57.00Utah_Daveby limiting to the day view that I'm creating it drops it to 0.0827 seconds
23:57.21Utah_Davevery nice.
23:57.24dataw0lf-I guess it depends on the database, really.
23:57.33dataw0lf-I wouldn't throw that in a heavy duty database.
23:57.49Utah_DaveThanks olds.  I had pretty much given up before I asked about this in here
23:58.01oldsUtah_Dave: find me a job!
23:58.03olds:)
23:58.04Utah_Davejust in time to go home
23:58.14*** part/#uphpu Black_Chaos (n=user@oalug/member/blackchaos)
23:58.31Utah_DaveI'll keep my eyes open!  have you looked at the AxisPointe offer?  There's been a couple offers that I've looked at
23:58.58oldsAxisPointe? Is it on the uphpu job board?
23:59.43Utah_DaveI'm not sure, but it was sent out in the UPHPU jobs announce email list

Generated by irclog2html.pl by Jeff Waugh - find it at freshmeat.net! Modified by Tim Riker to work with blootbot logs, split per channel, etc.