View Complete Post
Hi I am trying to use the Lookup transformation to lookup values from a SQL CE database. The problem is that the OleDB data source doesnt have a SQL CE provider. Is there any place to download the SQL CE provider for OLEDB or any alternative way to query
data from SQL CE database.
Any help would be highly appreciated. Thanks,
I have a secondary data connection with a lookup field into another list. To display the fields text value instead of the index, I am using a drop down list which gets its choices from the linked list. This information is read-only so I disabled the control
via formatting rule.
A calculated value control might be better suited, but my XPath skills are not very "developed". Has anyone done this before? Taken the index from the bound field and extracted the text value from a second data connection? Thx
When you begin to work with the MicrosoftÃÂ® . NET Framework 2. 0 and ASP. NET, you discover that the new Web Parts infrastructure adds some very powerful functionality to the underlying platform. In the September 2005 issue of MSDNÃÂ®Magazine, Fritz Onion and I have an article on programming Web Parts titled "ASP.
MSDN Magazine February 2006
Edited by Nancy Michell
MSDN Magazine December 2003
we are doing our cms migration. both cms's have their own articleID/contentID, we have a lookup table that contain the article URL and its content id. Now we want to query that table on every single click to get its respective id.
How and where i can implement this?
I have a spreadsheet that I want to link to Sharepoint as a list. I want to use Sharepoint to make updates to the spreadsheet as well as for lookups in other lists.
My problem is that the spreadsheet already has a data connection to a SQL database. The spreadsheet doesn't update the DB directly but the DB connection is used to keep the spreadsheet updated with new data edited directly in the DB. I don't
own the DB or the spreadsheet so cannot convince them to do their editing another way (directly from the info in the spreadsheet for example) so ...I HAVE to keep the existing connection to the DB.
My question is...is it possible to keep the connection to the DB AND link to Sharepoint?
OR..is there another solution?
I have a document library that contains a Category column that is a lookup field. This is a default column that is a required field when uploading documents to the document library. The Category column is empty and I am unable to amend, hide, make it not
required or delete it.
I have gone to Modify settings and columns -> clicked on the Category field to edit, but there is no option to amend the content or delete it. I am only able to amend the Column name and Description.
Since then, I have amended the column name to eg. Category1 and created a new Category field as a lookup and linked it to the correct list.
The problem I am facing now, is that I cannot hide, delete or make the Category1 (old Category) field NOT required. Either I would like to update the original field to display the correct values or alternately hide, delete or make the column not required.
I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form
located on a WSS2.0 site.
The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.
I am not aware of any other users experiencing this issue.
Any ideas please?
When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.
I found this hotfix, but it did not apply.
Any ideas how to get this resolved?