Thursday, May 31, 2007

SQL dialects reference - Wikibooks, collection of open-content textbooks

Raha mitady aide momba ny SQL ianao, dia ity no mba atoroko anao kely. Ahitanao ireo references rehetra ilaina izy ireo ary ahitanao ihany koa fampitahana. Tsara raha jerenao mihitsy raha mety.  

Link to SQL dialects reference - Wikibooks, collection of open-content textbooks

http://aam.ugpl.de/?q=en/sql_help/functions

http://sqlzoo.net/howto/source/z.dir/tip106453/postgres

Tuesday, May 29, 2007

CLIN INFO WIKI

 

Portail des clinical informatics

[edit]

The Clinical Informatics Wiki -- Clinfowiki

The Clinical Informatics Wiki is an implementation of a wiki devoted to topics in clinical informatics. To begin a new article, or edit an existing article, you must first create an account and login to the ClinfoWiki.

Please see documentation on customizing the interface and the User's Guide for usage and configuration help.

You can test your edits as much as you want in the Sandbox.

We are currently working on 331 articles, and we need your help to complete this study of Clinical Informatics. See Special:Statistics for more complete information on the site.

[edit]

Electronic Medical Record (EMR) Systems

Link to Main Page - Clinfowiki

Wednesday, May 23, 2007

GOOD formating in VBNET

String.Format("{0}", "formatting string"};

One of the painful things about good old ASP was string formatting, VBScript simply didn't have anything useful. C# (and VB.Net) do, but MSDN doesn't provide a quick reference to the formatting options. So here's a quick reference.

To compare string formatting in C# to those in C lets have an example,

char szOutput[256];
sprintf(szOutput, "At loop position %d.\n", i);

sprintf takes an output buffer, a format string and any number of arguments to substitute into the format string.

The C# equivalent for sprintf is String.Format, which takes a format string and the arguments. It returns a string, and because you're not passing in a buffer there's no chance of a buffer overflow.

string outputString = String.Format("At loop position {0}.\n", i);

So why doesn't have the format argument have parameters specifying what data type you're formatting? The CLR objects have metadata which informs the CLR what the objects are, and each object has a standard ToString() method which returns a string representation of that object. Much nicer than C where if you passed the wrong type of variable into sprintf everything could come crashing down.

The ToString method can accept a string parameter which tells the object how to format itself. In the call to String.Format , the formatting string is passed after the position, for example, "{0:##}". The text inside the curly braces is {argumentIndex[,alignment][:formatString]}. If alignment is positive, the text is right-padding to fill the specified field length, if it's negative, it's left-padded.

formatting strings

There's not much formatting that can be applied to a string. Only the padding / alignment formatting options can be applied. These options are also available to every argument, regardless of type.

example
output

String.Format("--{0,10}--", "test");
--      test--

String.Format("--{0,-10}--", "test");
--test      --

formatting numbers

....

Tuesday, May 15, 2007

Classification CIM10 version light

Voici une page web de classification CIM10 faite par HCUGE suisse

Il est léger et facile à utiliser

CIM10
_ (A00-B99) Certaines maladies infectieuses et parasitaires 1
_ (C00-D48) Tumeurs 2
_ (D50-D89) Mal. du sang et des org. hématopoïét. et certains troub. syst. immun. 3
_ (E00-E90) Maladies endocriniennes, nutritionnelles et métaboliques 4
_ (F00-F99) Troubles mentaux et du comportement 5
_ (G00-G99) Maladies du système nerveux 6
_ (H00-H59) Maladies de l'oeil et de ses annexes 7
_ (H60-H95) Maladies de l'oreille et de l'apophyse mastoïde 8
_ (I00-I99) Maladies de l'appareil circulatoire 9
_ (J00-J99) Maladies de l'appareil respiratoire 10
_ (K00-K93) Maladies de l'appareil digestif 11
_ (L00-L99) Maladies de la peau et du tissu cellulaire sous-cutané 12
_ (M00-M99) Maladies du système ostéo-articulaire, des muscles et du tissu conj 13
_ (N00-N99) Maladies de l'appareil génito-urinaire 14
_ (O00-O99) Grossesse, accouchement et puerpéralité 15
_ (P00-P96) Certaines affections dont l'origine se situe dans la période périna 16
_ (Q00-Q99) Malformations congénitales et anomalies chromosomiques 17
_ (R00-R99) Symptomes, signes et résultats anormaux examens cliniques et labo 18
_ (S00-T98) Lésions trauma, empoisonnements certaines conséquences causes externes 19
_ Codes "U" selon CIM-10 vol2 page 18 22
_ (V01-Y98) Causes externes de morbidité et de mortalité 20
_ (Z00-Z99) Facteurs influant état santé et motifs recours aux services santé 21

 

Link to http://raft.hcuge.ch/nomed/cim10/index.html

Wednesday, May 09, 2007

10 Tips That Every PHP Newbie Should Knowasses and more.

http://www.phpbuilder.com/columns/vaska20050722.php3

10 Tips That Every PHP Newbie Should Know

Jeffery Vaska

I wish I had known these 10 tips the day I started working with PHP. Instead of learning them through painstaking process, I could have been on my way to becoming a PHP programmer even sooner! This article is presented in two parts and is intended for folks who are new to PHP.

Tip 1: MySQL Connection Class

The majority of web applications I've worked with over the past year have used some variation of this connection class:

class DB {
function DB() {
$this->host = "localhost"; // your host
$this->db = "myDatabase"; // your database
$this->user = "root"; // your username
$this->pass = "mysql"; // your password

$this->link = mysql_connect($this->host, $this->user,
$this->pass);
mysql_select_db($this->db);
}
}

.......

lire l'original ici

http://www.phpbuilder.com/columns/vaska20050722.php3