*** Morphous has joined #gnuenterprise
*** Amorphous has quit IRC
*** sjc has joined #gnuenterprise
*** Amorphous has joined #gnuenterprise
*** Morphous has quit IRC
* dcmwai is back (gone 04:30:27)
*** bigbrother has joined #gnuenterprise
*** bigbrother has joined #gnuenterprise
<reinhard> wb bigbrother
<reinhard> good to see you back
<chillywilly> hello dudes
<jamest> yo chillywilly
<lekma> anybody willing to shed some light on how to use simpleQuery() (maybe a working example) ?
<jamest>       <field name="ntryzip" field="zip" max_length="5" min_length="5">
<jamest>         <trigger name="Trigger_1" type="PRE-FOCUSOUT"><![CDATA[
<jamest>         if len("%s%s" %(blckdtsrcschool.ntrycity,blckdtsrcschool.ntrystate)) == 0:
<jamest>           results = zipcodelookup.simpleQuery({"zip":self})
<jamest>           if len(results):
<jamest>             blckdtsrcschool.ntrycity  = results[0]['city']
<jamest>             blckdtsrcschool.ntrystate = results[0]['state']
<jamest>           else:
<jamest>             blckdtsrcschool.ntrycity  = ""
<jamest>             blckdtsrcschool.ntrystate = ""
<jamest>         ]]></trigger>
<jamest>       </field>
<jamest> where zipcodelookup is
<jamest>   <datasource name="zipcodelookup" connection="prod" table="zipcode"/>
<lekma>  results = zipcodelookup.simpleQuery({"zip":self}) <-- i don't get it (soy un poco stupido)
<lekma> how would you translate it in SQl
<lekma> select * from zipcode where???
<chillywilly> do you guys use getopt or optparse?
<chillywilly> optparse looks a bit nicer
*** dsmith has quit IRC
<jamest> {"zip":self}
<jamest> is a list of database field name:value pairs
<jamest> think of it like
<jamest> {"zip":"66506"}
<jamest> would return manhattan, ks
<jamest> er, well, the records from my zipcode lookup
<jamest> which is manhattan, ks :)
<jamest> if you need greater than one field
<jamest> {"zip":"66506", "city":"MANHATTAN"}
<jamest> would generate
<jamest> select * from zipcode where zip = "66506" and city = "MANHATTAN"
<jamest> if you need to do conditionals other than and
<jamest> well
<jamest> you can't :)
<jamest> that's why simpleQury
*** sjc has joined #gnuenterprise
*** reinhard has quit IRC
*** dyfet has joined #gnuenterprise
*** johannesV_ has quit IRC
*** dsmith has joined #gnuenterprise
*** dyfet has quit IRC
*** dneighbo_ has joined #gnuenterprise
*** Morphous has quit IRC
*** dneighbo has quit IRC
*** konijn has quit IRC
*** Amorphous has joined #gnuenterprise
*** kilo has joined #gnuenterprise
*** kreiszner has joined #gnuenterprise
*** kreiszner has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** kreiszner has quit IRC
*** kreiszner has joined #gnuenterprise
*** kreiszner2 has joined #gnuenterprise
*** kreiszner2 has left #gnuenterprise
*** kreiszner2 has joined #gnuenterprise
<kreiszner2> I noticed that the .deb packages had .exe extensions. Are they the right ones and if not where?
*** wayneg1 has joined #gnuenterprise
*** btami has joined #gnuenterprise
*** kreiszner2 has quit IRC
*** kreiszner2 has joined #gnuenterprise
<kreiszner2> I noticed that the latest .deb packages had .exe extensions. Are they the right ones and if not where?
<btami> kreiszner2: http://ajmitch.dhis.org/debuild/gnue/
<kreiszner2> thanks. Somebody needs to change the gnue site.
<btami> yes
<reinhard> btami: you've got a second?
<reinhard> i was looking at the changes you made in setup.py
<reinhard> (as you requested)
<reinhard> and i'm not sure i understand what is the reason for this change
<btami> i tryed to build .rpm packages with "python setup.py bdist_rpm"
<btami> it had some issues 
<btami> with .mo files
<btami> with paths.py
<btami> with gnue.pth
<reinhard> i saw you included a "locales" directory in the source distribution
<reinhard> i'm not sure if this is the right way to do it
<btami> i'm not sure too :)
<reinhard> :)
<jamest> btami: i am going to start work on dropdowns tonight
<jamest> as the current stuff simply doesn't work at all for most people I've talked to
<jamest> which too be fair is myself, reinhard, jcater
<jamest> :)
<kilo> 8-)))
<jamest> but it's causing issues at a customers site and their upgrade to the latest stuff has broke several of their forms
<kilo> jamest: have you received my email the other day?
<jamest> kilo: i'm burried in work and haven't checked email for gnue in > 1 week
<jamest> let me look
<btami> jamest: i think we (kile and me) are using wx compiled with gtk2+unicode
*** wayneg1 has quit IRC
*** wayneg has quit IRC
<btami> maybe this is the reason of difference...
<jamest> kilo: ah, you sent in the written paperwork and got that back?
<kilo> aye
<btami> reinhard: please feel free to change my initial patches for bdist_rpm!
<reinhard> btami: i think i will have a look at it
<btami> thx
<jamest> i can't confirm receipt anymore as my fsf account doesn't seem to work
<jamest> i msg'd derek a while ago about someone elses and didn't hear back so I don't know if his account works either
<jamest> if I can't get the confirm from someone then we'll just wing it
<kilo> ok, what does that mean then? 8-))
<jamest> that means that i'm frustrated
<jamest> and I'll take you at your word 
<jamest> what part of gnue you planning to work on
<jamest> i seem to recall btami applying patches from you several times
<kilo> definitely NOT appserver
<btami> :)
<jamest> shhhhh
<jamest> you might make reinhard feel bad
<kilo> forms i think, i18n
<jamest> :)
<reinhard> kilo: :)
<reinhard> btami: any hint how i can easily test rpm's on debian?
<ajmitch> rpms? :)
*** kreiszner2 has quit IRC
<kreiszner> .
<reinhard> ..
<jamest> reinhard: install rpm
<jamest> or install alien
<jamest> and use it to convert the rpm to .deb
<jamest> then install via dpkg
<kreiszner> just checking to see which name I was really checked in as
<kilo> btw jamest, why does gnue need a connection.conf even when an app does not use connections at all?
<kilo> like intro,gfd
<jamest> a long running bug I imagine
<reinhard> jamest: thanks
<kilo> GBaseApp init does all kind of connection.conf related things
<btami> reinhard: i'v just used mc to look into them :)
<kilo> but imho it should be onlye done somewhere in datasources
<reinhard> btami: :)
<btami> then asked jamest to test :)
<lekma> svn: Can't connect to host 'svn.gnuenterprise.org': Connection refused
<lekma> is there a problem with svn server?
<jamest> lekma: try again
<lekma> jamest: it works... you're a wizzard :-)
<btami> jamest: i'v just changed
<btami> handleFileType("deb", "Debian GNU/Linux Packages", $dir, $sortby);
<btami> to 
<btami> handleFileType(".deb", "Debian GNU/Linux Packages", $dir, $sortby);
<btami> in www/web/share/_listdir.php
<btami> to avoid -debug.exe files under .deb section
<btami> but it's not working :(
<jamest> try \.
* btami never programmed in php
<jamest> as I imagine the . is being taken as part of a regex
<jamest> or maybe
*** kreiszner has quit IRC
<jamest> handleFileType("deb$", "Debian GNU/Linux Packages", $dir, $sortby);
* ajmitch takes a look to see where the debs are..
*** dsmith has quit IRC
<ajmitch> aha
<ajmitch> there are none on that page
<chillywilly> hi ajmitch 
* chillywilly got the new flat panel at work and is in love
* chillywilly drools
<ajmitch> hello
<reinhard> night all
*** reinhard has quit IRC
*** wayneg has joined #gnuenterprise
<btami> night
*** btami has quit IRC
*** lekma has quit IRC
*** jamest has quit IRC
*** kilo has quit IRC
*** jcater has quit IRC
*** jamest has joined #gnuenterprise
*** lekma has joined #gnuenterprise
<lekma> Form contains a <image> and image support not loaded <-- what does this mean?
<lekma> error message when trying <image>
<lekma> tag
<lekma> what "image support" should i load?
<ajmitch> jamest: you make screwy tarballs :)
<ajmitch> -rw-r--r-- jamest/jamest      0 1983-04-13 22:40:45 GNUe-Common-0.5.4/src/logic/__init__.py
<jamest> lekma: python image library
<ajmitch> also GNUe-Common-0.5.4/src/logic/adaptors/__init__.py
<jamest> ajmitch: my multiboot setup was screwy wrt to time settings
<ajmitch> ok
<ajmitch> it's just odd that it only affected 2 files
<jamest> i think they are ironed out now
<jamest> don't ask me
<jamest> as i'd reset the system and hwclock 
<jamest> and after a few reboots I was time traveling again
<jamest> does anyone here have working dropdowns?
<jamest> with the current cvs head?
<ajmitch> heh
*** jcater has joined #gnuenterprise
<ajmitch> hi jcater
<jcater> howdy
<jamest>  [06:08:17 pm] <jamest>does anyone here have working dropdowns?
<jamest>  [06:08:22 pm] <jamest>with the current cvs head?
<jcater> I have not used cvs head in production
<jamest> i need someone to try something for me
<ajmitch> hmm
<jbailey> woohoo.  Just orphaned dcl in Debian.
<ajmitch> yay
<ajmitch> I thought you had someone to pick it up though
<jbailey> He's not a DD yet, and dealing with a PHP package is sufficiently painful that I don't feel like sponsoring him.
<jbailey> Having never succesfully installed it, I also have trouble working up the enthusiasm for it.
<ajmitch> jamest: any chance of getting a new tarball with the dates fixed? the debian upload is rejected just because of screwy dates :)
<ajmitch> heh
<ajmitch> I've got a working DCL install :)
<jbailey> ajmitch: Poor you.
<ajmitch> but it's not something I'd want to maintain
<jamest> ajmitch: maybe in a bit
<jbailey> ajmitch: I occasionally think that I should write a forms/appserver version of it, using the same schema and offer it as gnue-crm. =)
<jamest> i desperately need to get dropdowns working about
<ajmitch> ok
<jamest> s/about/again
<ajmitch> mind if I do a 0.5.4.1 tarball for myself then?
<ajmitch> with only the dates fixed?
<ajmitch> I want to avoid you releasing a 0.5.4.1 with other fixes & haveing two numbers the same :)
<jamest> i think it's safe to say we will never have a 0.5.4.1
<ajmitch> alright
<ajmitch> more likely to have 0.5.5
<jamest> so i'd say go for it
<ajmitch> thanks
<lekma> jamest: with latest svn dropdowns doesn't seem to work for me
<lekma> i somehow have to select the empty record on top of the dropdown list
<lekma> to make it see a change in selection
<jamest> ok that's what I'm seeing to
*** sjc has left #gnuenterprise
<jamest> lekma: care to svn up and try again?
<lekma> jamest: on the matter of selection it's better, but
<lekma> it seems to trigger pre- and post-change only once
<lekma> when the first selection is made.
*** bailey has left #gnuenterprise
<jamest> :(
<jamest> it's registering the pre-/post- change on field exit
<lekma> jamest: yes, but only for the first change
<jamest> i'm seeing it for every change
<jamest> let me see if I missed a commit
<jamest> 2 triggers
<jamest> pre-change and post-change on a dropdown
<jamest> all they do is print a line
<jamest> i change the 1st dropdown on zipcode.gfd from the forms samples
<jamest> changed it 3 times and see
<jamest> re-change
<jamest> Post-change
<jamest> Pre-change
<jamest> Post-change
<jamest> Pre-change
<jamest> Post-change
<jamest> i added these triggers to the state field
<jamest>       <trigger type="PRE-CHANGE" name="autoPull"><![CDATA[
<jamest>         print "Pre-change"
<jamest>       ]]></trigger>
<jamest>       <trigger type="POST-CHANGE" name="autoPull"><![CDATA[
<jamest>         print "Post-change"
<jamest>       ]]></trigger>
<jamest> can you see how that form behaves for you?
<lekma> i first have to create the db and the connection...
<lekma> but i have the same test case with a pre- and post- printing only the content of the dropdown
<lekma> and it does print only once
<lekma> something weird: when i type in the dropdown (autocompletion way) then the post and pre-change are triggered
<jamest> they are handled differently
<jamest> via the text events
<jamest> it's the combo box mouse events that are iffy
*** jamest has quit IRC
*** lekma has quit IRC
*** jcater has quit IRC
*** holycow has joined #gnuenterprise
*** lekma has joined #gnuenterprise
<lekma> how to force a block to requery records after a commit
<lekma> and not display what's in the cache?
*** chillywi1ly has joined #gnuenterprise
*** chillywilly has quit IRC
*** lekma has quit IRC