You can't put the default=1 in the WHERE clause. It has to be put in the JOIN clause as I listed in a previous post. The WHERE clause will eliminate non-matching rows (a null in the default column does not match 1). I have long since stopped qualifying my joins in the WHERE clause because of this type of issue. The sample query I listed before should get you your desired results if your tables are structured as you have stated. If you are getting duplicate results, there is something in your structure that I don't understand. I do LEFT JOINS all the time without the side effect you are getting. Can you post the actual query you are using?

If you create a new Windows Form, then use the event Paint. private void Form1_Paint(object sender, PaintEventArgs e) { ... } Then write your code in this method. For example : private void Form1_Paint(object sender, PaintEventArgs e) { e.Graphics.DrawLine(new Pen(Brushes.Black, 1), 0, 0, 50, 50); } That code will draw a black line with width = 1, from (0,0) to (50,50)

PathFileExists can help tooo :) "Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow cheers, Alok Gupta VC Forum Q&A :- I/ IV

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

ok i ll try that thx /\|-||\/|/\|)

Right Click on the List Control and check "sort" property V

You have to validate every modification in the control by processing all the EN_CHANGE messages on the CEdit. Marc Soleda. ... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.

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

u can use the CString function Format CString s; s.Format("%d",x); "Don't forget to rate the solutions, if they help you.

toxcct wrote: if you had asked this better from the beginning, you would certainly get the correct answer earlier... The same question was asked here. No one responded. "One must learn from the bite of the fire to leave it alone." - Native American Proverb

Hello In my opinion, a better way to do what you need is to use one of the random number generator routines in "NUMERICAL RECIPIES": http://www.library.cornell.edu/nr/cbookcpdf.html Scroll down to Ch. 7 in that page and you'll find a lot of algorithms that will be by far better you can come up using only your machine generator. You'll still need it, but the algorithms provide better "randomness" in your numbers and they are sorted by the way you need them to have certain statistical distributions. If you need them to have equal probabilities, then use the ran2 algorithm. This code is an implementation of it: seed = 0; srand (time(NULL)); rand(); seed = rand(); return ran2(seed); The return number is a uniform random deviate between 0 and 1. If you need integers just multiply your number as needed and take the integer. Cheers

vivekuniq wrote: Rookieee wrote: int i; CString str = "32"; sscanf(str, "%d", &i);ASSERT(i == 32); watz wrong with this ^? sorry but, this sample is mine, not Rookieee's... and of course is works ;P TOXCCT >>> GEII power [toxcct][VisualCalc]

__intN[^] are platform independent data types, they are synonims for the ANSI data types. Cheers, Marc Soleda ... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.

hi On button of Tab1 declare the extern global value set to specific value and on tab2 check that value if u get that allow it or else set the focus to tab1 cheers

Then check out my GoogleEarth trips[^]. :) (GoogleEarth not required). /ravi My new year's resolution: 2048 x 1536 Home | Music | Articles | Freeware | Trips ravib@ravib.com

I was looking in google just now and found this forum with a solution. It looks dangerous but worth to try. Wish me luck /\|-||\/|/\|)

Toni78 wrote: I am sorry for this vague description Don't worry man By the way with this "vague" description you have solved my problem. thx for taking the time to reply. /\|-||\/|/\|)

Do it Unix style using 1 way encryption or hashing. There are plenty of sites there that can offer detailed descriptions of how it works but basically it's like this. You take the password and hash it using something like MD5 or SHA-1, then you store that password in plaintext. Then when you want to authenticate your user in the program, you ask for the password, you take that password and hash it and then compare that hash with the stored hash, if they match, then it's probably the right password and you let them in. This should be pretty good, you can add "salting" or a random string to the password if you want to prevent precompiled dictionary attacks... Take a look at http://www.codeproject.com/cpp/csha1.asp [^]

I suspected that but you did not indicate it was a problem so I pursued other possibilities. Halawlaws wrote: ...sorry for wasting your time If the net result is that you learned something, how has time been wasted? "One must learn from the bite of the fire to leave it alone." - Native American Proverb