PlItems

ID: 218
PlCodelang: MySQL
PlGroup: Datenmengen
PlItemTitle: Anzahl Zeilen Resultset begrenzen
Code: SELECT * FROM tableA LIMIT 100;

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: 3
PlCodelang: VB.NET
PlGroup: GUI, MDI-Fenster
PlItemTitle: Aktives MDIChild und dessen Elemente
Code: If Me.ActiveMdiChild IsNot Nothing Then Dim frm As SubForm = CType(Me.ActiveMdiChild, SubForm) frm.textBox1.Text = "......." End If ' Beispiel: If Me.ActiveMdiChild IsNot Nothing Then If Me.ActiveMdiChild.Name="frmHotel" Then Dim frm As frmHotel = CType(Me.ActiveMdiChild, frmHotel) MessageBox.Show(frm.hotelid) End If End If

ID: 4
PlCodelang: VB.NET
PlGroup: GUI, MDI-Fenster
PlItemTitle: Alle MDIChilds durchlaufen
Code: Dim oForm As Form For Each oForm In Me.MdiChildren If Not TypeName(oForm) = "MDIForm" Then If oForm.Name = "frmHotel" Then ' Es gibt mind. 1 geöffnetes Browser-Fenster ' ... End If End If Next

ID: 5
PlCodelang: VB.NET
PlGroup: GUI, MDI-Fenster
PlItemTitle: Auf ein Object eines MDIChilds zugreifen
Code: Dim oForm As Form For Each oForm In Me.MdiChildren If Not TypeName(oForm) = "MDIForm" Then If oForm.Name = "frmHotel" Then MessageBox.Show(oForm.GetType.ToString + "|" + CType(oForm, frmHotel).hotelid.ToString) End If End If Next

ID: 22
PlCodelang: VB.NET
PlGroup: GUI, Tabelle
PlItemTitle: Tabellenselektion
Code: ' DataGridView ' Man bekommt den Index der Column und der Row Dim counter As Integer For counter = 0 To (DataGridView1.SelectedCells.Count - 1) MessageBox.Show(DataGridView1.SelectedCells(counter).ColumnIndex.ToString & vbCr & DataGridView1.SelectedCells(counter).RowIndex.ToString) Next

ID: 23
PlCodelang: VB.NET
PlGroup: GUI, Datenbank
PlItemTitle: ComboBox mit Datenbank
Code: ' Die Datenbank-Tabelle enthält die Felder titel und id Dim dt As Data.DataTable = myDataTable ' Die DataTable wurde bereits gefüllt aus der Datenbank... comboBox1.DataSource = dt comboBox1.DisplayMember = "titel" ' Der angezeigte Wert für den Benutzer comboBox1.ValueMember = "id" ' Der Wert, den der Benutzer auswählt (id) Dim ausgewaehlteIdAusComboBox As String ausgewaehlteIdAusComboBox=comboBox1.SelectedValue.ToString ' enthält die ausgewählte id

ID: 61
PlCodelang: VB.NET
PlGroup: Schleifen
PlItemTitle: For-Schleife
Code: For i As Integer = 0 To 10 Debug.WriteLine(i) ' 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 Next For i As Integer = 10 To 5 Step -1 Debug.WriteLine(i) ' 10, 9, 8, 7, 6, 5 Next

ID: 62
PlCodelang: VB.NET
PlGroup: Array
PlItemTitle: Array definieren
Code: Dim myStrArray(3) As String myStrArray(0)="First" myStrArray(1)="Second" myStrArray(2)="Third" myStrArray(3)="Fourth" ReDim strJahreszeiten(4) myStrArray(4)="Fifth" Dim my2DimStrArray(1,2) As String my2DimStrArray(0,0) = "This" my2DimStrArray(0,1) = "is" my2DimStrArray(0,2) = "a" my2DimStrArray(1,0) = "2" my2DimStrArray(1,1) = "dimensional" my2DimStrArray(1,2) = "matrix"

ID: 68
PlCodelang: VB.NET
PlGroup: GUI, Komponenten allgemein
PlItemTitle: Dezimal/Währungseingabe in zwei Textboxen
Code: Sub TextBox1KeyUp(sender As Object, e As KeyEventArgs) If ((e.KeyCode = Keys.Oemcomma) OR (e.KeyCode = Keys.Decimal)) Then CType(Sender,TextBox).Text = CType(Sender,TextBox).Text.Trim(",") CType(Sender,TextBox).SelectionStart = CType(Sender,TextBox).Text.Length For i As Integer = 0 To Me.Controls.Count-1 If Me.Controls.Item(i).TabIndex = CType(Sender,TextBox).TabIndex+1 Then CType(Me.Controls.Item(i),TextBox).Focus End If Next End If End Sub

ID: 133
PlCodelang: VB.NET
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: Dim longStr = "This is a long string" Dim searchFor = "long" position = InStr( longStr, searchFor )

ID: 2
PlCodelang: PHP
PlGroup: HTTP Form Submit
PlItemTitle: GET Link-Parameter lesen
Code: $getparam = $_GET['linkparameter'];

ID: 9
PlCodelang: PHP
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: $jetzt = time(); echo "jetzt: ".$jetzt; echo "<br>"; echo "Human readable: ".date("H:i:s", $jetzt); echo "<br>"; echo "zurück in Sekunden: ".strtotime(date("H:i:s", $jetzt)); echo "<br>";