dcmwai (~chatzilla@219.95.155.118) joined #gnuenterprise.
<jcater> hey dcmwai
<dcmwai> hello jcater
<dcmwai> Josh and I've talk about the issue derek and I have talk about.
<dcmwai> And Josh seem to like the idea. And he say that we all will arrange a metting on the net to talk about it.
Action: jcater doesn't know what you and derek talked about
Action: dcmwai find something wrong on the last line but don't know where...
<dcmwai> jcater: Oh I think you will read the log?
<jcater> when was the conversation?
<jcater> I can go back and reread
<jcater> I usually don't read backlogs without a reason to
<dcmwai> about June 05
<dcmwai> if I'm not wrong...
<dcmwai> well... try to get my name on your log... you will get it...
<dcmwai> I've forgot when it happen :)
Action: dcmwai now know the reason of this irc log :)
<jcater> found it and am reading
<jcater> I emailed josh a few days ago
<jcater> he emailed info@gnue.org
<jcater> but I haven't heard back from him
<jcater> I was beginnnig to think I scared you guys away
<dcmwai> No you don't
<dcmwai> infact we did like the idea.
<dcmwai> We don't have much developer Jusy me and Josh and all jobs is done by us :(
<jcater> does Josh use IRC?
<dcmwai> yes he does... when it is needed :)
<dcmwai> jcater: Is anyone here want to talk to josh?
dcmwai (~chatzilla@219.95.155.118) left irc: "ChatZilla 0.8.11 [Mozilla rv:1.2.1/20030505]"
roche (~roche@200.9.45.19) joined #gnuenterprise.
sub_pop_culture (~link@129.210.184.16) joined #gnuenterprise.
sub_pop_culture (~link@129.210.184.16) left #gnuenterprise ("Client exiting").
roche (~roche@200.9.45.19) left #gnuenterprise ("Client Exiting").
Sacha (~Sacha@dialup-196-69.wasp.net.au) joined #gnuenterprise.
lxf (~agus_tea@202.73.120.115) joined #gnuenterprise.
Sacha (~Sacha@dialup-196-69.wasp.net.au) left irc: Read error: 110 (Connection timed out)
lxf (~agus_tea@202.73.120.115) got netsplit.
chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) got netsplit.
ra3vat (~ds@ics.elcom.ru) got netsplit.
lxf (~agus_tea@202.73.120.115) returned to #gnuenterprise.
chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) returned to #gnuenterprise.
ra3vat (~ds@ics.elcom.ru) returned to #gnuenterprise.
tripz__ (~ville@as13-5-6.ld.bonet.se) joined #gnuenterprise.
<derek> jcater: i have been trying to arrange josh to come to irc
<derek> there have been no 'talks'
<derek> other than short original irc session (that you were there for iirc)
<derek> and email to info@gnue.org
<ajmitch> morning derek
<derek> i responded directly to josh from the info list and asked if he could meet us in irc
<derek> unfortunately the timewarner block of IPs gnuenterprise.org now has is BLACKLISTED by rr.com
<derek> so my mails to him bounce :(
<derek> and i have to resend from another means...
<derek> anyhow tis soccer time bbl
<derek> hi ajmitch
<chillywilly> http://www.wlug.org.nz/PostgresVsMysql <-- ajmitch showed me that
<Vee2d2> just what are 'views' in sql terms.. ?
Action: Vee2d2 exposes his ignorance
<chillywilly> basically a table in ram
<chillywilly> that you can then query against
<Vee2d2> so it's a speed enhancement?
<chillywilly> yes and a convenience thing
<chillywilly> derek: are you there?
jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) joined #gnuenterprise.
<chillywilly> what's mencoder?
Action: chillywilly read gnue logs like a dork
<chillywilly> hi jeff
<jbailey> It's a video format converter.
<chillywilly> written by mplayer ppl or no?
<chillywilly> oh I should see if I have Bruce Almighty downloaded now
<chillywilly> yep
<chillywilly> got the Centropy SVCD 
<chillywilly> the matrix reloaded svcd from centropy was really nice
<jbailey> What's a Centropy?
<chillywilly> burnt the images to  some cd-r s
<chillywilly> I take it some org/group of people that do movie rips
Action: chillywilly uses google right quick
<chillywilly> http://www.vcdquality.com/index.php?genre=6&grp=4
<chillywilly> if you look at their little chart
<chillywilly> Centropy is a group that does movie rips
Action: chillywilly guessed correctly
<jbailey> I used to get movie rips, but it's cheaper to just rent the video's I want. =)
<jbailey> (and rip the ones then that I want to keep)
<chillywilly> cheaper?
<chillywilly> I don't have a dvd drive in any of these machines
<chillywilly> I only have a stand alone player hooked up to my TV
<jbailey> Yeah.  To waste 2 blank CDs to find out that I don't like the movie. =)
<jbailey> Renting the DVDs costs less.
<jbailey> Ah.
<jbailey> My machines have all had DVD drives for the last 6 years.
<jbailey> err.
<jbailey> 5.
<chillywilly> you can watch it on your computer before you burn it to a CD
<chillywilly> goofy
<chillywilly> mplayer whatever,bin
<jbailey> *Shrug*  I opt to rent anyway.
<jbailey> It's like two bucks for two DVDs at the rental place.
<jbailey> That's for a week-long rental.
<chillywilly> well whatever works best
<chillywilly> bah this is so stupid...I need a burner on one of these machines...windows has crippled ass networking
<chillywilly> 13mins to go form linux to linux v. 3 hours to transfer to stinking windows
<jbailey> If it's that bad, your network card driver is bad in your windows machine.
<jbailey> (or the card itself)
<jbailey> The ratio shouldn't be that high.
<chillywilly> but it only pulls at 80k
<chillywilly> for linus I get at least 1Mbit
<chillywilly> linux
<jbailey> Same machine?
<chillywilly> no
<chillywilly> but same card
<chillywilly> I have same card in all machiens except this laptop
<chillywilly> machines
<chillywilly> even the winders machine has the same card in it
<jbailey> Check to make sure there isn't a hardware conflict, and then make sure that your duplex/speed settings are the same on all the machine.
<jbailey> Windows networking is bad, but it's more on the order of line 60% or 70% of the speed of Linux.
<chillywilly> how would I knwo if there's a conflict? wouldn't windows complain?
<chillywilly> I'd like to get 100Mbit ;)
<chillywilly> I changed the config of the card
<chillywilly> the other day
<chillywilly> tried to force it to use fastest speed
<chillywilly> eth0: NE2000 (DL10019 rev 05): io 0x300, irq 10, hw_addr 00:E0:98:86:36:CF
<chillywilly> ttyS01 at port 0x02f8 (irq = 10) is a 16550A
<chillywilly> eth0: found link beat
<chillywilly> eth0: autonegotiation complete: 100baseT-HD selected
<chillywilly> that's from my laptop
Action: chillywilly is just checking all network crap
<chillywilly> brb
chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) left irc: "Free Your Enterprise! - http://www.gnuenterprise.org"
chillywilly (~danielb@CPE-24-167-200-152.wi.rr.com) joined #gnuenterprise.
danielb (danielb@CPE-24-167-200-152.wi.rr.com) joined #gnuenterprise.
danielb (danielb@CPE-24-167-200-152.wi.rr.com) left irc: "leaving"
fixe (~fixe@dsl017-020-123.chi1.dsl.speakeasy.net) joined #gnuenterprise.
<jcater> Vee2d2: actually, views are "alternate viewpoints" into your data
<jcater> Vee2d2: you could pull data from different tables and make them appear as a single table via a view
<jcater> or create a restricted view into a single table
<Vee2d2> something I'll hafta learn up on sometime
<jcater> f.e., if you have a table called horses, and a table called riders
<jcater> you could create a view, HorsesWithRiders, that combined the two
Action: chillywilly was implying that
<chillywilly> for the fucking record
<jcater> well, I saw the part about speed enhancement
<jcater> and views really have nothing to do with speed enhancements, but security and convenience
<Vee2d2> well.. I still dont fully understand.. 
<Vee2d2> I can combine the two tables with a join
<chillywilly> yes but why do ti every stinking time?
<chillywilly> if you do it a lot you may want to create a view
<Vee2d2> ok, I s'pose that is pretty nifty.. 
<jcater> f.e., suppose you have these two tables
<jcater> Horses
<jcater>   Id
<jcater>   Name
<jcater>   Age
<jcater> Riders
<jcater>   Id
<jcater>   Horse_Id
<jcater>   Name
<jcater> You could create a view, HorsesWithRiders
<jcater>  from the following SQL:
<jcater>   create view HorsesWithRiders as
<jcater>     select horses.id as horse_id,
<jcater>            riders.id as rider_id,
<jcater>            horses.name as horse_name,
<jcater>            riders.name as rider_name
<jcater>       from horses, riders
<jcater>       where horses.id = riders.horse_id;
<jcater> and do: "select * from HorsesWithRiders" and get:
<jcater>  Horse_id  Rider_Id    Horse_name    Rider_Name
<jcater>   1           1        BlueTooth     Bob Smith
<jcater>   2           3        BabyFace      Jane Doe
<jcater>   6           9        Funny Smell   Kevin Wilson
<chillywilly> are you pating that?
<chillywilly> pasting
<chillywilly> that seems familiar
<chillywilly> is that from postgres docs?
<jcater> I typed it in vi before pasting
<chillywilly> oh
<jcater> no, that's jcater braindump
<chillywilly> scary ;)
<Vee2d2> I had a situation where I had line items for a sales order.. and workorders where there could be many work orders to each line item.. and I was wanting to find out the sum qty of line items which were for like products (fe: the same shirt, possibly different colors/sizes) with exactly the same work order requirements (fe: logo X embroidered at location 4 and logo Y embroidered at location 3) so that I could use those
<Vee2d2>  price breaks
<Vee2d2> that was a very very painful experience in MySQL.. =/
<jcater> I bet
Action: Vee2d2 gains new understanding of views.. 
<Vee2d2> while beating myself up over that problem I kept thinking if I had the use of subselects things would be much easier.. but now that I see where views come into play they certainly would have made things easier to work with. 
<Vee2d2> I should probably go shower the stench off and get ready to goto the party
<chillywilly> bah, anyone knwo how to delete a WO in dcl?
Action: chillywilly just said fsck it and used psql to remove the bastid ;)
lxf (~agus_tea@202.73.120.115) left irc: 
Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) left irc: Read error: 113 (No route to host)
niktarin (~niktarin@hera530-a059.otenet.gr) joined #gnuenterprise.
niktarin (~niktarin@hera530-a059.otenet.gr) left #gnuenterprise ("Έξοδος πελάτη").
<derek> party at vee2d2 one hour
<derek> woooo
<derek> chillywilly: why oh why
<derek> you are so bad
<chillywilly> why what?
<derek> why not choose 'delete work order' from the workorder screen
<chillywilly> didn't see it
<derek> and then choose ok when asked 'are you sure'
<chillywilly> where's it at?
<derek> as way you did it, you probably didnt do a 'cascade' delete
<derek> which means you created orphans
<chillywilly> probably
<derek> you bad bad bad man
<chillywilly> there's probably dead links in there now
<chillywilly> data integrity was fux0red
<chillywilly> ;)
<chillywilly> s/was/is/
<chillywilly> derek: if you would've responded maybe you could've helped me find the damn delete ;)
<derek> i wasnt here or i would have
<derek> btw: unless you had attachments, sequences or projects tied to that work order you probably didnt make orphans, i was giving you crap ;)
<chillywilly> ah, ok
<chillywilly> I didn't have any of those things
ToyMan (~stuq@65-73-36-222.bras01.mdl.ny.frontiernet.net) joined #gnuenterprise.
srbaker (~srbaker@u164n248.eastlink.ca) joined #gnuenterprise.
<srbaker> anyone around?
<chillywilly> nope
<srbaker> fine then, fuck you 
<srbaker> :P
<chillywilly> you're lucky I don't have ops in here
<srbaker> chillywilly: heh.  you know you love me
<chillywilly> I think what you said displays your immaturity well
<srbaker> chillywilly: lighten up
<srbaker> don't take yourself so seriously
dsmith (xj7b3x213m@oh-strongsvillecadent1-1d-165.clvhoh.adelphia.net) joined #gnuenterprise.
srbaker (~srbaker@u164n248.eastlink.ca) left irc: "Client exiting"
<chillywilly> hi dale
<chillywilly> did you start your new job yet?
<dsmith> chillywilly: GReetings.
<dsmith> I start on the 16th.
<chillywilly> yay
jafgon (~jafgon@dhcp024-210-188-138.woh.rr.com) joined #gnuenterprise.
<jafgon> hello gnuenterprise people
ToyMan (~stuq@65-73-36-222.bras01.mdl.ny.frontiernet.net) left irc: "Client Exiting"
<jafgon> was hoping to talk to derek and jcarter must go to pub now ... tata
jafgon (~jafgon@dhcp024-210-188-138.woh.rr.com) left irc: "Client Exiting"
<chillywilly> haha, jcarter
jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) left irc: "Client exiting"
--- Sun Jun  8 2003