Hi, i'm looking for some good articles about webservices. (if possible for dotnet c#) More particular : - Security - How to maintain / support several client versions. - how to handle large projects. (e.g. multiple services ? how do they work togheter ?) All information is welcome. Thx, Kurt

CI = Continious Integration. Well we reviewed some tools but it would be nice if we had some feedback from users who are actually using them. thx, K

Hi, I like to gather some coding guideline tools for C. More specific for integration into a CI system showing us some statistics of the code quality. Can anyone post some suggestions, eventually with feedback or experience about the tool? regards. T.

Hi, does anyone here uses xstudio for ALM ? I wonder about the maintenaince for large projects. regards, Kurt

Hi, I'm stuck getting info from all files in een directory using the filesystemobject. Can someone help me out ? here's my code so far :

/* DECLARATIONS */
DECLARE @fileobj INT , @fsobj INT
DECLARE @folderobj INT
DECLARE @exists INT, @error INT
DECLARE @Property varchar(255)
DECLARE @src VARCHAR(255), @desc VARCHAR(255)

/* SECURITY SETTINGS */
EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE
EXEC master.dbo.sp_configure 'Ole Automation Procedures', 1
RECONFIGURE

/* CREATE FILESYSTEM OBJECT */
EXEC @error = sp_OACreate 'Scripting.FileSystemObject', @fsobj OUT
EXEC sp_OAGetErrorInfo @fsobj, @src OUT, @desc OUT
SELECT CONVERT(varbinary(4),@error), Source=@src, Description=@desc

/* RETURNS NOTHING */
-- EXEC sp_OAGetProperty @folderobj, 'Name', @Property OUT
-- print @Property

/* GET FOLDER OBJECT */
EXEC sp_OAMethod @fsobj, 'GetFolder', @folderobj OUT,'C:\'
EXEC sp_OAGetErrorInfo @folderobj, @src OUT, @desc OUT
SELECT CONVERT(varbinary(4),@error), Source=@src, Description=@desc

/* RETURN NOTHING */
--EXEC sp_OAGetProperty @folderobj, 'Name', @Property OUT
--print @Property

/* CREATE A TEMP TABLE */
IF OBJECT_ID('tempdb..#dirlist') IS NOT NULL
DROP TABLE #DirList
CREATE TABLE #dirlist (FName VARCHAR(1000))

/* FILL TEMP TABLE WITH FILES COLLECTION */
INSERT INTO #dirlist (FName)
EXEC sp_OAGetProperty @folderobj , 'Files', @fileobj OUTPUT
EXEC sp_OAGetErrorInfo @fileobj, @src OUT, @desc OUT
SELECT error=CONVERT(varbinary(4),@error), Source=@src, Description=@desc

/* SHOW FILES */
select * from #dirlist

Question is how can i fill my temp table? (it's still empty) Thx, Kurt

Hi Put return at the end of you're stored procedure declare @counter int select @counter = count(*) from mytable return @counter or set rowcount as output parameter and print it. or set nocount off greetz

ok thx. I will try it. thx

Okay, thx.. just what i was looking for.... greetz Kurt

Hi, Can i use comports in a windows service ? if yes, how does i know the portnumber when no user has logged onto windows ? for me as user the comport is 6 and 7 instead of 1 and 2. can i build a service than, using comport 6 and start the service with local system account ? thx for you're help. Kurt

Hi, Does anyone know if i can change SQL server settings using a script or query? I should set "minimum memory used" to 512MB and "SQL boost" to true using a script. thx kurt

thx for the response, but i'm not quite sure. if i deliver you person 2 and 3 can you give me the group the present ? i gues i need a select where group is the same for person 2 and 3 and where group is not used by other persons or so.. hmm this might work... Problem is that i get a bunch of persons and update common data as group, i'll need to check if the group exists if not i'll add the common data else i'll update the common data of those persons. so i didn't think about a cross table.. good thinking... thx just thinking now that i need to insert multiple keys in de many-to-many table when adding one record for a group, but that should not be a problem.

hi, I have a table with persons having a integer as a unique key. now i've made a second table groups defined by the persons in it. the combination of the uniek keys of the persons should be my unique key in the groups table. for example 1. person a 2. person b 3. person c first group is 1,2 second group is 1,3 third group is 2,3 fourth group is 1,2,3 Does anyone has any idea how i can store this data easely as unique key and still find the related data in an easy way ? Data delivered to search a group are the combinations of the persons. greetz and thx Kurt

Hi, Stored proc or JS are details. The big question is do we save time and money to reach the same result or do we spend again a lot of money and time to learn a new product? What improvements are in it for you and you're customers ? [little story] I'd remember Borland (once) didn't sell a lot of new versions because the current products had already everything available to produce what you wanted. Microsoft instead needed new releases to keep up. i asure you i develop an application with Delphi 5 in a shorter time than VS2005 still having the same functionality and even better performance running on all MS os's Win95/win98/win2000/Xp/vista. VS will only run on Xp and with a little of luck the layout stays the same in vista. [/little story] So can you do you're job with VS2003 or VS2005 still providing what customers ask? Think how much money you'll lose or win (license, courses, learning curve) just trying to keep up every new (better?) version available. :-) i suppose it differs for everyone. greetz kurt

Voila :-) Firefox and firebug are the best, ms tries to copy but i rather stick with the real thing. ;-)

Hi, I thought i was the only one feeling like that... I programmed in Delphi, had control about my code. Had some ownbuild reusable components and source code. Develop time was much shorter then now programming C# to get the same result. It was a pleasure to write software. Now with all the new techniques with never ending story, i'm thinking about quiting my job as software engineer en start something completely different. On the other side... yes i programmed also Basic :-) , T-SQL and ASP/HTML. So, what's the difference.. There's much to learn those days and it's more difficult to choose a direction that suits you. Too bad you can't do and know everything just like we did in the old days. greetz kurt PS : You're going the right way if you stop from time to time and think by yourself... where am i, what am i doing, is this what i want and where will i go to ?

Or you can write a program in you're language. for example C# or build a query like this..

EXEC master.dbo.sp\_configure 'show advanced options',1		RECONFIGURE
EXEC master.dbo.sp\_configure 'xp\_cmdshell', 1		RECONFIGURE

declare @query varchar(500)
set @query = 'BCP "SELECT \* FROM YourTable" queryout "C:\\YourTable.txt" -c -T -C850 -S(local)\\SQLEXPRESS -Usa -Psa'

EXEC master..xp\_cmdshell @query

EXEC master.dbo.sp\_configure 'xp\_cmdshell', 0
RECONFIGURE		EXEC master.dbo.sp\_configure 'show advanced options', 0
RECONFIGURE

Be sure you're sql server has rights to write on the HD. (set local system account of you're SQL service) greetz Kurt

you always get binary data when running a select. It depends on the client how to process it, mostly it becomes a array of bytes. You can show it by storing it to file or convert it to strings to show it in a memo or listbox. You probably used the sql studio manager for viewing data, this is not showing you binary data. greetz kurt

If you want to pass them using the database, check out storing binary data in a table. SQl 2005 support large data as binary, i suppose SQL 2000 has the image (or text but is limited) field for this. Otherwise you'll can store the IP Addresses of each client and send it using the windows socket. Another way to do it is using a FTP server and store and retrieve them bij using FTP connections. It's called FILE Transfer Protocol for some reason :-) the choice is your's... greetz Kurt

OK thx. if i can get the result of XP_CmdShell, i can manage it. greetz Kurt

Hi, i want to retrieve creationDate and time from a file on the server HD by using a query. anyone any idea how i can do this? thx Kurt