test

http://a499.phobos.apple.com/us/r1000/026/Music6/v4/ee/1c/8e/ee1c8eea-cbfc-2984-db5e-5c4f2cf7c8c0/mzaf_3865492851037958779.plus.aac.p.m4a

Encrypted Field

The steps to encrypt a field is easy, full details are here

CREATE MASTER KEY ENCRYPTION BY

PASSWORD = 'your password here'

GO

CREATE CERTIFICATE EncryptTestCert

    WITH SUBJECT = 'name'

GO

CREATE SYMMETRIC KEY cryptoKey

    WITH ALGORITHM = TRIPLE_DES

    ENCRYPTION BY CERTIFICATE EncryptTestCert

GO

To get encrypted content

OPEN SYMMETRIC KEY cryptoKey

DECRYPTION BY CERTIFICATE EncryptTestCert

ENCRYPTBYKEY(KEY_GUID('cryptoKey'),@input) 

To get decrypted content

OPEN SYMMETRIC KEY cryptoKey

DECRYPTION BY CERTIFICATE EncryptTestCert

CONVERT(nvarchar(Max), DecryptByKey(fieldName))

WCF postback size limitation

The maximum size is about 1MB. You need to modify web.config for this.

  <system.serviceModel>

    <serviceHostingEnvironment aspNetCompatibilityEnabled="true"/>

    <standardEndpoints>

      <webHttpEndpoint>

        

       

        <standardEndpoint name="" helpEnabled="true" automaticFormatSelectionEnabled="true" maxBufferSize="2147483647" maxBufferPoolSize="2147483647" maxReceivedMessageSize="2147483647">

          <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647" maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647" />

        </standardEndpoint>

      </webHttpEndpoint>

    </standardEndpoints>

  </system.serviceModel>

Good controls

sortable plugin

uploader

jquery ui theme


app creator

app creator 2

phone gap
api

Good dragable control + color theme

dragable Control

seems that jquery color theme is good

integrating ASIHTTP

key note

issues

-xml lib file is missing

Good photo viewer

similar to native photo app viewer