Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mike Helland wins the beaty contest :)
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00343673
Message ID:
00344295
Views:
29
Larry,

>>So, I may hope? :) BTW, have you already been the Member of the day? I don't remember...
>>
>>So, the probability may be calcualted as: (right?) in each particular day for each such person:
>>prob=1/337+1/336, if all these people had access in the last 20 days in each day.
>>
>It looks like Mark gave you the answer you were looking for. Also, I haven't been a MOTD. I think it checks the experience field as well. It says you have to have at least 100 characters in the field and I haven't filled it in yet.

I can not agree with his formula.
Ok, this is how I would deal with this situation:

ldDate=Date()
select * from UtMembers where abs(dateLastAccess-ldDate)<=20 and len(description)>100 and HasPicture into cursor curPotentialMembers
lnNumber=_tally
select *, recno() as Num from curPotentialMembers into cursor curNumbered

gnLower = 1
gnUpper = lnNumber

lnFirst= INT((gnUpper - gnLower + 1) * RAND( ) + gnLower)
lnSecond=INT((gnUpper - gnLower + 1) * RAND( ) + gnLower)
* Hopefully, they are not equal :)

select * from curNumbered where num=lnFirst or num=lnSecond

Is it right? And what would be probability, if, say, there are 200 members, which met the criteria?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform