Tuesday, August 26, 2008

Embed a hyperlink into data view web part XSLT

URL: 

http://[server]/[site]/Lists/Open%20Positions/AllItems.aspx?View={84EEA2F5-121B-40B7-946F-0FA704A1DAA1}&FilterField1=Recruiter&FilterValue1=Hold

Convert it into:
http://www.blogger.com/Lists/Open%20Positions/AllItems.aspx?View=%7b84EEA2F5-121B-40B7-946F-%200FA704A1DAA1%7d&FilterField1=Recruiter&FilterValue1=Hold

I have manually transformed the first argument from: 

{84EEA2F5-121B-40B7-946F-0FA704A1DAA1}

to: 

%7b84EEA2F5-121B-40B7-946F-0FA704A1DAA1%7d 

(In this, the open brace transforms to %7b and the closing brace transforms to %7d)

Friday, August 22, 2008

The server could not complete your request. Contact your Internet service provider or Web server administrator to make sure that the server........

soap:ServerServer was unable to process request. ---> A Web Part or Web 
Form Control on this Web Part Page cannot be displayed or imported because 
it is not registered as safe on this site. You may not be able to open this 
page in an HTML editor that is compatible with Microsoft Windows SharePoint 
Services, such as Microsoft Office SharePoint Designer. To fix this page, 
contact the site administrator to have the Web Part or Web Form Control 

configured as safe.

Solution:

1. Open the site, for example http://mossportal/site/default.aspx
2. add "?contents=1" to the end of url, like this: http://mossportal/site/default.aspx?contents=1
3. You have a Web Part Page Maintenance and if you have some web part error delete it
4. Open the page with SharePoint Designer and all work correctly

Change Contents Types Display Form

SPD refuses to update the supporting files for a content type unless it is the first in the 'create new' list.

Solution:

1. Change content type to first in New list

2. Assign custom form

Do that with all content types you want

Sunday, August 10, 2008

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, ... failed (CLR Procedure)

Solution:

1) ALTER DATABASE [Database Name] SET TRUSTWORTHY ON

2) Change the Permission Set of the CLR Code to External (Visual Studio's Project Properties)
 a) Properties > Database > Permissions Level
 b) Set to external