Knowledge Base - .NET, C#, SQL Server 2005, PHP and Actionscript 2.0 / 3.0 etc

http://www.ajaxload.info/

http://asp.net/ajax/documentation/live/overview/updatepaneloverview.aspx

The Firefox plugin JavaScipt plugin by Venkman; yet another tool to learn - this was useful:

http://svendtofte.com/code/learning_venkman/venkmanwindows.php

http://msdn.microsoft.com/en-us/library/ms186724.aspx

Its really easy to do - best to do all of this on the database - that’s what it is for!

This finds stuff that is from 6 months ago until today:

WHERE yourDate BETWEEN DATEADD(MONTH, -6, CURRENT_TIMESTAMP) AND CURRENT_TIMESTAMP

Interesting thing Thom brought up today. Two way communication from with the browser in flash - control flash from javascript.

This seemed to give the answers:

http://www.moock.org/webdesign/flash/fscommand/index.html

JavaScript can send commands to Flash by invoking built-in methods on embedded movie objects. Calling Flash methods works exactly like all calls to built-in methods on JavaScript objects (eg. document.write() or window.close()). From a developer point of view, this direction of communication is one sided–JavaScript methods control a Flash movie entirely in JavaScript, without requiring complementary code in the Flash movie.

There is a guide here from sipgate: https://secure.sipgate.co.uk/user/configreader.php?show_conf=nokia

You will need your username and password details. These can be found here: https://secure.sipgate.co.uk/user/settings.php#overview

In the case above the public username will be SIPID12345@sipgate.co.uk

Dead easy to do:

Add the profiles to the web.config

<?xml version=”1.0″?>
<configuration>
<system.web>
<caching>
<outputCacheSettings>
<outputCacheProfiles>
<add name=”StaticPageCacheProfile” duration=”14400″ />
<add name=”UserControlCacheProfile” duration=”60″ />
</outputCacheProfiles>
</outputCacheSettings>
</caching>
</system.web>
</configuration>

Then just add that to the page declaration:

<%@ OutputCache CacheProfile=”StaticPageCacheProfile” VaryByParam=”none” %>

It would also be a good idea to separate out the cache profiles to a separate config file and then use MSBuild to pull the correct ones in at deploy time. I hate forgetting to change the profile when you are working on the site on DEV and it doesn’t change or a designer comes over telling you nothing has changed!

MySQL databases:

mysam locks at table level - rubbish and has a performance hit.

Change to innoDB for row level locking! This should be the default!

ALTER TABLE table_name ENGINE = INNODB;

http://www.codeproject.com/KB/database/BackupUtility.aspx

Yes yes as expected I know. If you are passing name value pairs such as jibble=bibblebobble and yo uwant multiple values such as jibble=bibblebobble&amp;flibble=nibblenobbol you don;t want the first value to have an ‘&’ in it so use the JavaScript function escape().

Simple I know but an easy one to miss! Hooray for testers!