Android Contacts – Show Contact Names

Posted on By David Kittell 
SELECT
data1 AS FullName, data4 AS Prefix, data2 AS FirstName,data5 AS MiddleName, data3 AS Lastname, data6 AS Suffix
FROM data
INNER JOIN mimetypes ON mimetype_id = mimetypes._id

WHERE mimetype LIKE "%name%"
	AND length(data1) > 0

and data2 <> ""
and data3 <> ""
ORDER BY Lastname
Originally Posted on March 2, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Android SQLite Code SQL SQLite

Related Posts

Create SQLite Database With Auto Increment

Posted on

Sub CreateTable(SQL As SQL, TableName As String, FieldsAndTypes As Map, PrimaryKey As String, Auto As Boolean) Dim sb As StringBuilder sb.Initialize sb.Append("(") For i = 0 To FieldsAndTypes.Size – 1 Dim field, ftype As String field = FieldsAndTypes.GetKeyAt(i) ftype = FieldsAndTypes.GetValueAt(i) If i > 0 Then sb.Append(", ") sb.Append("[").Append(field).Append("] ").Append(ftype)…

Read More

PowerShell – Get Network Statistics

Posted on

function Get-NetworkStatistics { [OutputType(‘System.Management.Automation.PSObject’)] [CmdletBinding(DefaultParameterSetName=’name’)] param( [Parameter(Position=0,ValueFromPipeline=$true,ParameterSetName=’port’)] [System.String]$Port=’*’, [Parameter(Position=0,ValueFromPipeline=$true,ParameterSetName=’name’)] [System.String]$ProcessName=’*’, [Parameter(Position=0,ValueFromPipeline=$true,ParameterSetName=’address’)] [System.String]$Address=’*’, [Parameter()] [ValidateSet(‘*’,’tcp’,’udp’)] [System.String]$Protocol=’*’, [Parameter()] [ValidateSet(‘*’,’Closed’,’CloseWait’,’Closing’,’DeleteTcb’,’Established’,’FinWait1′,’FinWait2′,’LastAck’,’Listen’,’SynReceived’,’SynSent’,’TimeWait’,’Unknown’)] [System.String]$State=’*’ ) begin { $properties = ‘Protocol’,’LocalAddress’,’LocalPort’ $properties += ‘RemoteAddress’,’RemotePort’,’State’,’ProcessName’,’PID’ } process { netstat -ano | Select-String -Pattern ‘\s+(TCP|UDP)’ | ForEach-Object { $item = $_.line.split(‘ ‘,[System.StringSplitOptions]::RemoveEmptyEntries) if($item[1] -notmatch ‘^\[::’) { if (($la =…

Read More

PowerShell – Install Azure Modules

Posted on

In order to work in PowerShell with Azure you need to have the modules setup properly, the script below will help get you ready to go then test it. # Azure PowerShell Get-Module PowerShellGet -list | Select-Object Name,Version,Path # Install the Azure Resource Manager modules from the PowerShell Gallery Install-Module…

Read More