Unable to Update a particular field in database

Ask the community
,
1

We have to update a single value of the field in Database,
But now the issue is when we updating the field the row get empty and after that the updated value come in that field.
PFA of the password change field Database

1117×472 18.7 KB

As you can see on the above image the above two rows get empty and the updated value are now in the field like “abc” and “shahrukh123” with Mr. in that
You can also find the code of that

1102×485 22.4 KB

Also find the attachment of our front-end

1038×501 11.6 KB

We are stuck in this
We have also refer your https://www.wix.com/code/reference/wix-data.html#u… this page but doesn’t work for us,
Please help us.

1 Like
2

I recommend using console.log to check whether you get results after using the “query” function.
Moreover, when updating an existing record, please make sure that there’s info of all the columns and not just the updated ones. In this case, the toInsert object should have the properties “title”, “username”, “changePassword”.

3

Can you explain in more detail ??
Thanks for you response.

4

Hey,
It should be something similar to this function:

export function button1_click_1(event, $w) {

	let username = $w('#input1').value;
	let password = $w('#input2').value;

	wixData.query("Change_password")
		.eq("username", username)
		.find()
		.then((results) => {
			let Id = results.items[0]._id;
			let oldPassword = results.items[0].password;

			//adding all the fields of the record 
			let toUpdate = {
				"_id": Id,
				"title": "Mr.",
				"username": username,
				"password": password,
				"changedPassword": oldPassword
			};
			
			updatePassword(toUpdate);
		});
}


function updatePassword(toUpdate){
    wixData.update("Change_password", toUpdate) 
	.then((results) => { 
		console.log("item was undated sucessfuly"); 
	}) 
	.catch((err)=>{ 					
		console.log(err); 
	});
}

Best,
Tal.