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 "scope"="People" AND JobTitle="Something" ORDER BY Department, OfficeNumber Some peop...
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 list box with values, I need to somehow select all the distinct values of that property. Is ...
Hi, i am starting with SSIS now. I have a package created to run SQL script, to export it in flat file and send it with e-mail as attachment. "Send mail Task” is giving me an error as “SMTP server is not specified. Provide a valid name or IP address”. But in connection manager I explicitly put the server name in form aaaaa.mydomain.ca. L...
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 clarification is appreciated. ...
I've search for answers for this and I can't seem to find an answer to what should be somewhat simple. This is related to another question I asked, but it's different. What's the best way to take a user's search phrase and throw it into a CONTAINSTABLE(table, column, @phrase, topN ) phrase? Say, for example the user inputs: Books by "D...
If I am doing a search in sharepoint, some of the results I'm expecting are not being returned. I believe its because in active directory these entries may not have all the fields. So a name that doesn't have the givenName attribute set in active directory is not being returned from this query. Is there a way I can get this to work li...
Hello, My question is I have a table with the set of records. I am calling a stored procedure for some other purpose. But when ever it finds some duplicate records. It need to return as error message back to php. C1 C2 c3 abc 32 21.03.2010 def 35 ...
Hi, Suppose I have data in table X: id assign team ---------------------- 1 hunkim A 1 ygg A 2 hun B 2 gw B 2 david B 3 haha A I want to know how many assigns for each id. I can get using: select id, count(distinct assign) from X group by id orde...
I'm querying MS SQL using python using the source code from http://www.ironpython.info/index.php/Accessing_SQL_Server: import clr clr.AddReference('System.Data') from System.Data import * TheConnection = SqlClient.SqlConnection ("server=yourserver;database=News;uid=sa;password=password;timeout=0") TheConnection.Open() MyAction = SqlCl...
Hi all, 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 from another site and entered my database information, but I still get errors: ...
everything was working fine while the database of my asp.net mvc 2 site was in the app_data folder , after i transfered it to sqlserver express all the Cyrillic data i added after that appears in ????? :( I'm using nvarchar for my fields and collation is set to Cyrillic and yet .. ????? any suggestions are appreciated edit :// [H...
Hi, I have a table with One-To-Many reflexive association. I need insert the first value disabling temporary the constraint. Any idea how to do it? I use MS SQL 2008, thanks guys for your support! CREATE TABLE dbo.CmsCategories ( CategoryId int NOT NULL IDENTITY (0,1) -- Seed = 0 and Increment= 1 ...
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 is working properly except for the store component, I am getting the following error "The ...