kleinmannetje
|
Posted: 08/16/2004, 2:41 AM |
|
Hello there,
I have a problem with a grid I have on a page. First I shall explain the background a little. I have an article table in my database where users can save their articles. There is also a field in this table which contains the user_id of who over inserted the article. The users are in another table named users.
The grid showing the article also shows the name of the person how insterted it in the database. This name is found by using an inner join.
I want to show the username on the grid with the article. That works fine but for example when the user is deleted from the database the grid doesn't show the record of the article anymore. This is of course because he can't find the username in the user table because the user doesn't excist anymore. But I do want the users still be able to view the article, even if the user how placed it doesn'excist anymore. How can I do this?
I tried to set the value of the label to unknown in the before show event but that doesn't work. Any suggestions?
|
|
|
Damian
|
Posted: 08/16/2004, 4:34 AM |
|
Instead of deleting the user why dont you change their password, OR change
their access level to one that gives them NO access, or add another field
active/inactive... That way you dont lose your history either. Just because
Kurt Cobain is dead we havent forgotten who wrote Come As You Are!
"kleinmannetje" <kleinmannetje@forum.codecharge> wrote in message
news:54120812d8cbb9@news.codecharge.com...
> Hello there,
>
> I have a problem with a grid I have on a page. First I shall explain the
> background a little. I have an article table in my database where users
can
> save their articles. There is also a field in this table which contains
the
> user_id of who over inserted the article. The users are in another table
named
> users.
>
> The grid showing the article also shows the name of the person how
insterted it
> in the database. This name is found by using an inner join.
>
> I want to show the username on the grid with the article. That works fine
but
> for example when the user is deleted from the database the grid doesn't
show
> the record of the article anymore. This is of course because he can't find
the
> username in the user table because the user doesn't excist anymore. But I
do
> want the users still be able to view the article, even if the user how
placed
> it doesn'excist anymore. How can I do this?
>
> I tried to set the value of the label to unknown in the before show event
but
> that doesn't work. Any suggestions?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|