0
votes
1answer
36 views

How to grab a value from cache and pass it to an SQL Stored Procedure

I am designing a website that queries an SQL database when opened, providing a list of bills for the given user. I am using a custom SQL query with a Data Source/Data View and in the Command & ...
2
votes
2answers
51 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
27 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 ...
1
vote
1answer
246 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
863 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 ...