Session Start: Thu Aug 22 00:00:00 2013
Session Ident: #glitchpc
[00:00] * Now talking in #glitchpc
[00:00] * Topic is 'Welcome to #glitchpc chat. Profanity, trolls, and impersonation are not welcome here. Street1 has become a Silent Keyboard. http://www.legacy.com/obituaries/savannah/obituary.aspx?page=lifestory&pid=139870551'
[00:00] * Set by jacky on Tue Mar 02 11:03:23
[03:09] * PCdoc (PCdoc@D1BF5531.77B5DD9.EE292452.IP) has joined #glitchpc
[03:21] * KindOne (KindOne@75DAB6AE.458262ED.90984A5.IP) Quit (Ping timeout)
[03:24] * KindOne (KindOne@2ADC7812.869FE2D2.90984A5.IP) has joined #glitchpc
[03:58]<jamer> Morning camerongrey
[05:10] * Zuwer (Mibbit@mib-9196E61D.jetstream.xtra.co.nz) Quit (Quit: http://www.mibbit.com ajax IRC Client)
[05:30]<jamer> Heh ive got my interview today
[06:21] * KindOne (KindOne@2ADC7812.869FE2D2.90984A5.IP) Quit (Ping timeout)
[06:24] * KindOne (KindOne@mib-8DAFB4EC.dynamic.ip.windstream.net) has joined #glitchpc
[06:24] * Steimey (uid8068@mib-DEE87C23.irccloud.com) has left #glitchpc
[06:32] * Erlend (erlend@mib-8D855F84.kylatee.kodu.ee) has joined #glitchpc
[06:32] * Erlend (erlend@mib-8D855F84.kylatee.kodu.ee) Quit (Quit: Off to gym, it's time to lift some iron!)
[06:33] * BC_Programmer (BC_Program@13DD81E6.53558F13.6889CB60.IP) has joined #glitchpc
[06:34] * BC_Programming (BC_Program@13DD81E6.53558F13.6889CB60.IP) Quit (Ping timeout)
[06:34] * BC_Programmer (BC_Program@13DD81E6.53558F13.6889CB60.IP) Quit (Connection reset by peer)
[06:34] * BC_Programming (BC_Program@13DD81E6.53558F13.6889CB60.IP) has joined #glitchpc
[06:34] * ChanServ sets mode: +a
[06:34] * ChanServ sets mode: +o BC_Programming
[07:31] * Nat (nat@mib-921C62AC.socal.res.rr.com) Quit (Quit: zzzZZZzzzZZzzZZZzz)
[07:39] * Kevin (Mibbit@mib-C554203.dhcp.aldl.mi.charter.com) has joined #glitchpc
[08:06] * PCdoc (PCdoc@D1BF5531.77B5DD9.EE292452.IP) Quit (Ping timeout)
[08:09] * PCdoc (PCdoc@D1BF5531.77B5DD9.EE292452.IP) has joined #glitchpc
[08:40]<@BC_Programming> today seems like it's going to be rather SQL Heavy
[08:45] * jacky (the_kink@mib-7B305BF7.slsbmd.east.verizon.net) has joined #glitchpc
[08:45] * ChanServ sets mode: +q
[08:45] * ChanServ sets mode: +o jacky
[08:45] * ChanServ sets mode: -q
[09:18] * PCdoc (PCdoc@D1BF5531.77B5DD9.EE292452.IP) has left #glitchpc (Leaving)
[10:47] * jacky (the_kink@mib-7B305BF7.slsbmd.east.verizon.net) has left #glitchpc
[11:42]<@BC_Programming> hey who wants to see a ridiculous query
[11:43]<@BC_Programming> BEHOLD
[11:43]<@BC_Programming> http://pastebin.com/wzSacgFq
[11:44]<+camerongray> Nice!
[11:44]<+camerongray> I've got some pretty crazy ones at work too
[11:44]<@BC_Programming> this is one I made lol
[11:44]<+camerongray> Same :P
[11:44]<+camerongray> What database is it?
[11:44]<@BC_Programming> Postgres
[11:44]<+camerongray> Oh nice, me too :D
[11:45]<+camerongray> Postgres buddies! *High Five!*
[11:45]<@BC_Programming> lol
[11:45]<@BC_Programming> the BASIC is pretty bad for DB calls... Fields can ONLY be indexed by integers, and there are no queries
[11:46]<@BC_Programming> oh
[11:46]<@BC_Programming> the $P{reportdate} is for Jasper Reports
[11:47]<+camerongray> Here's one - http://pastebin.com/MLr5DyDt
[11:47]<+camerongray> And yes, that comment is actually there in the code!
[11:47]<+camerongray> I ended up splitting it up and building the query using PHP to make it possible to read!
[11:48]<@BC_Programming> thankfully the queries I make are going into Report files
[11:48]<+camerongray> And here's a regular query: http://pastebin.com/52NKhBfR
[11:48]<+camerongray> The '?' are later filled with values in PHP
[11:48]<@BC_Programming> sounds like you need a reporting framework
[11:49]<+camerongray> So fun running a query like that and it actually works!
[11:49]<+camerongray> This is going into an application
[11:50]<@BC_Programming> "Had breakfast wt Jamie yesterday and everybody is impressed with your attitude and efforts. Glad to have you with us." << From Company Owner on skype
[11:50]<+camerongray> Nice!
[11:50]<@BC_Programming> I definitely need a second monitor though haha
[11:51]<+camerongray> Oh yeah, we all have two at work
[11:51] * pottsi (Mibbit@pottsi.staff.mibbit.net) has joined #glitchpc
[11:51]<+camerongray> Except for me with my two laptops and two external monitors on my ThinkPad :P
[11:51] * ChanbotVII sets mode: +v pottsi
[11:51]<+camerongray> The application basically pulls data from all different sources - Google Analytics, Sitecatalyst, Excel files.etc and puts it into a single standardised database view for software such as Tableau to allow loads of different sources be used in a single interactive dashboard.
[11:51]<@BC_Programming> I guess I can get one when I get paid though, since that's going to be a thing now
[11:51]<+camerongray> This is it: http://www.datameld.net/
[11:52]<@BC_Programming> I'm tempted to stick my GenericListViewSorter class in the Report Lookup Form
[11:52]<@BC_Programming> see if anybody notices the Listview suddenly being awesome
[11:53]<+camerongray> lol!
[11:54]<+camerongray> I'm pretty much the only developer on it which is good in a way but a pain if you get stuck on something
[11:54]<@BC_Programming> yeah I wouldn't have even been able to file hours without having my hand held
[11:54]<@BC_Programming> I can do it now though which is pretty cool
[11:55]<@BC_Programming> moving around the THEOS system like a boss now
[11:56]<@BC_Programming> oh haha... I did end up refactoring the Report Filter C# program, though my excuse is I had to work with it and it was getting annoying
[11:58]<+pottsi> you should link that go picture to the sign up
[12:04]<+camerongray> pottsi: lol yeah
[12:04]<+camerongray> I didn't do the site though
[12:04]<+pottsi> o
[12:04]<+pottsi> kk
[12:18] * pottsi (Mibbit@pottsi.staff.mibbit.net) Quit (Quit: http://www.mibbit.com ajax IRC Client)
[12:28] * pottsi (Mibbit@pottsi.staff.mibbit.net) has joined #glitchpc
[12:29] * ChanbotVII sets mode: +v pottsi
[13:29] * pottsi (Mibbit@pottsi.staff.mibbit.net) Quit (Quit: http://www.mibbit.com ajax IRC Client)
[13:33] * Magiobiwan (MagiYoda@F43D26AE.8084B232.6BB5DEE6.IP) Quit (Ping timeout)
[13:36] * Magiobiwan (MagiYoda@F43D26AE.8084B232.6BB5DEE6.IP) has joined #glitchpc
[13:46] * Erlend (erlend@mib-8D855F84.kylatee.kodu.ee) has joined #glitchpc
[14:11] * Magiobiwan (MagiYoda@F43D26AE.8084B232.6BB5DEE6.IP) Quit (Ping timeout)
[14:14] * Magiobiwan (MagiYoda@F43D26AE.8084B232.6BB5DEE6.IP) has joined #glitchpc
[14:28]<@BC_Programming> hey camerongray think you could help with some SQL?
[14:39] * Erlend (erlend@mib-8D855F84.kylatee.kodu.ee) Quit (Quit: Off to gym, it's time to lift some iron!)
[15:51]<+Tux2> What help with mysql are you needing BC_Programming?
[15:52]<@BC_Programming> actually it is postgres and one of my co-workers is helping as well, I think we sussed the problem
[15:52]<@BC_Programming> it was a perf issue that brought the server to it's knees because of too many Joins
[15:52]<@BC_Programming> cross-joins no less
[15:56]<+Tux2> ugh
[15:56]<@BC_Programming> I managed to fix it by learning how to use joins properly through google, haha
[15:57]<@BC_Programming> explicit inner joins
[15:57]<+Tux2> nice!
[16:01]<@BC_Programming> well that fixed that issue, the data is still not right
[16:37] * Steimey (uid8068@mib-DEE87C23.irccloud.com) has joined #glitchpc
[19:08] * Magiobiwan (MagiYoda@F43D26AE.8084B232.6BB5DEE6.IP) Quit (Ping timeout)
[19:11] * Magiobiwan (MagiYoda@F43D26AE.8084B232.6BB5DEE6.IP) has joined #glitchpc
[19:19] * Nat (nat@mib-921C62AC.socal.res.rr.com) has joined #glitchpc
[20:06] * Magiobiwan (MagiYoda@F43D26AE.8084B232.6BB5DEE6.IP) Quit (Quit: Bai!)
[20:33] * Magiobiwan (MagiYoda@F43D26AE.8084B232.6BB5DEE6.IP) has joined #glitchpc
[21:05] * Zuwer (Mibbit@mib-9196E61D.jetstream.xtra.co.nz) has joined #glitchpc
Session Start: Thu Aug 22 21:30:19 2013
Session Ident: #glitchpc
[21:30] * Now talking in #glitchpc
[21:30] * Topic is 'Welcome to #glitchpc chat. Profanity, trolls, and impersonation are not welcome here. Street1 has become a Silent Keyboard. http://www.legacy.com/obituaries/savannah/obituary.aspx?page=lifestory&pid=139870551'
[21:30] * Set by jacky on Tue Mar 02 11:03:23
[21:30] * ChanServ sets mode: +a
[21:30] * ChanServ sets mode: +o ChanbotVII
[21:33] * Kevin (Mibbit@mib-C554203.dhcp.aldl.mi.charter.com) Quit (Quit: http://www.mibbit.com ajax IRC Client)
Session Start: Thu Aug 22 21:45:17 2013
Session Ident: #glitchpc
[21:45] * Now talking in #glitchpc
[21:45] * Topic is 'Welcome to #glitchpc chat. Profanity, trolls, and impersonation are not welcome here. Street1 has become a Silent Keyboard. http://www.legacy.com/obituaries/savannah/obituary.aspx?page=lifestory&pid=139870551'
[21:45] * ChanServ sets mode: +a
[21:45] * ChanServ sets mode: +o ChanbotVII
[22:00]<@BC_Programming> awfully quiet around these parts
[22:02]<+Tux2> lol
[22:03]<@BC_Programming> let's see
[22:03]<@BC_Programming> I started this thing at 5AM
[22:04]<@BC_Programming> STILL not working... though at least I know the Java JAR is working perfectly, the report just needs work
[22:06]<+Tux2> lol
[22:06]<@BC_Programming> and the Java JAR is entirely my doing and it's going to be critical to every single report, and there are almost 100
[22:06]<@BC_Programming> so that's cool
[22:07]<+Tux2> Nice!
[22:08]<Craig> Hey BC
[22:08]<@BC_Programming> it's funny because I had never made a Swing application aside from some basic stuff before
[22:08]<Craig> and Tux2
[22:08]<+Tux2> Hey Craig
[22:08]<@BC_Programming> then I accidentally derived from JInternalFrame instead of JFrame, that was fun to figure out
[22:08]<+Tux2> lol, swing is nice
[22:09]<@BC_Programming> Tux2: I hated it but I didn't know you could force the System Theme
[22:10]<+Tux2> lol, yup, you can force the system theme
[22:10]<@BC_Programming> thankfully the report portion is really just a single frame with a Jasper reports component inside, no other controls as it is, so I didn't really have to do much
[22:12]<@BC_Programming> that's why it had to be Java, because Jasper's API is only accessible to Java (since it's Java as well). Only myself and the lead dev know Java, and he spends most of his time creating work orders and managing all the work getting done, so that's probably why I got it
[22:15]<+Tux2> Ah...
[22:16]<+Tux2> lol, swing layout managers can be quite powerful and flexible, but can be quite confusing if you've never done it before
[22:16]<@BC_Programming> yeah the Swing layout managers are similar to the ones in Windows Forms or WPF, though mostly similar to the latter
[22:17]<@BC_Programming> oh my work E-mail is michael@mainframeassociates.com heheh
[22:18]<+Tux2> heh... Now to spam your work email! :D
[22:19]<@BC_Programming> haha
[22:19]<@BC_Programming> no thx
[22:19]<+Tux2> lol
[22:19]<+Tux2> Their website is left aligned... not good, should be centered...
[22:20]<@BC_Programming> I don't think they have any web ppl anymore
[22:20]<@BC_Programming> actually I wonder if that is in the svn
[22:20]<Craig> :P
[22:20]<+Tux2> lol, would be a good improvement
[22:21]<@BC_Programming> hmm nope
[22:21]<@BC_Programming> I think I have ftp access to the main server though
[22:21]<+Tux2> lol, would probably be good to ask before just going and changing it though
[22:22]<@BC_Programming> I wasn't going to, just wanted to look at it for now
[22:22]<@BC_Programming> but now I remember for some reason I cannot access FTP anywhere
[22:23]<+Tux2> hmm
[22:23]<@BC_Programming> hmm get a timeout for my site and anywhere else... I think it's related to how I'm bridging my connection between my desktop and laptop or something
[22:23]<@BC_Programming> because the laptop can access my ftp fine
[22:24]<+Tux2> hmm... maybe
[22:24]<@BC_Programming> oh I discovered a lot of funky config issues with my svn and even java
[22:26]<@BC_Programming> had a 32-bit version and 64-bit version of each and the 32-bit version was outdated (svn from a year ago and Java 6) so I was getting errors from netbeans and some programs that use svn that were 32-bit and launching the jar from the C# app, which was 32-bit threw an exception about the class format.. Took a while for me to realize how obvious the reason was
[22:26]<@BC_Programming> Craig:LOL
[22:26]<Craig> Heh got the message?
[22:26]<@BC_Programming> yeah
[22:26]<Craig> :P hahahaha
Session Start: Thu Aug 22 23:50:16 2013
Session Ident: #glitchpc
[23:50] * Now talking in #glitchpc
[23:50] * Topic is 'Welcome to #glitchpc chat. Profanity, trolls, and impersonation are not welcome here. Street1 has become a Silent Keyboard. http://www.legacy.com/obituaries/savannah/obituary.aspx?page=lifestory&pid=139870551'
[23:50] * ChanServ sets mode: +a
[23:50] * ChanServ sets mode: +o ChanbotVII