Getting all columns from SQL Table
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='TableName'
SPUtility.js
http://sputility.codeplex.com/ Installation To use the library, you can just upload SPUtility.js and prototype.js into a document library and put a Content Editor Web Part with some JavaScript code on whichever page you want to modify! Detailed instructions are on the Installation page. Usage Examples: Set a Text field's value SPUtility.GetSPField('Title').SetValue('Hello world!'); Set a Text field's value and make it read only SPUtility.GetSPField('Title').SetValue('Hello world!').MakeReadOnly(); Make a Choice field read only Before SPUtility.GetSPField('Status').MakeReadOnly(); After Set a People field and/or Make it Read Only SPUtility.GetSPField('Assigned To').SetValue('Menke, Kit'); SPUtility.GetSPField('Assigned To').MakeReadOnly(); Hide a field from view Before SPUtility.GetSPField('% Complete').Hide(); After
Comments
Post a Comment