Forums

This topic is locked

Is it possible 2 update TWO DBs in the same time ?

Posted 24 Dec 2001 12:43:24
1
has voted
24 Dec 2001 12:43:24 LiToZ LiToZ posted:
i have a problem that i hope you can have a solution for it, i have two ASP scripts that requires the users to register, and i incuded both the tables in one database, everyone contains ( username, password, first name...etc ) and i want to configure them so that when the user register in one table, he automatically gets regitered in the second table! is that possible ? notice that for example the ALIKE columns doesnt have the same name in the two tables, for example the username table in one table is ( username1 ) and in the other table it is ( username2 )! is it possible to relate them so that when username1 is updated, username2 also becomes automatically updated and vice versa ??? please try to help me out because it is not likely to make users register MANY times in the same site! i want the registration to be UNIQUE so that when the user gets registered in any of the services he automatically gets registered in all the other services with the same info like the username and password....
thanks for your valuable time and i hope you can have a solution for me...

-----------------
AkMaLiTo-C RuLeZ
-----------------

Replies

Replied 25 Dec 2001 17:52:37
25 Dec 2001 17:52:37 Michael Moore replied:
Well.. I would like to help, but... I wonder why you are using two tables. You don't need to and you are running into the reasons why "it would be better if you didn't" already. Your life will be better if you plan ahead and normalize all your tables before you start and keep them normalized as you proceed. Done with lecture. Now... you can always and easily add, update whatever to multiple tables but you will have to hand code some. The main thing is to capture the data into variables and pass it to a page with the functionlity built into it. It doesn't have to be a displayed page, just a function page that does all that you want it to do and then redirects to whereever you want the user to go. As far as the coding on that page. Geesh... that is alot of coding and is so dependent on your fields and all that. It would be very time consuming to give all that here. I hope these concepts help you. Mike

Replied 25 Dec 2001 23:43:43
25 Dec 2001 23:43:43 Owen Eastwick replied:

Reply to this topic