Store value into exist row...

i created 2 form...

form 1 after fill in all then i store into database and proceed to form 2...

the question is how i gonna store data in form 2 into the table that i stored form 1...example...form 1 i store Name...form 2 i store password...into a table call Login...

because after i store form 1 and form2...they are in different rows in table...mean that i store form 1 the column in form 2 is null...i store form 2 the column in form 1 is null...

how to solve it...?...thanx...
[574 byte] By [BlackPepper] at [2007-12-28]
# 1
How do you perform your insert towards the database? And what does your table look like?

Simply do an update to the existing row with the password.
Another solution would be to do only one insert (after 2. form). Just maintain the variable from form 1, and use it when inserting in form 2.

Why would you like to different forms for name and password in the first place? I'd rather have both input fields in the same form.

Cobolman at 2007-9-4 > top of Msdn Tech,Visual Basic,Visual Basic Language...