2
votes
1answer
17 views

How to choose the right datatype when creating external content types?

assuming I want to create a SPList using external content types, in my case SQL server tables. When I create my ECT in Sharepoint Designer 2010 SQL data types are mapped to the List as follows: ...
0
votes
0answers
24 views

Word template with parameters for query

We have a Word template which gets information from a database to fill in some fields (mail merge) but now I want to open this template from a page in sharepoint linked to a person. Now I was ...
0
votes
0answers
47 views

changing SQLDATASOURCE SelectCommand in codeblock on SharePoint 2007 page?

I need to pass current user (in domain\user format) to a SQLDATASOURCE on a sharePoint 2007 page. Options? Is something like this possible? Cant seem to get it to work. <script runat="server"> ...
1
vote
1answer
238 views

Bind 2 External Content Types (2 tables in SQL database) to 2 drop down lists and have 1 update the contents of the other?

I have 2 tables in my database called "Meetings" and "Items", items belong to a meeting. I've created the external content types with sharepoint designer and bound them to drop down lists ("Meetings" ...
0
votes
2answers
828 views

Live-sync MSSQL DB <--> Sharepoint List

My experience with SharePoint is not really sophisticated so please bear with me. What I want to do is setting up a live-sync between a SharePoint list and a database table. This live-sync should be ...