1 Comment » by Jon Hibbins on 22 March 2009
Filed under: Code, Javascript, Quick Tips
If you want to check if a Javascript function exists before you attempt to call it and get an error try:
// Check if a Javascript function exists and run it if it does if(typeof window.Function == 'function') { Function(); }
1 Comment » by Jon Hibbins on 12 February 2009
Filed under: .NET, C#, Code, OSX, Platform, Quick Tips, Software Development, Unix/Linux, Windows
If you need to access SVN remotely, by default it runs on port TCP port 3690, so you need to make sure it is open in your firewall etc.
No Comments » by Jon Hibbins on 5 December 2008
Filed under: Code, Database, iPhone, MSSQL2005, MSSQL2008, Objective-C, Quick Tips, SQL Server, TSQL
Ever had the need to search stored procedures to find redundant tables or text that needs replacing or re-factoring ?
Here’s a script to help (Sorry for the cursor, I’m sad with myself for using it 
)
-- Search string DECLARE @SearchString nvarchar(50) SET @SearchString = 'Search String' -- Required Declares DECLARE @getdbname sysname DECLARE @sqlstm nvarchar(1000) DECLARE SeachCursor cursor FOR -- Get All The Names into the SeachCursor SELECT '['+name+']' FROM [master].[dbo].[sysdatabases] ORDER BY name OPEN SeachCursor -- Add the Search Pattern SET @SearchString = '%' + @SearchString + '%' --Get the first Name FETCH NEXT FROM SeachCursor INTO @getdbname WHILE @@FETCH_STATUS=0 BEGIN --set the statement to define the search condition, with variables SET @sqlstm = ' SELECT [SP].[Specific_Catalog] AS [Database_Name], [SP].[Routine_Name] AS [Stored Procedure Name],[SP].[Routine_Definition] AS [Routine_Definition] FROM '+ @getdbname+'.[Information_Schema].[Routines] AS [SP] WHERE PatIndex('+''''+@SearchString+''''+', [Routine_Definition]) > 0' --Execute the Query EXEC (@sqlstm) FETCH NEXT FROM SeachCursor INTO @getdbname END --Close the Cursor and Deallocate it from memory CLOSE SeachCursor DEALLOCATE SeachCursor
13 Comments » by Jon Hibbins on 27 August 2008
Filed under: iPhone, Objective-C, Quick Tips
After a number of compile to iPhone device issues, specifically: “entitlement ‘application-identifier’ has value not permitted by provisioning profile” and “Command /usr/bin/codesign failed with exit code 1″, I have worked out you can have one and only one developer provision and developer application on the iPhone at a time otherwise you get installation errors etc…
I also had to have the correct Bundle Identifier in the Info.plist file and make sure the ‘Code Signing Identity’ and ‘Code Signing Provisioning Profile’ was also correct.
Hopefully this is useful to someone, Good Luck!!!
No Comments » by Jon Hibbins on 22 August 2008
Filed under: Code, iPhone, Objective-C, Quick Tips, Software Development
If you are looking for the Objective-C Mod Command then look no further
To get the equivalent of a = b div c then :
a = b % c
3 Comments » by Jon Hibbins on 11 August 2008
Filed under: Quick Tips
Quick Tip: C# Current Application Version:
System.Deployment.Application.ApplicationDeployment.CurrentDeployment.CurrentVersion;