Hi,
I could create some for you, but we are using only lower and and upper boundary
values
limits and no critical and toxic values. Those are considered by doctor on case
basis.
Mauri
On 28 Sep 2010 at 11:56, Gjergj Sheldija wrote:
> hi all,
>
> can somebody create some sample parameters
Hi Robert,
In the light of this, the ADOdb v5.10 and 5.11 should be compared for
differences in implementation of the last Insert ID retrieval for MySQL.
Also to be checked out is the need for my SVN commit of 6801 where the
$_SESSION['sess_en'] parameter was set
and to see if GJ's advice for re
Hi Muthu,
Full ack. In fact, an adodb upgrade I have longer in my target. Gjegrj
changed it for the gettext branch and it was working just out of
copy&paste step. So he did it once, so he is now our ninja for this
work :-D
@Gjergj, can you please test out if the adbodb upgrade will work on
TRUNK
Hi Mauri,
That would be great. Upper and lower boundary values differ, that is
correct - but basically the entries would be correct. That should be the
main target.
Maybe Gjergj could post here some words about changes and settings of
lab and what must be done (and that description could be used
Hi Mauri,
as Robert said that would really be great.
there are no major changes in the lab. just create the categories and the
parameters. there are a couple of more fields like max and min for males,
females, kids and
such, but those are a bit specific.
if you need more details, please let me kno
The current ADOdb library is v5.11 on Care2x SVN trunk.
It was v5.10 till about 2 to 3 weeks ago.
When a record is inserted into a table, we use ADOdb's method $db->Insert_ID()
to get us the last inserted ID where $db is the ADOdb connection object.
The definition of the said method is in classes
hi muthu,
if you read the comments of fucntion Insert_ID() in file
adodb.in.php
it writes
/**
* @param $table string name of the table, not needed by all
databases (eg. mysql), default ''
* @param $column string name of the column, not needed by all
databases (eg. mysql), def
Values could be race / ethnicity specific as well - Caucasian, Negroid,
Mongoloid
Hi Mauri,
as Robert said that would really be great.
there are no major changes in the lab. just create the categories and the
parameters. there are a couple of more fields like max and min for males,
...I tested out with mysql client and standard call, and it worked
perfectly:
mysql> create database dropme;
Query OK, 1 row affected (0.02 sec)
mysql> \u dropme
Database changed
mysql> CREATE TABLE `care_person` ( `pid` int(11) unsigned NOT NULL
AUTO_INCREMENT, `name` varchar(60) NOT NULL,
Thanks GJ for the MySQL defaults.
In v5.11 - adodb.inc.php:
function RowLock($table,$where,$col='1 as adodbignore')
was in v5.10
function RowLock($table,$where,$col='1 as ignore')
Now analysing the differences between v5.11 and v5.10, we find that a new
class variable called
var $bulkB
Hi Muthu,
okay, first we had wrong parameter in lab and now we should not miss the
aim and fall into latest genetic researches. What do you think about a
compromise between "symbolic" and "latest genetic researches"... ;-)
I think Mauri has the best skills of us all here to decide what kind of
pa
Hi Robert,
Try to make the table without any records and the default AUTO_INCREMENT to
start with should be 1 (if the parameter AUTO_INCREMENT=1is omitted).
Then make an insert with a pid = 1000 in the insert statement and check
the Last insert ID():
CREATE TABLE `care_person` (
`pid` int(1
I am honestly clueless on the parameters issue.
I haven't as yet gone into the vertical functional as yet.
Yes, Mauri should decide what is best under the circumstances.
Let the values be plausible - erring on the safe side - whatever that means!
> Hi Muthu,
>
> okay, first we had wrong parameter
Sorry, I do not get the point. When you do that then you will have the
query result of LAST_INSERT_ID() 1001
There is on table definition an autoincrement and you give in your
insert statement an fixed value to it? The result is always strange
(guess it will be 1001 instead of 1000
Hi,
I just tested it out here as well:
mysql> CREATE TABLE `care_person` ( `pid` int(11) unsigned NOT NULL
AUTO_INCREMENT, `name` varchar(60) NOT NULL, PRIMARY KEY (`pid`) )
ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.02 sec)
mysql> INSERT INTO `care_person` (`pid`, `na
If the following is executed before attempting to create a new first person
then the last insert id of adodb will work:
ALTER TABLE `care_person` AUTO_INCREMENT=999;
> Hi Robert,
>
> I have tested it to be a MySQL issue and not a ADOdb issue.
> On execution of the said statements, I get th
My test is under Debian Lenny
The SQL client was from Windows - SQLyog.
MySQL v5.0.51a-24+Lenny4
concurrent_insert = 1
innodb_commit_concurrency = 0
> Hi,
>
> I just tested it out here as well:
> mysql> CREATE TABLE `care_person` ( `pid` int(11) unsigned NOT NULL
> AUTO_INCREMENT, `name` varc
veto! :-)
Either we have a reliable PID or not. When we register a patient it
should be give a uniqie PID, handled by sessions and db in the same way.
This is the once and only identifier for an patient record and we should
not make workarounds in it. All other patient demographic information
hand
actually it's a bit more simple
the first time it executes the query the AUTOINCREMENT value is not set,
so it gets 0. the second time it works correctly.
now we have two solutions :
- in the sql creation script of the person table add an
AUTOINCREMENT=100
- or create a configuration value
The existing fix to use the POST value seems best under the circumstances
for a first jump in auto increment value.
As this is a purely MySQL version dependant issue, lets leave it at that for
now but keep our eyes open for any similar jumps in auto increment values.
Actually, the Auto increment v
Hi Muthu,
Yes, that is perfect. Just thinking now if the workaround from yesterday
night would do that job now out of the box? $pid is empty, so it would
be the session pid been used...
I have to test it later today. Sorry...
Robert
Am Mittwoch, den 29.09.2010, 17:37 +0530 schrieb Ap.Muthu:
>
To bring the DB upto SVN 6828, the following SQL needs to be executed:
CREATE TABLE IF NOT EXISTS `care_med_orderlist_sub` (
`sub_order` int(20) NOT NULL AUTO_INCREMENT,
`order_nr_sub` int(20) NOT NULL,
`bestellnum` varchar(25) DEFAULT '0',
`idsub` varchar(20) NOT NULL DEFAULT '0
Thanks :-D
Robert
Am Mittwoch, den 29.09.2010, 18:08 +0530 schrieb Ap.Muthu:
> CREATE TABLE IF NOT EXISTS `care_med_orderlist_sub` (
> `sub_order` int(20) NOT NULL AUTO_INCREMENT,
> `order_nr_sub` int(20) NOT NULL,
> `bestellnum` varchar(25) DEFAULT '0',
>
Hi GJ / Robert,
Please look at line 104 of
modules/registration_admission/show_weight_height.php
Anything amiss?
Regards,
Ap.Muthu
--
Start uncovering the many advantages of virtual appliances
and start using them to
On a fresh install of SVN 6825, GJ's latest DICOM Viewers fail to run.
Regards,
Ap.Muthu
--
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelera
Why are we having two sets of tables
- care_med_*
- care_pharma_*
all having essentially the same structures ?
Regards,
Ap.Muthu
--
Start uncovering the many advantages of virtual appliances
and start using them to sim
Hi Muthu,
Found that as well some weeks ago. We have to check where it is been
called, not that easy because a quick search by editor or grep will
might not give a correct answer.
But yes, it sounds a bit like a clone...
Robert
Am Donnerstag, den 30.09.2010, 11:01 +0530 schrieb Ap.Muthu:
> Wh
Hi Muthu,
Stupid question: Where will it be called?
Robert
Am Donnerstag, den 30.09.2010, 00:10 +0530 schrieb Ap.Muthu:
> Hi GJ / Robert,
>
> Please look at line 104 of
> modules/registration_admission/show_weight_height.php
> Anything amiss?
>
> Regards,
> Ap.Muthu
>
>
>
> --
1. What is the purpose of the table: care_role_person ?
2. Fresh Install of SVN 6830:
Create a superuser with Medical Consultant Role (all areas) and assign all
depts.
Login as this superuser.
Each Scenario is done from this point (truncare care_person,
care_person_insurance tables before each
It is called on the admitted patient right menu - under Measurements menu.
Put in a fix for correcting it to the way it is now. Check the revision log
for what it was.
> Hi Muthu,
>
> Stupid question: Where will it be called?
>
> Robert
>
>
> Am Donnerstag, den 30.09.2010, 00:10 +0530 schrieb Ap
Ok, thanks :-)
Robert
Am Donnerstag, den 30.09.2010, 11:32 +0530 schrieb Ap.Muthu:
> It is called on the admitted patient right menu - under Measurements menu.
> Put in a fix for correcting it to the way it is now. Check the revision log
> for what it was.
>
>
> > Hi Muthu,
> >
> > Stupid ques
Personell -> Create new Person-> Employ and Assign as doctor to one dept and
can do so repeadedly!
Regards,
Ap.Muthu
--
Start uncovering the many advantages of virtual appliances
and start using them to simplify applic
We are unable to update an admitted outpatient 's admission data since the
update form shows a blank dept list.
Regards,
Ap.Muthu
--
Start uncovering the many advantages of virtual appliances
and start using them to si
The Measurements works now after the fix.
> Ok, thanks :-)
>
> Robert
>
> Am Donnerstag, den 30.09.2010, 11:32 +0530 schrieb Ap.Muthu:
>> It is called on the admitted patient right menu - under Measurements
>> menu.
>> Put in a fix for correcting it to the way it is now. Check the revision
>> l
34 matches
Mail list logo