PlItems

ID: 222
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: NULL Wert eines Feldes übersteuern
Code: SELECT IFNULL(MyColumn1, 1) AS MyColumnWithoutNULL;

ID: 230
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: SELECT extract(year from now()) AS Year; SELECT extract(year from '2014-01-01') AS Year; -- 2014

ID: 231
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Monat aus Datum extrahieren
Code: SELECT extract(month from now()) AS Month; SELECT extract(month from '2014-07-01') AS Month; -- 7

ID: 232
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Datum/Uhrzeit zusammensetzen
Code: SELECT MAKETIME(19,53,20) AS TIME; -- 19:53:20 SELECT MAKEDATE(2014,120) AS DATE; -- ^^^ -- Day of Year -- 2014-04-30

ID: 233
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Datum/Uhrzeit berechnen
Code: SELECT DATE_ADD(now(),INTERVAL -45 DAY) AS calculated_Day; -- ^^^ -- Type -- -- Available Types: -- MICROSECOND -- SECOND -- MINUTE -- HOUR -- DAY -- WEEK -- MONTH -- QUARTER -- YEAR -- SECOND_MICROSECOND -- MINUTE_MICROSECOND -- MINUTE_SECOND -- HOUR_MICROSECOND -- HOUR_SECOND -- HOUR_MINUTE -- DAY_MICROSECOND -- DAY_SECOND -- DAY_MINUTE -- DAY_HOUR -- YEAR_MONTH

ID: 235
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Aktuellen Datenbanknamen ausgeben
Code: SELECT DATABASE() AS DB_Name;

ID: 236
PlCodelang: MySQL
PlGroup: Strings
PlItemTitle: String nach Delimenter zerlegen
Code: -- Not a real solution, but a workaround if you have rights to create a function -- see: http://blog.fedecarg.com/2009/02/22/mysql-split-string-function/ -- same problem with MSSQL. CREATE FUNCTION SPLIT_STR( StringToBeSplitted VARCHAR(255), delimiter VARCHAR(12), position INT ) RETURNS VARCHAR(255) RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(StringToBeSplitted, delimiter, position), LENGTH(SUBSTRING_INDEX(StringToBeSplitted, delimiter, position -1)) + 1), delimiter, ''); SELECT SPLIT_STR(string, delimiter, position);

ID: 237
PlCodelang: MySQL
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: SELECT myString ,locate('#',myString,5) AS findPosition -- Result is: 8 ,left(myString,locate('#',myString,2)-1) AS ExtractedString -- Result is: abc ,left(myString,locate('#',myString,5)) AS ExtractedString -- Result is: abc#def# FROM ( SELECT 'abc#def#ghj' AS myString ) dummyString

ID: 7
PlCodelang: Mumps
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: ; The first integer is the number of days since December 31, 1840, where day 1 is January 1, 1841. The second integer is the number of seconds since midnight of the current day Set h=$horolog S h=$H W !,h ; gibt aus 61793,34937 was dem Datum 2010-03-08 und der Uhrzeit 09:42:17 entspricht

ID: 11
PlCodelang: Mumps
PlGroup: Datenbank
PlItemTitle: Lesen Datensatzes
Code: ; In M werden Tabellen Globals genannt S id=1 W !,^TABLE(id) S street="Hollywood Drive" S city="Los Angeles" W !,^PERSONS(street,city) S temp=^GLOBAL(0,"test","temp1")

ID: 14
PlCodelang: Mumps
PlGroup: Array
PlItemTitle: Array definieren
Code: S arr("dim1","dim2")="value" Set arr("dim1",99)=187 ; Persistent, will be saved with prefix ^: S ^save("dim1","dim2")="saved value"

ID: 16
PlCodelang: Mumps
PlGroup: Variablen
PlItemTitle: Existenz der Varible abfragen
Code: Set status=$Data(test) If status Write !,"Variable existiert: "_test I '$D(test2) W !,"Variable existiert nicht!"

ID: 21
PlCodelang: Mumps
PlGroup: Variablen
PlItemTitle: Var-Dump einer Variable
Code: ZW test S A(1,2)="Inhalt" ZWrite A Set ^GLOBAL1("sub1","sub2")="content" ZW ^GLOBAL1

ID: 33
PlCodelang: Mumps
PlGroup: Strings
PlItemTitle: String nach Delimenter zerlegen
Code: myString="A;B;C;D;E" Write !,$Piece(myString,";",3) // gibt C aus

ID: 40
PlCodelang: Mumps
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: Set fullstring="This is my string" Set searchfor="my" If $Find(fullstring, searchfor) Do . Write !,"I found it!!" . Quit

ID: 127
PlCodelang: Mumps
PlGroup: Konsolenverwaltung
PlItemTitle: Einlesen Konsoleneingabe
Code: WRITE !,"What's your name? " READ yourname

ID: 165
PlCodelang: Mumps
PlGroup: Variablen
PlItemTitle: Auflistung aller Variablen
Code: S A="This is a test" Set b=1 ZW ZWrite

ID: 8
PlCodelang: Caché
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: ; Datum und Uhrzeit formatiert ausgeben Set datuhr=$ZDateTime($Horolog,8) ; ergibt 20100308 09:47:36 ; nur Datum Set dat=$ZDate($Horolog,3) ; = 2010-03-08 ; nur Zeit Set uhr=$ZTime($Piece($H,",",2)) ; = 09:50:20

ID: 12
PlCodelang: Caché
PlGroup: Datenbank
PlItemTitle: Lesen Datensatzes
Code: ; Es existiert eine Tabelle namens Table.Cities welche einen Eintrag mit der ID=15 enthält. Diese Tabelle enthält das Feld "Name" Set ds=##class(Table.Cities).%OpenId(15) Write !,ds.Name ; Oder über SQL Set result = ##class(%Library.ResultSet).%New() Set sql = "SELECT Name FROM Table.Cities WHERE ID=15" Do result.Prepare(sql) Do result.Execute("") For { Quit:'result.Next() Set name=result.Data("Name") }

ID: 17
PlCodelang: Caché
PlGroup: HTTP Form Submit
PlItemTitle: GET Link-Parameter lesen
Code: ; http://localhost:1972/csp/test/page.csp?name=john Set linkparm=$Get(%request.Data("name",1)) Write !,linkparm ; = john