Programming Recipes

Android 5.0: how to change recent apps title color?

2016-02-13T14:31:00.002-08:00

I build android apps using Cordova and it is great. I wanted to change the Title color bar when you view you resent apps on android 5.

I spend quite some time trying to figure this out as I know little about the android development ways but always keen to learn so this is how I managed it:

Under your platforms > android > res folder add a new "values-v14" folder. Add a themes.xml file to the folder:

Now add your colors.xml under your values folder:

Now go to your AndroidManifest.xml file located under the platforms > android folder and change the android:theme attribute to android:theme="@style/MyAppTheme" :

Run the cordova CLI: $ cordova run Android

And awesome we have a custom colored title.

Visual Studio 2013 Crashing

2015-03-10T04:57:00.000-07:00

I am used to VS so I tried opening a project that I scaffold using yeoman. But to my surprise VS just crashes when I open the project as a website.

I had a feeling it has something to do with the node_modules folder, to test I deleted it and VS loaded the website for editing. The next thing was: how do I load the website project without that node_modules folder?

The only thing I could find that works is to set the “Hidden” attribute for the node_modules folder.

Open Windows Explorer.
Right click the node_modules folder which you want to exclude, and then select “Properties”.
Check the “Hidden” attribute.

You can now open the website in VS and it will not load the node_modules folder. Problem solved for now.

Typeahead with Angular

2013-11-19T04:41:00.001-08:00

I wanted to build a small mock up to test if I can use the Typeahead (ui.bootstrap.typeahead) in angular-ui 0.6.0.

But I am using Angularjs 1.2.0 and Bootstrap 3

Here is the resulting plunk: http://plnkr.co/edit/oVPIFRDEThwevsuACAMn?p=preview

I just created a build with just the Typeahead, and added the resulting tpls script to the plunk.

I also wanted to test if I can add my own embedded template for a combined view of the records. It turn out with the $templateCache it is easy,

All is working so its good!

Some IE9 Grief!

2012-10-25T06:09:00.000-07:00

Today I really hated IE9 even more!

I had this ajax:

$.ajax({

type: "GET",

url: "Reportviewer.aspx/GetSomeData",

contentType: "application/json; charset=utf-8",

data: "{}",

dataType: "json",

success: AjaxSucceeded

});

function AjaxSucceeded(result) {

console.log(result)

$(result.d).each(function () {

...

});

}

In IE9 the ajax just don’t want to call the success function “AjaxSucceeded” but in Crome, Firefox it returns just fine.

After googeling like crazy I found out all instances of console.log() need to be removed from your script in order for it to work in IE9 without it being in developer mode.

Well now I know!

Sum(First(…)) not allowed limitation in SSRS

2012-10-16T02:17:00.000-07:00

I have been struggling with an issue in SSRS for some time now and finally solved the issue:

The Issue

I have this data:

In the report I want the ROWS and COLUMNS to be dynamic, adding a matrix table to the report and setting the ROWGROUPS to the rows and ColumnName to the Columns and Value to the Details:

When running the report it displays correctly:

Now I want to add the AREA to show the ROWGROUPs fictional areas, I only want to show the AREA for each ROWGROUP and not the sum :

So not but

This displays correctly:

Now I want to add a Total at the bottom, the issue here is that ssrs sums the AREAs like such:

The Solution

One way of getting the correct total of the AREA column is to add 2 new columns to our sql query:

SELECT Test.*

,ROW_NUMBER() OVER (ORDER BY ROWGROUP) AS 'RowNumber'

,RANK() OVER (ORDER BY ROWGROUP) AS 'Rank'

FROM Test

and using an expression on the AreaTotal:

=Sum(IIf(Fields!Rank.Value = Fields!RowNumber.Value, Fields!AREA.Value, 0))

Producing the desired result:

Label ContentStringFormat

2012-03-30T00:01:00.000-07:00

Again this morning struggled with something I knew I had struggled with before this time I am in WPF XAML trying to set a StringFormat on my binding to get it formatted as a 2 decimal:

Running my view it is not showing me what I want to see; in this case showing 17.877651246, then I suddenly remembered that the Label control has its own way of dealing with StringFormat with the ContentStringFormat property:

<Label ContentStringFormat="N2" Content="{Binding SelectedObject.DoubleNumber}" />

The view is giving me 17.88 awesome!

I hope I remember this now actually makes a bit sense; I am setting the Content so setting the Content => StringFormat .. aah

Find and Replace using regular expressions

2012-03-29T02:14:00.000-07:00

Decided today to take my Find and Replace up one notch:

I got this code:

var parameters = new

{

labSoilAnalysis.ID,

labSoilAnalysis.Year,

labSoilAnalysis.Season,

labSoilAnalysis.RegionID,

labSoilAnalysis.FieldID

};

that I want to change to:

var parameters = new

{

ID = labSoilAnalysis.ID,

Year = labSoilAnalysis.Year,

Season = labSoilAnalysis.Season,

RegionID = labSoilAnalysis.RegionID,

FieldID = labSoilAnalysis.FieldID

};

Using regular expressions I ended up using:

The expression in the find box: {labSoilAnalysis}{.}{.+[^,]} is 3 tag expressions that is each assigned a number that I use in the Replace box, to reorder the code.

I know that it can be done in a beter way but me being a newbie to regex… maybe some of the big guns can help to make it beter, please post a comment with your take!

Behavior-Driven Development

2011-03-31T02:56:00.000-07:00

A great read in my quest on becoming a beter programmer: http://www.code-magazine.com/article.aspx?quickid=0805061&page=1

What is the difference between Left, Right, Outer and Inner Joins?

2011-03-30T03:23:00.000-07:00

A Visual Explanation of SQL Joins

I thought Ligaya Turmelle's post on SQL joins was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, like the commenters to her post, I found that the Venn diagrams didn't quite match the SQL join syntax reality in my testing.

I love the concept, though, so let's see if we can make it work. Assume we have the following two tables. Table A is on the left, and Table B is on the right. We'll populate them with four records each.

id name       id  name

-- ----       --  ----

1  Pirate     1   Rutabaga

2  Monkey     2   Pirate

3  Ninja      3   Darth Vader

4  Spaghetti  4   Ninja

Let's join these tables by the name field in a few different ways and see if we can get a conceptual match to those nifty Venn diagrams.

SELECT * FROM TableA INNER JOIN TableB ON TableA.name = TableB.name id name id name -- ---- -- ---- 1 Pirate 2 Pirate 3 Ninja 4 Ninja Inner join produces only the set of records that match in both Table A and Table B.
SELECT * FROM TableA FULL OUTER JOIN TableB ON TableA.name = TableB.name id name id name -- ---- -- ---- 1 Pirate 2 Pirate 2 Monkey null null 3 Ninja 4 Ninja 4 Spaghetti null null null null 1 Rutabaga null null 3 Darth Vader Full outer join produces the set of all records in Table A and Table B, with matching records from both sides where available. If there is no match, the missing side will contain null.
SELECT * FROM TableA LEFT OUTER JOIN TableB ON TableA.name = TableB.name id name id name -- ---- -- ---- 1 Pirate 2 Pirate 2 Monkey null null 3 Ninja 4 Ninja 4 Spaghetti null null Left outer join produces a complete set of records from Table A, with the matching records (where available) in Table B. If there is no match, the right side will contain null.
SELECT * FROM TableA LEFT OUTER JOIN TableB ON TableA.name = TableB.name WHERE TableB.id IS null id name id name -- ---- -- ---- 2 Monkey null null 4 Spaghetti null null To produce the set of records only in Table A, but not in Table B, we perform the same left outer join, thenexclude the records we don't want from the right side via a where clause.
SELECT * FROM TableA FULL OUTER JOIN TableB ON TableA.name = TableB.name WHERE TableA.id IS null OR TableB.id IS null id name id name -- ---- -- ---- 2 Monkey null null 4 Spaghetti null null null null 1 Rutabaga null null 3 Darth Vader To produce the set of records unique to Table A and Table B, we perform the same full outer join, thenexclude the records we don't want from both sides via a where clause.

There's also a cartesian product or cross join, which as far as I can tell, can't be expressed as a Venn diagram:

SELECT * FROM TableA

CROSS JOIN TableB

This joins "everything to everything", resulting in 4 x 4 = 16 rows, far more than we had in the original sets. If you do the math, you can see why this is a very dangerous join to run against large tables.

by Jeff Atwood: http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html

Another Explanation of SQL Joins

Simple Example: Lets say you have a Students table, and a Lockers table.

Each student can be assigned to a locker, so there is a "LockerNumber" column in the student table. More than one student could potentially be in a single locker, but especially at the begining of the school year, you may have some incoming students without lockers and some lockers that have no students assigned.

For the sake of this example, lets say you have 100 students, 70 of which have lockers. You have a total of 50 lockers, 40 of which have at least 1 student.

INNER JOIN is equivalent to "show me all students with lockers".
Any students without lockers, or any lockers without students are missing.
Returns 70 rows

LEFT OUTER JOIN would be "show me all students, with their corresponding locker if they have one".
This might be a general student list, or could be used to identify students with no locker.
Returns 100 rows

RIGHT OUTER JOIN would be "show me all lockers, and the students assigned to them if there are any".
This could be used to identify lockers that have no students assigned, or lockers that have too many students.
Returns 80 rows (list of 70 students in the 40 lockers, plus the 10 lockers with no student)

FULL OUTER JOIN would be silly and probably not much use.
Something like "show me all students and all lockers, and match them up where you can"
Returns 110 rows (all 100 students, including those without lockers. Plus the 10 lockers with no student)

CROSS JOIN is also fairly silly in this scenario.
It doesn't use the linked "lockernumber" field in the students table, so you basically end up with a big giant list of every possible student-to-locker pairing, whether or not it actually exists.
Returns 5000 rows (100 students x 50 lockers). Could be useful (with filtering) as a starting point to match up the new students with the empty lockers.

Setup Team Foundation Server 2010 with Sharepoint 2007 on Window Server 2008 SP2

2011-01-07T03:55:00.000-08:00

Wow what a task!

If you have Office SharePoint 2007 no SP you need to follow these steps:

http://www.christiano.ch/wordpress/2009/09/16/microsoft-office-sharepoint-server-2007-on-windows-server-2008-this-program-is-blocked-due-to-compatibility-issues/

Next install SQL Server, SharePoint etc... steps:

http://juliocasal.com/archive/2009/11/02/team-foundation-server-2010-beta-2-office-sharepoint-server-2007-single-server-installation-part-1.aspx

Next install Team Foundation Server 2010 steps:
http://juliocasal.com/archive/2009/11/02/team-foundation-server-2010-beta-2-office-sharepoint-server-2007-single-server-installation-part-2.aspx

5Hours later and I am ready to roll!

Notes: Struggle on SSO Service Account: http://thorprojects.com/blog/archive/2008/08/02/moss-single-sign-on-setup-step-by-step.aspx

When creating a new TFS project and setting the SharePoint site up the user must be added to the SharePoint permissions:

Using the TFS Setup account, navigate to http://myserver/sites/DefaultCollection
Click on Site Actions and select Site settings.
Under Users and Permissions, click the link Site collection administrators
Added my account in the domain/account format and clicked ok

Excel Services was unable to load the workbook that you requested:
Give NT AUTHORITY\NETWORK SERVICE (db owner) on the database named "WSS_Content"

To change the data type of a column without dropping the table (SQL Server 2008):

2011-01-04T03:06:00.000-08:00

SQL

ALTER TABLE [dbo].[tbl_001] ALTER COLUMN clm_001 nvarchar(50)

Update data in one table with data from another table

2011-01-04T03:01:00.000-08:00

Need to switch 2 columns that were wrongfully imported:

Step1
Create a copy of the table - CREATE TABLE [dbo].[Client2](....

Step2
Inserted the data to the copied table -
INSERT INTO [dbo].[Client2]

([UniqueClientID]

,[Latitude]

,[Longitude]

,[ClientName])

SELECT [UniqueClientID]

,[Latitude]

,[Longitude]

,[ClientName]

FROM [dbo].[Client]

Step3
Switch the 2 column data by updating
UPDATE [dbo].[Client]

set [Latitude] = [dbo].[Client2].[Longitude]

,[Longitude] = [dbo].[Client2].[Latitude]

From [dbo].[Client],[dbo].[Client2]

where [dbo].[Client].[UniqueClientID] = [dbo].[Client2].[UniqueClientID]