.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Troubleshooting an XSL Select to another List in a Dataview.

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
I've done this before to join in some column from another List into a dataview.    I've looked over the two list and  this line of code for a few hours now. It's producing no output, when I know there are matches. <TD class="{$IDASV40H}">    <xsl:value-of select="/dsQueryResponse/Applicant/Rows/Row[@ID = current()/@ApplicantID]/@AName"/></TD> None of the colums or lists have been renamed. None of the columns have spaces in the names. I want to make sure I'm reading this right.  do I need to define current()? Any bood way to troubleshoot this in Designer? any issue with trying to compare @ID? Thanks.

View Complete Post

More Related Resource Links

Use BDC data in list as multi-select column

I have a document library that uses values from another system for its metadata.  Right now, we copy the values from the primary system into SharePoint so users can choose them.  I want to find a way to use the BDC connection that I have set up to automatically pull those values.  The problem is that the current metadata is set to multi-select.  So, I have a file that is in the library and it can be used for multiple clients - clients is a column in my library and users can select many entries.  When I set up a column to pull BDC data, it only allows single entry.  Does anyone have any ideas?

How to tie a dropdown list from a nother table to a dataview in sharepoint designer



i created a dataview for a user table to insert new records. now i have to use a dropdown list that get data from another table. to insert in my user table. in the user table only the code is stored. but i need to get that code description that is in another table in my dropdownlist to choose from in my dataview.

how can i do this in sharepiont designer2007?

Insert a "Select User" row in Linq for a dropdown list

I'm new to Linq. I have searched and searched the web for a soluion, and can't find anything. I have a Linq query and I want to insert a row ("Select User") to the top before I pass it to the drop down list. I've been trying to use the Union but to now avail (it keeps telling me that my object doesn't support the Union method). My code, prior to attempting to inser a row, is very simple.public SelectList DropDown_Users()        {            var context = new VivarianDataContext();            var query = from t in context.AspnetUsers                        select new { t.UserId, t.LastName };            list = new SelectList(query.AsEnumerable(), "UserId", "LastName");            return list;        }Now I try to insert a row and I found this on the internet and it seems to say that his solution will work. But it is filled with syntax errors. http://magicode.wordpress.com/2009/08/20/inserting-an-item-in-iqueryable-object-using-union-met

Can not select Forms Library for List Definition

Why can I not select a content type of Forms Library when creating a new List definition?  I want to create a form library list definition that I can link to a InfoPath form that I have created?

people picker problem, with multiple select lose the list.

<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p {mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:0cm; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> Hi guys I have a master table with configuration for reports. when I load a InfoPath form (2010) for new report I have a approvers that set ok  , and I have  Notifies (multiple people) when I load a value form master they left me in the field only the first value(people) and lose the others. Do you know if there any way to load a multiple people value in people picker control?   Thank in advance Ramiro

XSL Lookup to another List in a View. Joining in data from another List. xsl:value-of select=

I've been able to create a DataView with data joined from two SP Lists. I did this using SPD, a linked Source, and doing joined subviews.  The technique works nicely, but I have to create my DataView from scratch.As an alternative, I took an existing AllItems View in SPD, converted it to XSL, and was able to add a column from another List as follows:   <TD Class="{$IDA1VDGH}" style="width: 62px; height: 23px"><xsl:value-of select="/dsQueryResponse/Master/Rows/Row/@Lastname" />The problem is, it reports the column for the first row everytime. I'm new to XSL and was wondering..    using XSL, and preserving all the original columns already in the View, is there anyway to make the added column smarter, maybe with a filter?I noticed in my working example, I have this filter (I guess where the subview join magic is)            [@Title = $dvt_ParentRow/@Key] which does not resolve syntax:I tried this, but it does not work, only finding one match, and it also seems to get set for the entire Dataview and not just the column.     [../../../Master/Rows/Row/@Title = @Key] I guess I'm looking either for the SPD steps, or XSL code for adding a single column from another list, joined in by a column in both lists.Thanks for any help or information.

Adding a column from another List to a Dataview? Must I link sources or can I just add a new data so

Using Designer, I added a dataview to a webpart page and dragged in a single list source. It works as expected. I now want a column from another list in my view. Must I link in another datasource, or can i just insert the data source for the second list into my datasources? The new datasource is there in the code and I see the caml select for it. but my XSL still does not find data: <xsl:value-of select="/dsQueryResponse/Master/Rows/Row[@ID = current()/@Key]/@Lastname" /> I noticed my new columns are not in the <datafields> tag, I tried adding them but it did not help. If Master is my lookup list , @Key is the dataview I will match with and @ID is the column in Master, and @Lastname column I want to return, is the above syntax correct? Many Thanks.    

Dropdown select message in item template gridview dropdwon list ???

Hi ....I have used gridview item template , which has two dropdown list .The first dropdown list is binded from database to the dropdown list I have using the below code , to show the select message in dropdown list before selecting any item from dropdown list.In first row its show me --Select-- message and my vaues.. if i select some value form dropdownlist and click add new button it will create a new row dynamic then in previous row again it come back --Select-- message... on going to second row....I need to remain first row user selected value on going to next row.The New row will show --select-- message..Please go to my code and let me know what to do<asp:DropDownList id="DropDonList2" tabIndex=11 runat="server"          OnSelectedIndexChanged="DropDonList2_SelectedIndexChanged" AutoPostBack="True"          DataTextField="SizeRange" DataValueField="SizeRange"          OnDataBound="DropDonList2_DataBound" __designer:wfdid="w10"          AppendDataBoundItems="True">  <asp:ListItem Value="-1">Select</asp:ListItem> </asp:DropDownList><asp:DropDownList id="DropDonList2" tabIndex=11 runat="server" 

Select more than one row from an attribute list

Xquery newby! I was looking at the answers to the post "How do I get my xml in table form?"  and have a further question.
Here is what I have.



table #xcap (id int, xml_col xml)

How To Remove Select in Jquery in List box

i crate a list box by database but select is show how to remove this using jquery

<td><select name="ListBox1" multiple="multiple" size="8" id="ListBox1">
		<option value="">Select</option>
		<option value="1001">1001.Ashok</option>
		<option value="1002">1002.Rajiv</option>
		<option value="1003">1003.Garima</option>
		<option value="1012">1012.Akhil</option>
		<option value="1011">1011.Nasir</option>
		<option value="1006">1006.Ashish</option>
		<option value="1004">1004.Tazeen</option>
		<option value=

Multi Select List and Filter Capabilities



I have a custom list created and one on the columns is a Choice list with the multi select option.  I need to be able to filter by the data based on one selection from that choice list.  For example, this choice coloumn is for a list of job role.  I need users to be able to select their role so to filter to what they need to see in other coloumns in that same custome list.  I have tried adding the sharepoint filter above my list however, that column is not an option to select on due to the multi select option. Is there an easy way to filter on that column.

How to get a default value from dropdown list that contains vaules from a SQL Select statement


I want to have a default value/item of "---Select One---" and then list all of the values from the SQL statement. Currently I am having trouble doing this. I tried to add it to the List Item but it doesn't show on the page. Can anyone help with this. 

ORDER BY items must appear in the select list if SELECT DISTINCT is specified


Hi, i am using a query to get DISTINCT hotels from my Database table sorted by Price and it returns me same hotel times of record found by Price if i use this Query

SELECT distinct(hotelname), availstatus, hoteladdress, hotelphonenumber, hotelpostalcode, destination, starrating, imageurl, hotelcode, TempSession, HotelType, MinimumNightRate from HproTemp where TempSession = '12-53-37' ORDER BY MinimumNightRate

and i get the error "ORDER BY items must appear in the select list if SELECT DISTINCT is specified" When i remove MinimumNightRate from SELECT LIST.

Can anyone have any idea how may i resolve it..

ORDER BY items must appear in the select list if SELECT DISTINCT is specified


why am i getting the error message when both ORDER BY items appear in the SELECT query?



	CONVERT(VARCHAR(8),BI.DateFrom ,3) as FFromDate,
	CONVERT(VARCHAR(8),B.CreatedDate ,3) as FBookingDate,
	CAST(FLOOR( CAST( B.CreatedDate AS FLOAT ) ) AS DATETIME) as BookingDate,
	(C.Forename + CASE 

how can I Select Data from DataView


How Can I Select Data from datView by Id. I want to Put the Id in a Taxtbox and It will Pick  Data from DatView and pute the Date In Invoice . I already taken All Produck Name in Dataview by Id.





SP 2007 (WSS 3.0) Export of WebPart DataView on list fails


We have created a DataView WebPart on a list in Sharepoint 2007 using SharePoint Designer with the Sharepoint List Toolbar (so we have the Actions button, including Export to Spreadsheet).  When we try to Export to a Spreadsheet (Excel 2003) it fails.  We've tried a couple of different scenarios, we get a different error for each.

If we just create the DataView onto a new aspx page then open the page in IE and try to export the data we get an error box that states and unexpected error has occurred and the data could not be saved.  No spreadsheet is created.

If we create a public view page in Sharepoint then open the resulting .aspx in Sharepoint Designer, remove the automagically created view and replace with a DataView Webpart, then save and reopen the page in IE, attempting the export results in a spreadsheet being created but only the ID numbers exported.  We then get a message box saying that some hidden or read only fields need data but do not have a default value.

As the original list is quite complex and has a variety of different data types we created a much simpler list on a separate subsite and repeated these scenarios, with exactly the same outcomes.

We are using Sharepoint 2007 (WSS 3.0) via Internet Explorer 6.0 on Windows XP SP2 to export the data into Excel 2003 SP3.  This has been replicated on three dif

Select List - Set the selected value


I am attempting to set the sletected value of a selectlist

ViewData["CompanyLocationID"] = new SelectList(
                , "CompanyLocationID"
                , "LocationName"
                , Convert.ToInt32(localCompanyLocationsContact.CompanyLocationID));

I have tried to set the value to an integer and to a string and just pass it in regular, but no matter what it never sets the selected value.  Is there something i am doing wrong?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend