Inserting data into an existing record

[Jayuk]

I am trying to find out how to insert data into an existing record in a database based on the user's unique ID number.

I have managed to move to the relevant record by checking if the ID number matches the URL parameter passed to it, but cannot seem to get it to insert into the appropriate record.

Any help that anyone could offer would be much appreciated.


Jennie
Cyber Marketing Administrator

* Sorry ASP newbie * I suppose we all have to start somewhere!

 

[timtom]

You should use an Update Sql statement, for example :

sql = "UPDATE TABLE_NAME set FIELD1 = '" & field1 & "', FIELD2 = '" & field2 & "', FIELD3 = '" & field3 & "' where USER_ID = " & Request.QueryString("USER_ID&quot &

Where capital letters indicate field names and lowercase letters indicate variables to put into the record.

Hope this helps,

Sarah

_{WASN'T FIT ENOUGH FOR THE POLICE FORCE}​

 

[gsc1ugs]

Or stay with insert

insert into tablename(param1,param2) values (1 ,2) where id = yourid

Regards gsc1ugs
"Cant see wood for tree's...!"