Hi ! I'm a beginner at transact sql and I have a question. I have a table named person and a table named event. person has columns personID, personName event table has columns: eventID, eventName, date My situation is that I want to know which persons that will go to which event so i have a table called eventPerson eventPerson has columns: eventID, personID How do I construct a question in Transact SQL that returns a table over which persons that goes to wich event The result would look someting like this EventNo1 EventNo2 EventNo3 peter 1 0 1 lucy 1 0 1 john 0 1 1 So what I want is a matrix with boolean values. Columns is event. rows is person.

I get the following error when visiting my newly published site: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. the Source Error is the: authentication mode="Forms" line in the web.config file. I have IIS 6.0 I have been googling a lot on this topic but all the answers i can find tell me that this error is due to the fact that the site is not created as a virtual directory. But mine is. I also have only one web.config file. I relly don't know what to do. My OS is MS Windows Server 2003 (for small business server) Would be greatful for any help! /Robert -- modified at 7:28 Wednesday 3rd May, 2006

Hi. I built a client/server system that communicates with sockets. I used System.Net.Sockets.TcpClient and NetworkStream. I wonder if there is a simple way to encrypt the data so that it can not be viewed from outside. Would be greatful for any help /Robert

After installing an SSL server certificate (I did it myself with OpenSSL) my web service projects wont open. I get this message: The web server reported the following error when attempting to create or open the web project located at the following url: 'https://localhost/WR'. 'Issuer certificate is invalid' I have replaced http with https in the .sln file and the .webinfo file When I open the web service in an IE-browser I can see the web service after having gotten a security message. But in visual studio I am never asked if I trust the creator of the certificate. I just cannot open the project. I have Windows XP professional and IIS 5.1 and visual studio 2003 Have anybody had this problem? Would be thankful for any help /Robert

Yes, thanks. It's working now!

Hi. I'm a C# beginner and I am writing text to a file, but the reciever of the file wants it to be encoded in ISO/IEC 8859-1. I was earlier using System.IO.Streamwriter but I dont know how to do this with that class. Does anybody know hoe to do this in C#.Net Robert

I'm in need of some sql help SELECT P1.name, P2.name , J.text FROM person p1, person p2, job J WHERE P1.persID = J.creatorID AND P2.persID = J.responsibleID AND J.id = 1 the above statement does not return any rows if the job J has null in the responsible field. But I want it to return an empty string for P2.name in that case. Is that possible. Would be thankful for any help!

Thank you very much!

Hi. I'm new to asp.net and I wonder if I can get rid of the dropdownlist that my textboxes automatically creates containing strings from previous inputs. I use asp.net and c#

Thanks, but I do create my tables with CREATE TABLE (OleDbCommmand.ExecuteNonQuery) and the problem is that I afterwards have to go into access and alter the settings from there. Allowing null I have no problems with. /Robert

How to tell MS Access to allow zero lenght in the strings field using the CREATE TABLE command. Thanks in advance.

Thank you very much, now it works!

Solved it. the problem was that I posted the message to another window that created the dialog.

What do you mean by take care of. I can override OnInitDialog and get the value that the base class returns, but what should I do with it.

I want to join 5 tables and in that way get returned a schema of 10 columns that I can fetch with a recordset that I have made in C++ for this reason, but if one or more of the tables are empty (with this ID) the returned schema doesn't get 10 columns (or doesn't come at all depending on how you do it) and so I cant fetch it with my recordset. I want those column empty if the row is not there. I know I can declare variables like: select chvName = '' from Person but I dont know if it is empty when I do my sql-string without checking that first. Anybody that is good at Transact-SQL? Robert

I have a common C++ program and try to execute DoModal() on my dialog. When I do it from within the view it goes well but when i do it from another dialog that is a child to the view the dialog doesn't get focus even though i click in it. When I click on my program down in the program bar, the dialog gets focus. Anybody had this problem? Robert