Updating database records on Frontpage

[Mj]

Hi all,

I am trying to use UPDATE using SQL
my layout is:
ID PASSWORD
underneath there is a box to enter Id and a space to enter
a new password and then an update box which i want to
overight the existing password - instead it is adding the
password at the bottom with a new id

SQL:
UPDATE PASSWORD
SET System.Password ='::update_password::'
WHERE System.ID='::&update_id&::'

can anyone help?

thanks

 

[Jon Spivey]

Hi,
you should have something like
UPDATE PASSWORD
SET System.Password ='::update_password::'
WHERE System.ID='::update_id::'

Where update_password is the new password textbox and update_id is the id
textbox (assuming update_id is text - if its numeric lose the quotes)

 

[Guest]

thanks,

Unfortunaetly still not working - still doing the same -
putting the password at the bottom rather than
overrighting the original

Mj