Assuming example is required, the following 175 results were found.
-
a SHA1 along with the project name: something similar to: 5B:3D:C4:92:CA:D5:12:89:45:1D:E2:64:CF:C8:21:F8:04:38:F2:3E;com.example.myapp. By default this is the SHA1 of your computer but add it anyway to the Google APIs console for testing purposes. To...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
replacing the new lines but just stopping the return key or trying to catch it is an obsolete method. How? The following example replaces the return key with a "GO" key: The XML The Java EditText location = (EditText)findViewById(R.id.editTextLoc);...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
The ImageView exists in another XML with an identifier called @+id/hangar_aircraft_photo. The following is a full example of what can be added to a Main Activity Java file and will display an AlertDialog with the 3 options to "take a photo", "choose...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
index/key field so I can check if this is a valid data row (the blank ones may return special chars rather than Null). My example here is that the first column is our employee number and the second column will be the remaining data on that row. So I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
doesn't have a matching label. Which can be a major part of your charts if this is a normal part of your database. In my example, the team members could have changed and that a person doing most of the jobs suddenly left or moved to another team. To...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
dataset and not for a particular drill-down item. It will alternate between the two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
002 192 2010 12 Report 003 305 2010 479 Report 001 202 2011 84 Report 002 202 2011 45 Report 003 287 2011 94 A working example using the ReportServer database in SSRS 2008 R2: SELECT Catalog.Name AS ReportName, DATEPART(dayofyear,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
0 if not alpha numeric. SELECT @ParameterToCheck REGEXP '^[A-Za-z0-9]+$' AS AlphaNumeric FROM... Usage -- Using the ORACLE example SELECT Column1, Column2, (LENGTH( TRIM( TRANSLATE( :ParameterToCheck,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
"Fill" expression of the textbox with the field name changed for each cell you apply this to; note that in the following example, "Data_Retrieval" is the field to compare (of all "Data_Retrieval" values) and "Report1" is the name of my dataset: =IIF(...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
usability, we put a message just below the header which was an expression detailing what the report was displaying, so for example: -- If setting the limit to 100 records =IIf( Sum(Fields!myCount.Value, "DataSet2")>100, "» Displaying the first " &...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
path which is usually %windir%\System32\cmd.exe Add arguments in format /c start "Task Name" "Full Path of Program", for example: /c start "VisualStudio2010" "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" for Start In..., I leave...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Ordinal 0186 « Left angle quote 0171 » Right angle quote 0187 Additional "Alt Codes" can also be used in HTML. For example the British Pound sign (£) can be typed by holding the ALT key and entering 0163. In HTML, the numeric entity that will display a...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
your database server. Expand Security > Logins. Right-click on the user who will be set as having read-only access (in this example "adventureworksro"). Select Properties. Select User Mapping. Map the login to the database they will have access to. Tick...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
to copy and paste into your SQL administration software. You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
-- Employee Number concatenated with a 2 digit sequence -- number (padded with zeros) How? So how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query: SELECT RIGHT('000' + CAST(e.ID AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the above example, the dates are wrong for subsequent days off sick: SELECT EmployeeNo , DaysOffSick , DateOfSickness ,'1' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
AS XML).value('(/STAFF/GENDER="MALE")[1]','VARCHAR(10)')='TRUE' AS Gender -- Returns records where GENDER = "Male" More Examples (Note that Event_XML is of datatype XML in the following examples): -- exist() returns 1 or 0 if node exists or not...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB