01:19:52
|
<bwolfe> emeka: you can make it work a little easier if you change the tomcat settings
|
01:19:57
|
<bwolfe> and/or the mysql settings
|
01:20:21
|
<bwolfe> that "server" should be fine for up to at least 10000 patients and 20 simultaneous users
|
01:21:05
|
<emeka> okay cool, i'm actually finding it's running much faster with a less priveleged provider user
|
01:21:28
|
<emeka> and it the time it really slowed down was during the installation of xforms, but now it's back up
|
01:23:05
|
*** Mkop has joined #openmrs
|
01:23:05
|
*** ChanServ sets mode: +v Mkop
|
01:23:50
|
<emeka> alright i'm gonna head out, but thanks for all the help guys, i'll be back soon
|
01:29:21
|
*** emeka has quit IRC
|
02:09:05
|
*** gauravpaliwal has joined #openmrs
|
02:18:10
|
<gauravpaliwal> Hi , if I need to access the newly created relation in the openmrs database by my module , then do i have to any way to acces the database without modifying the core openmrs API
|
02:18:11
|
<gauravpaliwal> ??
|
02:28:57
|
<bwolfe> yes, create a service and dao and read it via your module
|
02:29:27
|
<gauravpaliwal> @bwolfe : thanks for the pointer
|
02:41:25
|
<efes> guys, I have DB table with parametrers, ID, name, lastname, age, percentage, height
|
02:41:42
|
<efes> What's proper SQL query to select the tallest and the oldest guy?
|
02:43:31
|
<bwolfe> efes: is this a homework assignment?
|
02:43:38
|
<efes> not at all
|
02:43:55
|
<efes> I did my SQL course long time ago
|
02:44:04
|
<efes> maybe too long
|
02:44:10
|
<bwolfe> whats this for then? :-)
|
02:44:39
|
<efes> I don't want use 'limit'
|
02:45:10
|
<bwolfe> ha, no limit?
|
02:45:11
|
<efes> SELECT * from TABLE where AGE=(SELECT MAX(AGE) FROM TABLE) AND HEIGHT=(SELECT MAX(HEIGHT) FROM TABLE);
|
02:45:30
|
<efes> I'm lookin' for something prettier ;]
|
02:45:41
|
<bwolfe> what will only give you a row if the person is BOTH the oldest and the tallest
|
02:45:51
|
<efes> yesss
|
02:45:52
|
<bwolfe> you will get no hits if the oldest person is not the tallest person
|
02:46:00
|
<efes> yesss
|
02:46:06
|
<efes> that's what i'm asking about
|
02:46:24
|
<bwolfe> so you want two rows back?
|
02:46:30
|
<efes> No.
|
02:47:00
|
<efes> I want get name of the tallest from the oldest.
|
02:47:28
|
<efes> bwolfe: I cannot figure out how to "pass a table as an argument" to another table.
|
02:47:29
|
<bwolfe> ok
|
02:47:42
|
<bwolfe> ha, no idea what you mean. and sql doesn't have parameters
|
02:47:54
|
<bwolfe> as far as sql for the other question:
|
02:48:08
|
<efes> e.g. "Select max(height) from table " generates one table. If I could assign it to ... variable V, then I could do
|
02:48:22
|
<efes> select name, max (age) from V;
|
02:48:44
|
<bwolfe> um, you're not making sense
|
02:48:49
|
<bwolfe> do you have multiple heights?
|
02:48:51
|
<bwolfe> or multiple tables?
|
02:49:14
|
<bwolfe> random question: anyone here a tmobile customer? I need some unlock codes for phones I just got...
|
02:49:17
|
<efes> In fact an example I asked you about is much simplified. My "real" example is a little bigger :D
|
02:49:29
|
<bwolfe> efes: I can tell
|
02:50:00
|
<efes> One client has One height and One age.
|
02:50:12
|
<efes> I want select the tallest from the oldest
|
02:50:29
|
<efes> Isn't it just about doing double sorting + "limit 1" ?
|
02:51:08
|
<efes> select name from table order by height desc, age desc limit 1; ?
|
02:51:42
|
<bwolfe> please explain "I want select the tallest from the oldest"
|
02:52:35
|
<bwolfe> that sql you posted will get the tallest person, and if there are two tallest people, then the older one is returned
|
02:53:05
|
<efes> and that's what I was searching for :)
|
02:53:07
|
<efes> Thanks :)
|
02:53:28
|
<bwolfe> ok
|
02:53:29
|
<bwolfe> great!
|
02:53:31
|
<efes> Sometimes just talking helps. Even, if such talking is not about tech stuff.
|
02:59:55
|
<bwolfe> hmm
|
03:00:01
|
<bwolfe> so no T-Mobile people in here?
|
03:00:33
|
<gauravpaliwal> @bwolfe : need ur reviews on this patch that I submitted : https://tickets.openmrs.org/browse/TRUNK-1838
|
03:03:09
|
<efes> bwolfe: Sorry.... :| I thought it's # #programming :/
|
03:12:17
|
*** megaman has joined #openmrs
|
03:13:40
|
<megaman> Hello
|
03:13:58
|
*** gauravpaliwal has left #openmrs
|
03:18:25
|
<bwolfe> hi megaman
|
03:20:17
|
<megaman> bwolfe: Hi! I have a question
|
03:21:08
|
<megaman> Do I need the Oblivion to open an omod file???
|
03:21:28
|
<bwolfe> I don't know what the oblivion is
|
03:21:38
|
<bwolfe> see the creating modules page for what an omod is
|
03:21:44
|
<bwolfe> *the creating modules wiki page
|
03:21:54
|
<bwolfe> its just a jar file with a diff extension to make it unique
|
03:21:58
|
<bwolfe> and a jar is just a zip file
|
03:22:20
|
<megaman> I read that an omod file is a jar, is that right??
|
03:23:26
|
<bwolfe> yes, see what I said two lines up. :-p
|
03:25:01
|
<megaman> So... Can I change the extention of the omod??
|
03:34:27
|
*** Mkop has quit IRC
|
03:41:12
|
*** harsha has joined #openmrs
|
03:41:44
|
<harsha> hi Ben
|
03:41:52
|
<harsha> you around ?
|
03:43:47
|
<bwolfe> megaman: you can change it if you want. why do you need to? I can't remember if openmrs expect the extension to be omod or not
|
03:43:51
|
<bwolfe> harsha: for a few more minutes
|
03:44:17
|
*** gbastien has joined #openmrs
|
03:44:22
|
<harsha> bwolfe: great,
|
03:45:50
|
<harsha> bwolfe: regarding the Universal Search Box project, would it better to start this as a separate module or along with a existing module
|
03:46:20
|
<bwolfe> separate
|
03:46:31
|
*** efes has quit IRC
|
03:47:20
|
<megaman> bwolfe: I need to do a module, but I can't, I installed everything and I don't get it
|
03:47:23
|
<harsha> would not it better do this along with the logic module as ultimately this should retain along with all the modules
|
03:47:49
|
<bwolfe> megaman: did you see the "creating my first module" ?
|
03:48:02
|
<bwolfe> harsha: no, its a separate thing
|
03:48:13
|
<harsha> bwolfe: okay
|
03:49:01
|
<megaman> bwolfe: Yes, I'm reading it right now
|
03:51:23
|
<megaman> bwolfe: I have Eclipse Helios and I got this message http://pastebin.com/z4QJGHe2
|
03:57:11
|
<bwolfe> megaman: make sure your eclipse instance is loaded with the jdk, not the jre
|
03:57:32
|
<bwolfe> there are a few QAs on how to fix this (but not on the openmrs wiki that I know of)
|
03:57:56
|
<bwolfe> ...and with that I'm off to bed. sorry I can't see you through it.
|
04:02:14
|
<megaman> bwolfe: Thanks, I'm searching the solution
|
04:02:39
|
<harsha> bwolfe: have a nice sleep, bye
|
04:02:39
|
*** bwolfe has quit IRC
|
04:05:18
|
*** nad88 has joined #openmrs
|
04:14:03
|
*** megaman has quit IRC
|
04:16:07
|
*** gbastien has quit IRC
|
04:30:34
|
*** mjohnst has quit IRC
|
04:41:20
|
* nad88 test
|
04:51:29
|
*** nad88 has quit IRC
|
04:52:58
|
*** nad88 has joined #openmrs
|
04:54:17
|
*** aja has joined #openmrs
|
04:55:24
|
*** aja has quit IRC
|
05:14:04
|
*** Chaitalishah has joined #openmrs
|
05:15:31
|
*** Chaitalishah has quit IRC
|
05:17:08
|
*** suho has joined #openmrs
|
05:30:38
|
*** deadpool has quit IRC
|
05:32:56
|
*** Chaitalishah has joined #openmrs
|
05:38:22
|
*** arthur_sribeiro has joined #openmrs
|
05:39:03
|
*** arthur_sribeiro has quit IRC
|
05:40:37
|
*** arthursribeiro has quit IRC
|
06:24:33
|
*** harsha has left #openmrs
|
06:28:17
|
*** dhanushka has joined #openmrs
|
06:28:39
|
*** dhanushka has left #openmrs
|
06:51:38
|
*** nad88 has left #openmrs
|
07:20:05
|
*** ashishmittal has joined #openmrs
|
08:02:22
|
*** bryq has joined #openmrs
|
08:03:25
|
*** Chaitalishah has quit IRC
|
08:07:17
|
*** ashishmittal has quit IRC
|
08:22:16
|
*** ashishmittal has joined #openmrs
|
09:09:33
|
*** Chaitalishah has joined #openmrs
|
09:37:41
|
*** suhothayan has joined #openmrs
|
09:41:00
|
*** suho has quit IRC
|
09:44:49
|
*** suhothayan has quit IRC
|
09:54:42
|
*** rafa has joined #openmrs
|
09:54:42
|
*** ChanServ sets mode: +v rafa
|
10:15:43
|
*** pascal` has joined #openmrs
|
10:17:05
|
<bryq> Hi rafa, I've decited to create a wiki page instead of sending you an email with questions. It will be better for both of us and for the other people interested in Metadata Sharing. If you have some spare time look at it: https://wiki.openmrs.org/display/~bryq/GSoC+2011+-+Metadata+Sharing+project+draft
|
10:17:09
|
<OpenMRSBot> <http://ln-s.net/8f1z> (at wiki.openmrs.org)
|
10:25:20
|
*** suho has joined #openmrs
|
10:27:16
|
<rafa> Hi bryq, I'll try to find time to review your patch/page and give you feedback by tomorrow. We'll be in touch.
|
10:27:45
|
<bryq> rafa: Ok
|
10:28:03
|
<rafa> bryq: I need to go know. Have a nice day! ttyl
|
10:28:16
|
<bryq> rafa: See you!
|
10:29:46
|
*** rafa has quit IRC
|
10:31:43
|
*** Chaitalishah has quit IRC
|
10:35:20
|
*** Chaitalishah has joined #openmrs
|
10:38:25
|
*** suho has quit IRC
|
11:09:25
|
*** aja has joined #openmrs
|
11:24:47
|
*** ashishmittal has quit IRC
|
11:58:25
|
*** ashishmittal has joined #openmrs
|
13:06:11
|
*** pascal` has quit IRC
|
13:18:19
|
*** pascal` has joined #openmrs
|
13:32:33
|
*** bryq has quit IRC
|
13:43:24
|
*** aja has quit IRC
|
13:45:09
|
*** gbastien has joined #openmrs
|
13:46:17
|
*** bwolfe has joined #openmrs
|
13:46:17
|
*** ChanServ sets mode: +o bwolfe
|
13:46:17
|
*** OpenMRSBot sets mode: +o bwolfe
|
13:49:29
|
*** Mkop has joined #openmrs
|
13:49:29
|
*** ChanServ sets mode: +v Mkop
|
13:50:49
|
*** bwolfe has quit IRC
|
14:04:21
|
*** bwolfe has joined #openmrs
|
14:04:21
|
*** ChanServ sets mode: +o bwolfe
|
14:05:36
|
*** nad88 has joined #openmrs
|
14:27:22
|
*** bwolfe has quit IRC
|
14:45:03
|
*** ashishmittal has quit IRC
|
14:55:10
|
*** bwolfe has joined #openmrs
|
14:55:10
|
*** ChanServ sets mode: +o bwolfe
|
14:55:10
|
*** OpenMRSBot sets mode: +o bwolfe
|
15:02:54
|
*** suho has joined #openmrs
|
15:03:12
|
<suho> hi bwolfe
|
15:25:08
|
*** nribeka has quit IRC
|
15:29:16
|
*** rafa has joined #openmrs
|
15:29:16
|
*** ChanServ sets mode: +v rafa
|
15:51:28
|
*** rafa has quit IRC
|
15:56:49
|
*** mjohnst has joined #openmrs
|
16:06:57
|
*** dkayiwa has joined #openmrs
|
16:17:10
|
*** arthursribeiro has joined #openmrs
|
16:30:20
|
*** Chaitali_ has joined #openmrs
|
16:34:20
|
*** Chaitalishah has quit IRC
|
16:42:10
|
*** nad88 is now known as nad
|
16:43:41
|
*** nad has quit IRC
|
16:47:53
|
*** pulasthi has joined #openmrs
|
16:57:36
|
<suho> hi bwolfe
|
16:58:12
|
<arthursribeiro> hey everybody, I'm trying to run openmrs via Maven but I'm getting the following error: http://pastebin.com/2Keaqfbb - Can anyone help me?
|
17:05:38
|
*** ashishmittal has joined #openmrs
|
17:06:31
|
*** nadh has joined #openmrs
|
17:07:49
|
*** nadh has left #openmrs
|
17:09:25
|
*** nadh has joined #openmrs
|
17:12:32
|
<suho> hi arthursribeiro
|
17:12:51
|
<arthursribeiro> hi suho
|
17:13:21
|
<suho> delete the .jar form C:\Documents and Settings\Administrador\.m2\repository\javax\mail\mail\1.4.1\mail-1.4.1.jar
|
17:13:30
|
<suho> and try again
|
17:14:29
|
<arthursribeiro> suho, ok, I'm going to do this.
|
17:28:09
|
<suho> arthursribeiro, how did it go ?
|
17:28:30
|
<arthursribeiro> it's downloading so many files right now...
|
17:28:41
|
<arthursribeiro> aparently the error is not going to appear...
|
17:28:58
|
<suho> great :)
|
17:30:20
|
*** aja has joined #openmrs
|
17:31:17
|
*** suho has quit IRC
|
17:38:47
|
*** rafa has joined #openmrs
|
17:38:48
|
*** ChanServ sets mode: +v rafa
|
17:42:05
|
*** suho has joined #openmrs
|
17:56:02
|
*** nadh has quit IRC
|
17:56:57
|
*** emeka has joined #openmrs
|
18:07:47
|
*** emeka_ has joined #openmrs
|
18:11:05
|
*** emeka has quit IRC
|
18:11:05
|
*** emeka_ is now known as emeka
|
18:13:19
|
*** Chaitali_ has quit IRC
|
18:13:45
|
*** Chaitalishah has joined #openmrs
|
18:15:03
|
*** pascal` has quit IRC
|
18:31:03
|
*** ashishm has joined #openmrs
|
18:31:28
|
*** ashishm has quit IRC
|
18:34:06
|
*** ashishmittal has quit IRC
|
18:43:32
|
*** deadpool has joined #openmrs
|
18:52:36
|
*** aja has quit IRC
|
18:53:10
|
*** pulasthi1 has joined #openmrs
|
18:54:45
|
*** rafa has quit IRC
|
18:55:09
|
*** pulasthi has quit IRC
|
19:01:06
|
*** ashishmittal has joined #openmrs
|
19:14:32
|
*** Chaitali_ has joined #openmrs
|
19:15:44
|
*** Chaitalishah has quit IRC
|
19:22:23
|
*** dkayiwa has quit IRC
|
19:29:14
|
*** dkayiwa has joined #openmrs
|
19:45:38
|
*** emeka has left #openmrs
|
19:46:06
|
*** emeka has joined #openmrs
|
20:00:21
|
*** pulasthi1 has quit IRC
|
20:04:59
|
*** downeym has joined #openmrs
|
20:04:59
|
*** ChanServ sets mode: +o downeym
|
20:05:13
|
*** downeym has quit IRC
|
20:09:29
|
*** emeka has quit IRC
|
20:13:22
|
*** efes has joined #openmrs
|
20:27:02
|
*** Chaitali_ has quit IRC
|
20:29:09
|
<mjohnst> i checked out the OpenMRS trunk using Maven, but I didn't get a simple openmrs project like the tutorial said. I did get a openmrs-tools which it didn't mention though. do i need openmrs to work on the project?
|
20:41:03
|
*** Echidna has quit IRC
|
20:45:07
|
*** Echidna has joined #openmrs
|
20:45:07
|
*** ChanServ sets mode: +v Echidna
|
20:54:47
|
*** cta has joined #openmrs
|
20:56:42
|
<cta> /msg bwolfe Hello, mr. Ben Wolfe. I still have a question))
|
20:57:35
|
<efes> Hi folks :)
|
20:57:54
|
<efes> Do you share OpenMRS's code in WAR files?
|
21:00:15
|
*** ashishmittal has quit IRC
|
21:09:01
|
*** bwolfe has quit IRC
|
21:10:53
|
*** cta has quit IRC
|
21:17:20
|
*** dkayiwa has quit IRC
|
21:20:27
|
<arthursribeiro> suho, thank you so much... sucess in everything...
|
21:30:10
|
*** robbyoconnor has quit IRC
|
21:30:30
|
*** robbyoconnor has joined #openmrs
|
21:30:30
|
*** ChanServ sets mode: +v robbyoconnor
|
21:40:00
|
*** bwolfe has joined #openmrs
|
21:40:00
|
*** ChanServ sets mode: +o bwolfe
|
21:54:36
|
*** robbyoconnor has quit IRC
|
22:01:43
|
*** suho has quit IRC
|
22:05:25
|
*** robbyoconnor has joined #openmrs
|
22:05:25
|
*** ChanServ sets mode: +v robbyoconnor
|
22:32:28
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Modules: Growth Chart 1.6 uploaded to OpenMRS Module Repository <https://dev.openmrs.org/modules/view.jsp?module=growthchart&version=&1.6>
|
22:48:00
|
*** Mkop has quit IRC
|
23:10:54
|
*** emeka has joined #openmrs
|
23:21:36
|
*** emeka has quit IRC
|
23:38:53
|
<efes> What IDE you mostly use with openmrs?
|
23:50:37
|
<mjohnst> eclipse
|