Arturas (~arturas@gsk.vtu.lt) joined #gnuenterprise. Good morning don't remind me :) :) at least one clever man :) how clever is the man if the job he thought would take 2 hours has taken..... 5 and counting well, he's not the one :) hm, not alone coool, Bruce Perens wanted to create a dist just for me! Bruce first became interested in Debian while he was attempting to create a Linux distribution CD to be called "Linux for Hams" they just spelled my name wrong :) alandd (~alandd@h-66-167-43-253.PHNDAZ91.covad.net) joined #gnuenterprise. dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise. dneighbo: how is the workshop planning going? derek: how is the workshop planning going? Action: alandd derek? dneighbo? which is he today? loco1 (~electronl@dsl-200-67-89-150.prodigy.net.mx) left irc: Read error: 104 (Connection reset by peer) hallo alan alan: have you responded to Alexander about the O'Reilly stuff? Alexander? O'Reilly stuff? Action: alandd I missed something somewhere! Um... what did I miss? derek (~dneighbo@ip68-109-180-32.ph.ph.cox.net) left irc: Read error: 110 (Connection timed out) Action: alandd he must be dneighbo today! he wrote me the other day saying he'd contacted O'Reilly about something and said he wrote you last week I can get back to him after the meeting OK. I'll look at my old emails. I don't recall seeing something but then I am not a computer! LuftHans: I did and email search for "reilly" in all emails. Nothing from an Alexander. maybe earthlink's SpamBlocker got it, don't know. Will he be at the meeting thu? dneighbo: I must hie to bed. Remember, if you need any assistance preparing for the workshop, email me. I'll find the help or do it myself. LuftHans: See you at the meeting. gnite alandd (~alandd@h-66-167-43-253.PHNDAZ91.covad.net) left irc: "Client Exiting" reinhard (~reinhard@M1249P021.adsl.highway.telekom.at) joined #gnuenterprise. Arturas (~arturas@gsk.vtu.lt) left irc: "Client exiting" Arturas (~arturas@gsk.vtu.lt) joined #gnuenterprise. johannesX (~johannes@M1249P010.adsl.highway.telekom.at) joined #gnuenterprise. Arturas (~arturas@gsk.vtu.lt) left irc: "Client exiting" dcmwai (~dcmwai@219.95.164.243) left irc: "Client exiting" ToyMan (~stuq@65-73-36-101.bras01.mdl.ny.frontiernet.net) joined #gnuenterprise. mystikz (mark@219.95.20.151) left irc: jcater (~jcater@cpe-066-061-071-129.midsouth.rr.com) left irc: "Client exiting" dcmwai (~dcmwai@219.94.80.73) joined #gnuenterprise. ToyMan (~stuq@65-73-36-101.bras01.mdl.ny.frontiernet.net) left irc: "Client Exiting" johannesX (~johannes@M1249P010.adsl.highway.telekom.at) left irc: "Client Exiting" johannesX (~johannes@M1249P010.adsl.highway.telekom.at) joined #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. siesel_ (~chatzilla@port1137.duesseldorf.ndh.net) joined #gnuenterprise. hi all hi siesel_ good to see you i'm making _way_ progress in appserver yes, I 've read the commit messages today however i have a problem with call over RPC what kind off Now I call the procedure 'show' for the first instance: ******************************************** Error: 1: Unknown error ******************************************** is when i call it over RPC Now I call the procedure 'show' for the first instance: Function 'show' was called. This record contains the following values: gnue_id : 00000000000000000000000000001100 is when i do the same w/o RPC hmm, which program do you use to do it per rpc? i have test.py for direct and testRPC.py for test with RPC you probably need to update all cvs (or even re-checkout) and rebuild the test database all done some 30 min, ago cool I took some time because I had to fix an issue with the 0.5.1 releases does test.py work for you? yes, and testRPC returns a Protokoll error oh you are using pw_xmlrpc, right? i work with xmlrpc seems like its a problem with a [rset[0][0]] attribut passed to show yes, pw_xmlrpc its miles better, and included in python2.2[2.3?], so it should be our standart johannesX (~johannes@M1249P010.adsl.highway.telekom.at) left irc: Read error: 60 (Operation timed out) it's not available for debian woody dsmith (~dsmith@mail.actron.com) joined #gnuenterprise. that's the reason why we made xmlrpc standard yes, as most modern software, like gtk2 etc. yes and gnue ;-) we discussed that before, yes. :)) maybe sarge release will really be this year or beginning next year then we could switch to pw-xmlrpc beginning sounds like August :( but i acutally would like to support debian out of the box as well as possible however but back to our error yes I will try to trace it down, but that has to wait until lunch bbl lunch? yes, a bit late, but .... CU siesel_: thanks in any case siesel_ (~chatzilla@port1137.duesseldorf.ndh.net) left irc: "ChatZilla 0.8.9 [Mozilla rv:1.1/20020826]" jamest_ (~jamest@gw.math.ksu.edu) joined #gnuenterprise. jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. johannesX (~johannes@M1263P027.adsl.highway.telekom.at) joined #gnuenterprise. dsmith (~dsmith@mail.actron.com) left irc: "Client exiting" siesel_ (~chatzilla@port1073.duesseldorf.ndh.net) joined #gnuenterprise. siesel_: just updated cvs to get your fix, it works 1000 thanks! no problem i think you could undo the temporary fix in common, couldn't you? I can, but I want to leave the fix in, in case of a user written appserver method is returning None I think that I use the "allow_none" flag in pw_xmlrpc i think user written methods will be called through a wrapper anyway ah ok i actually don't mind the pitty is, that the other xmlrpc impl. (the one in woody) doesn't support this. :( i just don't want to make a mess in common for something that we could fix in appserver however for now it works and is ok we just have to manage it somehow when we implement user-written procedures another question (if you have time) ok. i'm not sure i understand the format of grpc files especially the relevance of the "type" flag looks like it should not work, but it does :) type checking isn't implemented in XMLRPC rpc driver yet, so it works ah ok neither in pw-xmlrpc? but its necessary for some other protocolls no, its only use if you list services is it forseeable what the valid types will be? i could guess that "list of objids" will probably be no valid type :) yes, that should be fixed sorry, have to run again. siesel_ (~chatzilla@port1073.duesseldorf.ndh.net) left irc: "ChatZilla 0.8.9 [Mozilla rv:1.1/20020826]" lxf (~agus_tea@202.73.120.115) joined #gnuenterprise. dsmith (~dsmith@mail.actron.com) joined #gnuenterprise. dneighbo, You cannot run thunderbird/firebird with mozilla :( dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) got netsplit. LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) got netsplit. Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) got netsplit. jamest_ (~jamest@gw.math.ksu.edu) got netsplit. chillywilly (danielb@CPE-24-167-193-95.wi.rr.com) got netsplit. dcmwai (~dcmwai@219.94.80.73) got netsplit. reinhard (~reinhard@M1249P021.adsl.highway.telekom.at) got netsplit. jamest (~jamest@adsl-208-191-39-86.dsl.tpkaks.swbell.net) got netsplit. johannesX (~johannes@M1263P027.adsl.highway.telekom.at) got netsplit. jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) got netsplit. ToyMan (~stuq@smtp.dstoys.com) got netsplit. havoc (~havoc@CPE-65-31-122-112.wi.rr.com) got netsplit. SachaZzz (~sacha@online.havanawave.com) got netsplit. johannesX (~johannes@M1263P027.adsl.highway.telekom.at) returned to #gnuenterprise. jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) returned to #gnuenterprise. jamest_ (~jamest@gw.math.ksu.edu) returned to #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) returned to #gnuenterprise. dcmwai (~dcmwai@219.94.80.73) returned to #gnuenterprise. reinhard (~reinhard@M1249P021.adsl.highway.telekom.at) returned to #gnuenterprise. dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) returned to #gnuenterprise. jamest (~jamest@adsl-208-191-39-86.dsl.tpkaks.swbell.net) returned to #gnuenterprise. Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) returned to #gnuenterprise. LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) returned to #gnuenterprise. chillywilly (danielb@CPE-24-167-193-95.wi.rr.com) returned to #gnuenterprise. havoc (~havoc@CPE-65-31-122-112.wi.rr.com) returned to #gnuenterprise. SachaZzz (~sacha@online.havanawave.com) returned to #gnuenterprise. mouns (mouns@kali.mouns.org) joined #gnuenterprise. jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) joined #gnuenterprise. jamest/jcater: is that correct that technotes are the way of choice for internal documentation? and if yes, can somebody explain in 2 lines how they work? well, I don't think they would take the place of proper internal documentation but it was a way for me to do quick docs on some particular topic jcater: what would be "proper internal documentation"? well, e.g., I'd consider doc/geasarch/ doc/api/ etc to be good documentation technotes for me (and this is just me) are more a "let me write down the details of what I just did while they're fresh on my mind." hmm doc/api etc are "external" documentation LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) got netsplit. Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) got netsplit. dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) got netsplit. ok, well I said that without actually reading api/ dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) returned to #gnuenterprise. LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) returned to #gnuenterprise. Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) returned to #gnuenterprise. i have some things to document that nobody would be interested in _except_ people hacking on appserver yeah, I'm putting stuff like that in technotes ak ok there is a script for technotes or something like that, IIRC? they're nothing but simple text files like 00001.txt with a very short header section Title: Explanation of form's internal event model Status: Current Created: 2002-07-17 a blank line separates the header from the text yeah i read that from 00000.txt :) if you run gnue-common/utils/create-technote-index.py then an index.html and index.txt is created ah ok do we put technotes on www.gnuenterprise.org? we should but I don't know if we got around to it or not ok at least it was intended :) we're all full of good intentions :) now if we all just had time to do them :) i think i will adopt technotes for appserver it really becomes a mess otherwise over time cool you have a README here, a internals.txt there I wanted technotes to stay very simple to encourage them to be created/maintained somewhere a lyx file, somewhere a tex file etc. i loved the simple format when i looked at it dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) left irc: Connection timed out reinhard: what holiday are you guys on? summer holidays ah most companies are closed for 2 weeks or 3 oh, that's right in most civilized countries BESIDES THE US people encourage vacations but I won't rant today Git back to work! ;) reinhard (~reinhard@M1249P021.adsl.highway.telekom.at) left irc: Read error: 54 (Connection reset by peer) erp reinhard (~reinhard@M1249P021.adsl.highway.telekom.at) joined #gnuenterprise. siesel_ (~chatzilla@port1062.duesseldorf.ndh.net) joined #gnuenterprise. Action: jcater thwaps Vee2d2 derek (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise. is this derek the derek I know, he seem to be in a lot of channel :) why we didn't get this message? -dmwaters- {server notice} The machine will go down in about five mins. siesel_: you here? Everyone good Night dcmwai (~dcmwai@219.94.80.73) left irc: "Client exiting" reinhard: yes, back geeg:~> gfdes I am SOOO there, dude! hehe.. are there not tooltips in designer or have I somehow turned them off? siesel_ (~chatzilla@port1062.duesseldorf.ndh.net) left irc: "ChatZilla 0.8.9 [Mozilla rv:1.1/20020826]" Vee2d2: tooltips are broken as of 0.5.1 but it was a known breakage Vee2d2: you must be playing with my Tab Order mode thingy I just started it yesterday, so it doesn't do much yet :) that and cut-n-paste are my two biggies for designer 0.5.2 right now cool jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) left irc: "Client exiting" before you know it, designer will actually be usable :) It's quite useable already, I can see it is going to be a pretty impressive tool in time dsmith (~dsmith@mail.actron.com) left irc: "Client exiting" mouns (mouns@kali.mouns.org) left irc: Remote closed the connection bigerbrother joined #gnuenterprise. Nick change: bigerbrother -> bigbrother jcater_ (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. dodji (~dodji@lns-p19-28-82-65-54-120.adsl.proxad.net) joined #gnuenterprise. hey dodji Hey Vee2d2 ;) Vee2d2: are you a gnue hacker ? would-be gnue-sb hacker what's gnue-sb ? Action: dodji doesn't know anything about gnue ... http://www.gnu.org/software/gnue-sb/ I can finally see the light on this project I'm doing at work, so if I can stamp it done tonight or so I might finally get a chance to finish some things Action: Vee2d2 goes back to seeking the light Vee2d2: looks interesting ... Vee2d2: I've just looked at the gnue-sb link jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: Read error: 110 (Connection timed out) /nick jcater Nick change: jcater_ -> jcater i need .debs for newest mozilla I can get for woody any ideas? Action: chillywilly slaps jamest_ for the pure enjoyment of it Action: jamest_ unleashes the trout of flaming penguin demise upon chillywilly check apt-get.org, there are at least 3 places providing backports of mozilla HEY! no penguin demise, even if the the pengy is a flamer! ( that's now legal in these here sometimes, almost united states ) ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" LuftHans: thanks, i knew there was a apt search site i just couldn't recall what it was called :) jamest: I'm working on 'woody and a half', which'll take a bunch of those to create a respository that contains backports to woody i use ardian (sp?) bunk's repository now deb http://www.fs.tum.de/~bunk/debian woody/bunk-1 main contrib non-free but it's at moz 1.2.1 there's a moz 1.3 and maybe 1.4 1.4 at I don't even know what versions the project is up to, though deb http://people.debian.org/~nobse/debian/woody/backported ./ i don't either 1.4 something this is for users not me Action: jamest_ likes konqueror Action: jcater hugs his konqueror (and I don't mean that in any randy way) I like konqueror, but I need tabs what's wrong with konq's tabs? I used konq on sawfish and e for a couple of years I've never seen them :) ah I heard they were in CVS, but haven't seen them released, maybe I have them and just haven't enabled them... yeah, since 3.1.0 iirc you may have to enable them though ah, dpkg says I have konqueror 2.2.2-14.4 oh btami (~btami@ngprs.pannongsm.hu) joined #gnuenterprise. hi maybe I should go grab a backport out of woody and a half btami: hello oh, wait, that's not working, gonna have to rough up the developer running that pos project! :) eh? I've got woody and a half technically working, except it requires apt to honor http redirects and apt doesn't honor those now I need to get a proxy working that'll handle the redirects for apt, but I won't have time to finish that for the presentation tomorrow night :( jcater: you use apt-proxy, right? does it work well for you? can anyone change the status of common's Developers-Guide.sxw to binary in CVS, please ? LuftHans: I've only been using it for 3 weeks or so now seems to work for me but that's not much experience w/it jamest used it a lot btami: I would if I knew how me too :) jcater: deb http://www.LuftHans.com/debian stable woody+.5 add that to your sources.list and do a --download-only dist-upgrade if you have a vanilla woody box sitting around http://www.suntimes.com/output/news/cst-nws-med13.html what do you guys think about this? cw: news had them at 8k docs yesterday and at 9k today, but that's still 1% of the docs in the .us bah I think the current system just isn't working Err http://www.LuftHans.com stable/woody+.5 xfonts-base 4.2.1-6 302 Found Err http://www.LuftHans.com stable/woody+.5 xlibmesa-dev 4.2.1-6 302 Found Err http://www.LuftHans.com stable/woody+.5 xlibmesa-gl-dev 4.2.1-6 302 Found Err http://www.LuftHans.com stable/woody+.5 xlibmesa-glu-dev 4.2.1-6 302 Found err the "I think the current system just isn't working" was for chillywilly ok, apt-proxy doesn't handle the redirects either but it goes for LuftHans too I guess :) heheh jcater: yup, that works for both cases :) I don't know how I feel about a national healthcare system but I know I don't like the current setup at all insurance companies suck I need redirects for how I want to put debian stuff on p2p as well, but that's probably just me being stupid and not understanding p2p s/suck/& the life out of our population/ kde 3.1.3 has official woody debs and tabs and kicks the crap out of 2.2.anything btami: remove your .sxw file and try to update again not sure if I fixed it or not, but I tried Action: LuftHans just called progeny about getting commercial support for debian. you need a neck to ring? ;) sort of :) a client needs/wants a support contract. I'm going to see if I can handle it, but it probably isn't appropriate for this client to go with a one man shop on the support contract well that and I don't want to deal with RH advanced server and oracle ;-) jcater: it's not binary, and i can't open it with OOo on XP (form's dev guide is OK) oooo just as you typed that I found what I needed in google give me a sec ok, try again it's OK now, thanks jcater! cvs admin -kb *.sxw in case anyone wants to know :) especially me :) is it safe to delete things from the attic dir? someone asked me the other day it's safe to but of course they loose all history information for any files there I think he was wanting to completely erradicate some things he'd removed irradicate? hmm.. UPS's going crazy.. bbiab rain Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) left irc: Remote closed the connection hmm at first I thought he meant a UPS guy was going nuts outside his house doh that'd be the post office guy, not the ups guy Action: chillywilly goes postal in #gnuenterprise the way unemployment is going these days I wouldn't be surprised if it was a UPS or FedEx or whatever guy UPS sucks ;P dodji (~dodji@lns-p19-28-82-65-54-120.adsl.proxad.net) left irc: Read error: 60 (Operation timed out) if you had to wear brown every day you'd be upset as well what can shit stain do for you? hmmm, they should adopt my new motto btami is playing with appserver? no, just trying setup.py install i'm sure there are some points to fix in setup.py ok but that's further down my list is appserver dbdriver usable now ? however i guess i will get back on you when it gets to creating windows installer :) yes appserver dbdriver is usable now data read/write works if you get appserver to run there's a sample form "appservertest.gfd" get appserver to run == easy for debian, not even tried for windows :( ok, i will try on XP and there's a database schema that can be loaded but i only have a script for postgres btami: i would appreciate that very much is there gsd ? no :( if it makes it easier for you, i would try to build one well actually there is one, but it is outdated sure ok Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) joined #gnuenterprise. if you make it ready, i can test it with firebird reinhard: designer can create a gsd automatically from a postgresql session jcater: that's great news how is that done? aehm just start up designer does designer depend on some wxPython version I don't have in woody? ImportError: No module named gizmos yeah, but we have backports deb http://www.gnuenterprise.org/debian/ woody main ah cool we were spending as much time working around wx 2.2 bugs as we were coding features so we made the decision to up the minimum version to 2.4 we == I =) what do i have to install from there? apt-get install libwxgtk2.4-python thanks Action: Vee2d2 watches as the awesome rain feeds his parched landscape jcater: did the dep on 2.3 get fixed? ask jbailey he does our debs I started to reportbug nag for a new version this morning.. but I know he's busy. know == figured designer runs man this looks cute File | New | From Wizard... i've been away _way_ too long from this project then select "Schema" tab jcater: he was waiting for the new release wow!! hmm designer has one bug w/the schema thing apparently it creates two tags one needs to be manually deleted from the .gsd file after you save Action: jcater will fix that no problem ok, that's fixed lol i found another problem holy cow that should be length 6 and 4 respectively :) what are the native postgresql types for those two fields? however i can fix that with vi well, I have the appserver schema I can look reinhard: it's not 100% perfect yet nevermind (after all, it's a GNUe project =) i used numeric (6) and numeric (4) what types are valid in gsd files? now all string fields are "text" no matter if they are char or varchar jamest_ (~jamest@gw.math.ksu.edu) left irc: "Client exiting" ok two questions a) can somebody give me a pointer about the valid datatypes in gsd? and b) how can i "run" a gsd? gsscvs holds the answer to b I dont recall exactly where (if they are) the data types are documented ok got it found it in the usual documentation files those with the .py ending :-) haha :) night all btami (~btami@ngprs.pannongsm.hu) left irc: fsf breaking made /. hmmm can it be that gnue-schema (gsscvs) doesn't generate sql code for the part of the file? crap after midnight here i must go to bed will continue tomorrow (i hope) it's _really_ fun to code when you find all your work already done in common :))) lol gute n8 reinhard gute nacht, LuftHans good night all bonne nuit etc. reinhard (~reinhard@M1249P021.adsl.highway.telekom.at) left irc: "Even if you're on the right track, you'll get run over if you just sit there." johannesX (~johannes@M1263P027.adsl.highway.telekom.at) left irc: Read error: 110 (Connection timed out) lxf (~agus_tea@202.73.120.115) left irc: SendQ exceeded jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "home" dcmwai (~dcmwai@219.94.80.103) joined #gnuenterprise. http://ftp.gnu.org/MISSING-FILES.README jcater (~jcater@cpe-066-061-071-129.midsouth.rr.com) joined #gnuenterprise. lex (~alex@host-148-244-140-29.block.alestra.net.mx) joined #gnuenterprise. Heyas guys. howdy R45 (~rastabeen@cuscon633.tstt.net.tt) joined #gnuenterprise. I am part of an enterprise group in mexico purely of FS related companies. Ive detected some interest in ERP solutions and the like within the group. I immediatly thought GNUe could be a good startpoint for them to have a mexicanized Free Software ERP solution. yes http://papo.vialibre.org.ar/ is using gnue tools it would :) Cool..... they arent that GNU litterate my other friends....but in time.... i know this is an evangeliziing community! dcmwai (~dcmwai@219.94.80.103) left irc: "Client exiting" lex (~alex@host-148-244-140-29.block.alestra.net.mx) left irc: Read error: 113 (No route to host) lex (~alex@host-148-244-140-29.block.alestra.net.mx) joined #gnuenterprise. lex (~alex@host-148-244-140-29.block.alestra.net.mx) left irc: Client Quit jcater (~jcater@cpe-066-061-071-129.midsouth.rr.com) left irc: Remote closed the connection jcater (~jcater@cpe-066-061-071-129.midsouth.rr.com) joined #gnuenterprise. R45 (~rastabeen@cuscon633.tstt.net.tt) left irc: Nick change: SachaZzz -> SachaS dcmwai (~dcmwai@219.95.164.243) joined #gnuenterprise. jcater (~jcater@cpe-066-061-071-129.midsouth.rr.com) left irc: "sleep" anyone here? :) no haha Catch you :) jamest please leave a message after the beep* something about item Management on the gnue-sb.. why there is a SKU and old SKU if I did recall correctly SKU will continuate accumulate and grow with time so shouldn't that SKU be a db list? i don't have a clue on gnue-sb jamest: HAHA i barely have a clue on the stuff I've worked on jamest: May I know what are you working on ? when I gnue it's typically common or forms Action: dcmwai is very new to gnue (Oh Yes I'm) now it's java yippie! Action: jamest is a java hater but forms was my baby until jcater did unspeakable things to it then I did some then him :) jamest: then I yeah, exactly haha poor thing but working in java makes me love forms/python that much more jamest: don't tell me that it is going to be change to Java... I don't like java either... Action: dcmwai do love javascript :) no this is paid for work jamest: ah I see J2EE? no then... a program I inherited it's barely java complete mess IMHO oop... bad news... kinda fun i'm ripping the hell out of it one file was 3733 lines without many comments dcmwai: that whole form is going to change, it's the untouched piece of item_management.. old sku is a reference field to another sku, I intend to use it to associate paired products like ladies vs mens matching shirts, etc.. I think the original intention was a need to reference a replaced numbering system now it's 2741 and has comments and does a lot more stuff the dude didn't believe in functions i guess cut n paste is where it's at 3733 lines without many comments... hum (look like this so called programmer is like my standard) Just code No Comment jamest: Yes that is what I normally do :) Action: jamest thwaps dcmwai with a sturctured programming book Vee2d2: Oh I see Vee2d2: So it is going to change :) I scrapped a bunch of code in the thing I'm working on.. it's pretty clear the person wasnt altogether familiar with php/html/db... stuff.. dcmwai: not drastically I dont think.. but it's going to make use of those lookup tables well.. maybe drastically.. matter of opinion.. ;) Action: dcmwai Thank jamest if that book can be really here. Vee2d2: I know how it feel when you look on the code and don't really what they are for. or when you can do it is an more easier way there were made up tags and stuff in this code.. ? heh.. date | character varying(20) | not null haha yea, crap like that.. ;) this entire system is like this Action: dcmwai think they should pay us more ;0 only.. is varying() valid? character varying(20) ==> vchar I understand the intent, but dont recognise the syntax my favorite i can't not share this...i'm sorry ;) any time we need a timestamp in the db Calendar gc = new GregorianCalendar().getInstance(); String datetime = gc.get(Calendar.YEAR) + "-" + setUpDate(gc.get(Calendar.MONTH)) + "-" + gc.get(Calendar.DATE) + ///////////////// " " + gc.get(Calendar.HOUR_OF_DAY) + ":" + gc.get(Calendar.MINUTE) + ":" + gc.get(Calendar.SECOND); then passes the string instead of just doing now() in the sql so the dates in the db are all strings, all based on the clients clock and computed in every functoin that calls the db function that inserts it weee make note; computer date; pass date,note to insertNote function sorry , i will shut up now We're probably going to be migrating to postgresql sometime soon.. wonder if I can use designer to try and facilitate the migration somewhat.. this db I'm working with now has ~80 tables brb busy a while Action: Vee2d2 makes sheep noises and gets back to seeking the light oh boy Action: jamest doesn't want to know jamest: nice time thing ;P thanks where is that from? a java project I took over Action: jamest spent 20 hours working on it sat,sun man... 7 hours last night tonight I'm pushing 5 but got to do some web stuff first jamest: hum enjoying life isn't it :) something like that Something to ask about DB table numbers... If the more table they have what will be the disadvantage/advantage? Like SQL-ledger only have 28 Table, where Nola/arias have 167 tables basically they do the same stuff... Action: Vee2d2 knows far less about db design than the others here.. dcmwai: i heard that a SAP system has about 12'000 tables hmm.. not sure how helpful using designer to migrate the db will be because of how it handles the types.. but now idea if that is a full fledged system with all modules etc etc. ETOPS varchar(1) DEFAULT N, ZONAL varchar(1) DEFAULT N, haha. Action: Vee2d2 ponders if that's how it was to start.. checking... dcmwai: all depends on how the data is used...indices speed selects up but slow inserts and updates down, etc. joining tables can be expensive, etc. how "normalized" things are all good happy horse shit havoc (~havoc@CPE-65-31-122-112.wi.rr.com) got netsplit. SachaS (~sacha@online.havanawave.com) got netsplit. bah SachaS (~sacha@online.havanawave.com) returned to #gnuenterprise. havoc (~havoc@CPE-65-31-122-112.wi.rr.com) returned to #gnuenterprise. nah, they were char(1) going in.. gsscvs created the varchar(1) Action: chillywilly kicks freenode for dropping havoc bahehehe.. ^ my sheeply bah, btw. Action: jamest is sure he doesn't want to know .msg jamest http://www.muttonbone.com/ is where I got mine, I'm pretty sure they ship to KC, too. erp! roflmao with a slogan like "The inflatable love sheep" it's got to be good! endorsed by P.E.T.E.R., too.. People for the Ethical Treatment of Erotic Ruminants ok.... now all we need is inflatable love penguin for chilly here :) :) http://www.chadogroup.com/carla/penguin_love/ chillywilly: Thank, Now I get what you meant, Even if you have A lot of DB as long as it was normalized It will be fast to a certain extent I don't think most people go past 3rd normal form cause you can loose performance going further as then you have to join more tables chillywilly: Ok...Thank :) http://www.xsiv.com.au/se/item386.ehtml <-- there ya go jamest ;P http://www.thelittleshopofsextoys.com/2223.html haha --- Thu Aug 14 2003