Hi All I am having sqlserver 2008R2 database, and in the table, there is a column "Text" with some string value. Some of the strings are good (have the characters entered from keyboard" where some have values like "degree" symbol. example:

Row 1 has string "Today temperature is 45Degrees C" where as Row 2 has string "Today temperature is 40°C

Row 2 has a symbol which is not entered through the keyboard. I want to filter such kind of symbols while querying. Is there a way to query that way by filtering? If so, please provide me such query. Thanks in advance, Usha

Naina

Hi Try to validate using viewstate. When the page loads, increase the view count by comparing the viewstate object to null. Then take an object in viewstate. Second time when the user refreshes the page, viewstate object exists and skip the count increment. Please give a try and let me know how this worked. Thanks Naina

Naina

Hi i have a page which talks to webservice and gets data and is displayed in the page. The page has 2 input parameters (start date and end date). When difference between start date and end date value is increasing, the page is erroring (unable to display webpart). When i set the xsltTransformTimeout to 30, the page displays data. Can we have xsltTransformTimeOut value more than 5 in production server? If not , how can i resolve this issue? Thanks in advance Naina

Naina

Thanks a lot for the reply....

Naina

Hi I have migrated Moss 2007 to 2010. But problem here is there are few pages using sharepoint dlls like Microsoft.Shared.Webcontrols etc. I forgot to update the dlls from 12.0.0.0 to 14.0.0.0 Will there be any problem after moving to production. with 12.0.0.0 version , i have not faced any kind of issue. But just want to confirm on this. Thanks in advance Naina

Naina

Hi I have got it fixed. Below is the solution i found

In the above code, i have not given the attribute returnTypeDescriptorName and ReturnTypeDescriptorLevel. Giving the

Hi I have an adf file (BDC model)uploaded in central admin. And now i am trying to access an entity with business data item webpart and in the tool pane, selected the entity and when trying to provide value to item, i am getting error. When i checked in logs, i got the below error Child TypeDescriptor with Name 'Rows' and Id '27822' exists at a path containing a TypeDescriptor with Name 'DataSet' and Id '27819', representing a Collection, which creates an ambiguity for reflection. Please guide me on how i can proceed further. I am using webservice as datasource. Thanks Naina

Naina

Hi I have a sharepoint site in MOSS 2007 and after migration, the quicklaunch is giving problem. I have custom master pages. Where could it go wrong? Thanks, Naina

Naina

Thank you, but after migration, facing problem with the quicklaunch. It is giving error (not showing the menu). Opening a new thread for this issue. Thanks, Jyothsna

Naina

Hi Thanks for replying back.... i just did little bit of check over the master page. It was because of a piece of code that was commented. SPNavigation and breadcrumb related code. Thanks, Naina

Naina

Hi I have a custom master page and custom page layout. When i am trying to load the page, it gives javascrit error at onload getelementbyid(spwebpartmanager) giving error null reference. Where exactly am i going wrong? Anything to check in master page? I think because of this , there is one more error in the page. When clicking on webpart menu, giving javascript error there too. Thanks in advance Naina

Naina

Hi Kindly check this. This may help you. []Document Library Tree View Web Part for SharePoint[^] Regards Naina

Naina

Hi I have an web application developed on MOSS 2007, with custom web parts and reports etc. Now client wants to migrate to higher version Sharepoint 2010. I like to know the best way to migrate? Content database detach and attach method (or) use tools to migrate. Regards Naina

Naina

Finally i got a workaround to solve the issue. I used $Find("ModalPopupExtender1") inside the page in iframe but returned null. So i called a javacscript function located in the parent page from the child page. In the javascript function, i closed the modal pop up window. Thanks for your time and help. Regards Naina

Naina

Here, i am using the following code in the iframe aspx page

if(window.parent.document.getElementById("AlertNotesExt"))
{
var iframe = parent.document.getElementById("AlertNotesExt");

           iframe.hide();
    }
}

AlertNotesExt is the id of ajax modal pop up extender. But in that place, if i give any other asp.net cpntrol id like button etc., i am getting the id. Regards Naina

Naina

Hi, Sorry for my late reply. I am able to get all other control id's in the iframe, except the ajax controls. That's the main problem here. Regards Naina

Naina

Hi, Thanks for the reply. I can access if i am trying to access from same aspx page. Problem is when i am trying to access from a different aspx page , inside iframe. Regards Naina

Naina

Hi I have an a.aspx page and inside that page, i have ajax modal pop up extender. This will open an iframe which has b.aspx page. When i click on a button in b.aspx page , i should be able to hide the modal pop up extender in a.aspx page. I tried using the below code to access the modal pop up extender id from b.aspx using javascript but didnt work.

if(window.parent.document.getElementById("AlertNotesExt"))
{
var iframe = parent.document.getElementById("AlertNotesExt");

           iframe.hide();
    }
}

Thanks in advance Naina

Naina

Hi I assume you want to print the variable value when executing in sqlserver studio management. If so, you can print the variable value by

print variablename

regards Naina

Naina

Hi I have an employee table with column gender F and M. Now i want to update the gender values of all the employee as F with M and M with F. But this should happen in a single query. How can i do this. Thanks for your help. Regards Naina

Naina