An "SQL" Syntax for the Microsoft SharePoint Server.
Questions tagged [mssqlft]
10 questions
4
votes
1 answer
How to get distinct values of a managed property through SharePoint search?
I am building a phone catalog of my organization (an AJAX application which accesses the search.asmx web service).
I'd like to show a list box where the user could select a department (which is stored in managed property Department). To fill the…
naivists
- 32,681
- 5
- 61
- 85
2
votes
2 answers
How to split repeating string delimated by commas in T-SQL
I have tried some trials and can't figure it out yet. Any help would be appreciated.
I have a table like below.
LocationID Project Name
1 A,A
1 A
1 A,B,C
1 A,C
1 B,C
1 …
Jonas T
- 2,989
- 4
- 32
- 43
2
votes
3 answers
PHP Can't Connect to MS SQL Express 2008
I'm struggling to connect to my MS SQL Express 2008 edition from my PHP files, but it seems virtually impossible.
I've found several guides/notes on teh intarweb solving the issues, but none of these have helped me any further.
I've taken a script…
kasperwf
- 277
- 2
- 4
- 16
1
vote
2 answers
sql server join query issue
I am using this query for pagination
SELECT *
FROM
(SELECT ROW_NUMBER() OVER (ORDER BY {0} {1}) AS RowNum, *
FROM Cars
WHERE IdOwner = {2}) AS Rows
WHERE RowNum > {3} AND RowNum < {4}
I want to make the pagination query on 2…
gigi
- 3,846
- 7
- 37
- 50
1
vote
1 answer
Items not included SharePoint search results if a property missing
I use an MSSQLFT query to poll Sharepoint's search through Search.asxm web service.
The query goes like this:
SELECT PreferredName, Department, AccountName, MobilePhone, WorkPhone
Title, JobTitle, OfficeNumber
FROM SCOPE()
WHERE
…
naivists
- 32,681
- 5
- 61
- 85
0
votes
1 answer
how to transform natural language into sql query? Imprecise fuzzy queries.SQLf
I`d like to implement a feature, that will allow user to type something like this:
"select * from products where low(price);"
what is equal to:
"select * from products where (price >=0) And (price <= 50);"
do you maybe know any solutions that…
Artur
- 323
- 2
- 5
- 13
0
votes
1 answer
ColdFusion error after hosting transfer
I recently moved a ColdFusion site from one domain to the other with no issue (practically) besides one which I am having some trouble figuring out. I am a LAMP developer / designer and CF is a bit foreign to me so pardon my ignorance.
The site…
jeffreynolte
- 3,749
- 11
- 41
- 64
0
votes
2 answers
Alter dynamically created table in ms sql
Suppose, I have a temp table #Temp1 with say two columns Name and Nationality as Varchar(50) datatypes and the table has some records. I create another temp table from this table(#temp1) as #Temp2. Now I wish to add another couple of column to that…
Jayaraj PS
- 195
- 1
- 4
- 18
0
votes
3 answers
Looking for a web server that include the following technologies ColdFusion, PHP, MS SQL Server, MySQL
Can anyone explain if it is possible to have a web server for all of these technologies:
ColdFusion, PHP, MS SQL Server, MySQL
I have a web developer insisting that they require all of the above however it doesn't quite make sense to me.
Any help or…
Kevin
- 3
- 1
- 3
-1
votes
1 answer
Maximize Microsoft Web and Database with 2 servers
I need a best technique to boost the performance and availability for the web and database server. My problem is I only can afford two 2 dedicated servers total.
I like to take a full advantage of the two servers by installing the NBL to help the…
NanoHead
- 159
- 3
- 15