SELECT CODE
FROM table
GROUP BY CODE
HAVING count(CODE) > 1
It helped me a lot, so I hope you, my reader can utilise it as well.
SELECT CODE
FROM table
GROUP BY CODE
HAVING count(CODE) > 1
Diario di bordo 01/07/2008 17:43:57
Should-dos:
·
·
<!-- ?xml-stylesheet type="text/xsl" href="CDA.xsl"? -->
<!-- Readers should be aware of the evolving "Using SNOMED CT in HL7 Version 3" implementation guide, currently in a draft state. The guide, co-developed by HL7 and the College of American Pathologists, will be balloted by HL7 as an Informative Document. Recommendations in the final published guide should usurp patterns of SNOMED CT usage found in this sample instance. -->
<clinicaldocument xmlns="urn:hl7-org:v3" voc="urn:hl7-org:v3/voc"
xsi="http://www.w3.org/2001/XMLSchema-instance"
schemalocation="urn:hl7-org:v3 CDA.xsd">
<!-- ******************************************************** CDA Header ******************************************************** -->
<typeid root="2.16.840.1.113883.1.3" extension="POCD_HD000040">
<templateid root="2.16.840.1.113883.3.27.1776">
<id extension="c266" root="2.16.840.1.113883.19.4">
<code code="11488-4" codesystem="2.16.840.1.113883.6.1" codesystemname="LOINC" displayname="Consultation note">
<title>Good Health Clinic Consultation Note</title>
<effectivetime value="20000407">
<confidentialitycode code="N" codesystem="2.16.840.1.113883.5.25">
<languagecode code="en-US">
<setid extension="BB35" root="2.16.840.1.113883.19.7">
<versionnumber value="2">
<recordtarget>
<patientrole>
<id extension="12345" root="2.16.840.1.113883.19.5">
<patient>
<name>
</name></patient></id></patientrole></recordtarget></versionnumber></setid></languagecode></confidentialitycode></effectivetime></code>
public DateTime? EffettiveTime
{
get { return m_effettiveTime; }
set { this.m_effettiveTime = value; }
}
someInstance.date = EffettiveTime.ToString("yyyy-mm-dd");
Nullable value types (denoted by a question mark, e.g. int? i = null;) which add null to the set of allowed values for any value type. This provides improved interaction with SQL databases, which can have nullable columns of types corresponding to C# primitive types: an SQL INTEGER NULL column type directly translates to the C# int?.
DateTime eTime = (DateTime) EffettiveTime;
someInstance.date = eTime.ToString("yyyy-mm-dd");
SomeClasse someInstance = null;
if(<someBoolean>)
{
someInstance= <doSomething>;
}
else
{
someInstance = <doSomethingElse>;
}
SomeClasse someInstance = <someBoolean> ? <doSomething> : <doSomethingElse>;
To install the C# Application plugin open a Command Prompt and Execute the following command. Make sure you get a "BUILD SUCCESSFUL" message at the end of the command output.
maven plugin:download -DgroupId=andromda -DartifactId=maven-andromdacsapp-plugin -Dversion=1.0-SNAPSHOT
Notice that you will now have maven-andromdacsapp-plugin-1.0-SNAPSHOT.jar installed at MAVEN_HOME\plugins ( C:\Program Files\Apache Software Foundation\Maven 1.0.2\plugins for this example).
After a long fight with maven, I found a solution to the problem.
Maven 1.x doesn't support redirection thus we must indicate a non redirected repository. So in build.properties :
maven.repo.remote=http://www.ibiblio.org/maven,http://team.andromda.org/maven
become
maven.repo.remote=http://repo1.maven.org/maven,http://team.andromda.org/maven
and a valid command line is :
maven plugin:download -DartifactId=maven-torque-plugin -DgroupId=torque -Dversion=3.3-RC1
if you try to use an other apache's server, it seems that jsch isn't created. [neria]
maven plugin:download -DgroupId=andromda -DartifactId=maven-andromdacsapp-plugin -Dversion=1.0-SNAPSHOT
Protected Overridable Sub CheckSecurity()
Member of: System.Uri
Summary:
Calling this method has no effect.
depot>rails depot
depot\config\ and correct it to match your database:
# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
development:
adapter: mysql
database: depot_development
user: userNam
password: pass
test:
adapter: mysql
database: depot_test
user: userNam
password: pass
production:
adapter: mysql
database: depot_production
user: userNam
password: pass
rake db:create:all
depot>ruby script/generate scaffold Product title:string description:text image_url:string
ruby script/server) and create a product. following this url:
http://localhost:3000/products