Monday, September 20, 2010

Sharepoint : "Value does not fall within the expected range"

This definitely happens when some field is missing. Compare your code and the list of fields that all the fields exist and if exist then they have same name. Make sure about the spelling checks.

Sharepoint : Multiline Text Field Size Limit

Error : " This field can have no more than 255 characters"

Go to form Library Settings. Open the properties of the desired field. set "Yes" to "Allow unlimited length in document libraries" settings

Javascript : Finding the Specific Form Field in the Form

for (i = 0; i < document.forms[0].elements.length; i++) {
if (document.forms[0].elements[i].name == 'src_Field1_general') {
document.forms[0].elements["src_Field1_general"].value = '<%=Request.QueryString("src")%>';
}
if (document.forms[0].elements[i].name == 'src_Field2_packs') {
document.forms[0].elements["src_Field2_packs"].value = '<%=Request.QueryString("src")%>';
}
}

SQL Server: Get the Location of Full Text

Right click - > Script -> Create To

Infopath : File upload size limit

Admin tools -> Central Admin -> Application Management -> Under Info-path forms services go to configure info-path forms services à Change the Form Session State to have a maximum size of 25000 KB.

SQL Server : Get the list of Databases with Size

EXEC sp_databases

Infopath: Steps Modify the Infopath form

1. Download the copy of the specific form to the desktop.
2. Delete the form from the Production Form Library.
3. Deactivate the feature from the Site Collection
4. Delete the form from Production central admin -> Manage Infopath form
5. Publish the form back again to Production form library
6. Upload the form to production from Central Admin -> Upload a new form template