Skip to content

Instantly share code, notes, and snippets.

@mamona
mamona / Web.AuthorizeIPAddress.config.xml
Created October 22, 2012 14:53
Web.config for AuthorizeIPAddress
<appsettings>
<!-- IP addresses allowed to view IP Address Restricted portions of the website. An asterisk indicates an entire subnet is valid. -->
<add value="::1, 127.0.0.1, 10.0.*.*, 79.88.44.33" key="AuthorizeIPAddresses" />
</appsettings>
@mamona
mamona / multiple_image.xml
Created October 11, 2012 18:59
Sample Image XML (multiple)
<images>
<image key="6e52b27c-c050-401a-97d6-ea9f3a94d876" type="0" />
<image key="6e52b27c-c050-401a-97d6-ea9f3a94d878" type="4" />
<image key="2ce5a23a-b288-44c3-be28-c7f2924be1b3" type="3" />
</images>
@mamona
mamona / single_image.xml
Created October 11, 2012 18:53
Sample Image XML (single)
<images>
<image key="6e52b27c-c050-401a-97d6-ea9f3a94d876" type="0" />
</images>
@mamona
mamona / vehicles.xml
Created September 17, 2012 15:03
Sample Vehicles XML
<?xml version="1.0" encoding="utf-8" ?>
<vehicles>
<cars year="2012" lang="en">
<model id="3">some value</model>
<model id="4">some value</model>
<model id="5">some value</model>
</cars>
<cars year="2012" lang="fr">
<model id="3">some value</model>
<model id="4">some value</model>
@mamona
mamona / replace_spaces.sql
Created May 24, 2011 13:15
SQL Replace multiple spaces with one
CREATE TABLE #ExtraSpaces ( MyVal VARCHAR(8000))
--Insert some value to test
INSERT INTO #ExtraSpaces
SELECT 'This is my message. '
UNION ALL
SELECT 'This message contains tabs and extra spaces'
-- Lets remove extra spaces and tabs
WHILE 1 = 1
BEGIN