any1 with experteese in these fields

/\|-||\/|/\|)

By definition the Left join gives two results. I have read something similar to the following in many references about the left join: "If there is no matching record for the right table in the ON or USING part in a LEFT JOIN, a row with all columns set to NULL is used for the right table." I want that this is y i chose the left join but the thing is that apparently the left join gave an extra record for all users having a profile picture with all columns set to null for the right table but i need this to happen ONLY wen there is no profile picture. This is the question how can I make this diffrenciation?? Ps: There is no multiple users Records nor there is multiple default = 1 per user Btw wen I add the default = 1 in the where clause i get strict result about only users with profile pictures and users without are neglected...

/\|-||\/|/\|)

I did integrate default into the join the problem is simple: If a user has more than one profile picture but only one is selected as default and if i do the join as u and i suggested ill get two results one witht the profile picture and another one without the profile picture. It is this second result that i wish to eliminate thanks anyway for your help :)

/\|-||\/|/\|)

I try this wat i get is trully all the results that i need except the users that has a profile picture ill get the result that is without a profile picture. So this way ill get all users without a profile picture eventhough they have one. But wat i need is to get the profile picture for the people who has one and get null for people who don't thx for ur suggestion though

/\|-||\/|/\|)

SELECT C.UserID FROM Contact AS C LEFT JOIN Album AS A ON A.UserID = C.UserID AND A.Type = 1 LEFT JOIN AlbumImage AS AI ON AI.AlbumID = A.AlbumID AND AI.'Default' = 1 Contact: UserID pk ... one to many Album: AlbumID pk UserID fk Type ... one to many AlbumImage: ImageID pk AlbumID fk Default a contact may have many albums one of which is for profile pictures and all the profile pictures can be selected from album image if a user did not upload a picture yet he will have an album for profile picture (of type=1) but without album images i want to select this user so i can give him throught the code later a default picture of my choice

/\|-||\/|/\|)

HI I am having problems with the join i need to do to get the required result. This is the problem: I have two tables one with user data and one with user profile image. I need to join these tables to get each user with his profile image (user might have many profile pictures but only one is set to be default=1). But some users might not have profile images uploaded yet. So the problem wen i do left join i get an entry with users having no profile images and also i get TWO entries for the same users that have a profile image : one with the right answer and one with an empty image. But i want my join to select empty image ONLY wen the user has no image uploaded. Any help??

/\|-||\/|/\|)

Jun Du wrote:

How did you represent a moving car on the screen in Java?

With frames do i have frames in c#? thx /\|-||\/|/\|)

stancrm wrote:

It also the same

I know it is very similar but the thing is there are functions in java that i used that are not present in c# also i am not an expert in c# so for example i don't know how to represent the car as a moving object on the screen... thx /\|-||\/|/\|)

Hi i was just wondoring if anyone knows how to create a trafic program with the 3 lights and cars going from left to right, right to left, up down and down up in c# i did it in java it is easy but how can we do it in c# thx /\|-||\/|/\|)

htv22 wrote: how can i insert a command for that icon so that it will be enabled and perform a specific function. just double click on it or enter the classWizards and select ur toolbarbutton(look for the id) and edit the code... /\|-||\/|/\|)

If i understand u correctly u want to add an icon for ur tree component. U can choose between the two function i worked on before. the first function is for getting the icon from ur computer(The one specified in the folder option FileTypes Tab) HICON CMyTreeCtrl::GetIcon(CString pathFileName) { // Call SHGetFileInfo to get the icon. Call with dummy filename and // SHGFI_USEFILEATTRIBUTES flag, so file doesn't actually have to // exist. SHFILEINFO shfi; memset(&shfi,0,sizeof(shfi)); SHGetFileInfo(pathFileName, FILE_ATTRIBUTE_NORMAL, &shfi, sizeof(shfi), SHGFI_ICON| SHGFI_USEFILEATTRIBUTES| SHGFI_SHELLICONSIZE | SHGFI_SMALLICON); return shfi.hIcon; } And the second one if u want to customizeur own images: First create the icons then Create an imagelist and do the following m_imageList.Create(16,16,0,3,2); m_imageList.SetBkColor(RGB(255,255,255)); HICON hIcon; hIcon = AfxGetApp()->LoadIcon(IDI_ICON2); //Folder eg m_imageList.Add(hIcon); hIcon = AfxGetApp()->LoadIcon(IDI_ICON3); //File eg m_imageList.Add(hIcon); m_T.SetImageList(&m_imageList,TVSIL_NORMAL); I hope this helps /\|-||\/|/\|)

thx /\|-||\/|/\|)

thx man /\|-||\/|/\|)

k thx man /\|-||\/|/\|)

Hi how can i look for a file if it exists without using fopen /\|-||\/|/\|)

Thx man It finally worked /\|-||\/|/\|)

No man still the same problem. I think by defult the MFC draws the small icon stored in the registry. Thx for trying though /\|-||\/|/\|)

Look Trollslayer, I should clear things once for all eventhough I know that we should not talk about this in here and I hope that this message is read by everyone who replyed to this thread. Some people started to have ideas about my belonging to this site or and I quote "you feel knowing the point, but you ask at the same time too many low level questions on the forum".(i prefer no to quote the whole sentence) I didn't want to reply to this but all I can say is that noone here (or anywhere else) is eligible to classify my question or anyone elses. I know that this reply came after my reply and I quote "WinExec("C:\\Toxxct\\dolt.exe",SW_ALWAYS);" said Halawlaw. The reason I wrote that is to reply to this message. Honestly, this word was insulting. Do you agree that anyone is allowed to give his opinion? All I wanted to do is to be part of this chain and help others as and i quote Trollslayer wrote: you should be ashamed after the help others have given you here and this is what I get. I don't care about my membership period (1 month and 1 day). You don't mesure someone with such irrelevant conclusions. I may be expert in c++ or zero in c++ as far as anyone is concerned. Remember the saying: "There is no dumb question, only dumb answers". This message is not necessarly to make things better between us(= the one who participated in this). Everyone should have his own conclusions and should act accordingly. In fact no matter what I say now, let us say "things will never be the same again". I don't expect that anyway. As a reply to u Trollslayer, yes I had help from many here at the Forum and i never underestimated this. If u go back to mainly all my messages you will find a gratefulness reply to the persons who helped me. In conclusion, I know I will always get the help I need here and I shall help others when I can. I hope there is no hard feeling or heart feeling. ciao /\|-||\/|/\|)

toxcct wrote: why removing such a code line, that was generate by the wizard ??? Coz if u dont it wont work da :mad: /\|-||\/|/\|)

WinExec("C:\\Toxxct\\dolt.exe",SW_ALWAYS); /\|-||\/|/\|)