Brian
|
| Posted: 09/04/2002, 6:41 AM |
|
i have in one form a parameter like Event_id=UserId ta allow each member
viewing his own events but I only have one events the first what is the problem
any support
thanks
|
|
|
 |
WilliamB
|
| Posted: 09/04/2002, 11:18 AM |
|
Seems to be that UserID should be matched to the field in the events table that correponds to the users_id. Assuming that event_id is the primary key for the events, then it unlikely that event_id = userID. This condition will retrieve only the record whose id is the same as the id of the user. The condition should probably be something like user_id = userID where user_id is the field in the events table that holds the users id.
|
|
|
|
Brian
|
| Posted: 09/05/2002, 8:07 AM |
|
I understand what you saisd event_id=user_id in my table , events_id is the primary key why I only have the first event and not all
thanks
|
|
|
|
Andrew
|
| Posted: 09/05/2002, 8:44 AM |
|
I'm sure we can get to the bottom of it, but it would help if you could post the full SQL query that you are running (e.g. "SELECT * FROM tblEvents WHERE EventID = {UserID} ?).
Are you just joining two tables, or are there others involved? Can you try testing the SQL in the builder _without_ the Event_ID=UserID parameter to check that the basic query returns more than one record in the first place?
|
|
|
|
Brian
|
| Posted: 09/05/2002, 9:09 AM |
|
Williams
everything is matching nice wothout UserId i don't know what is matter
|
|
|
|
