The following code update a database collection. It always work fine for me in my equipment in Colombia, but not when for the real users in UK. I really don’t know what to do! Is very urgent!!! Please help me!!!
The page code is:
export function boxButtonChoose_click(event) {
console.log(“Botón oprimido”)
let userActual = session.getItem(“sto_userActual”);
let positionSel = session.getItem(“sto_positionSelected”);
let productCodeSel = session.getItem(“sto_productCode”);
let descriptionSel = $w(“#textDescription”).text;
let priceSel = $w(‘#textPriceNum’).text;
let wrasMessageBoolSel = session.getItem(“sto_wrasMessage”);
let wrasMessageSel
if (wrasMessageBoolSel === ‘true’)
{
wrasMessageSel=1
}
else
{
wrasMessageSel=0
}
setTimeout(() => {
updateRegisterDBProductSel(userActual, descriptionSel, productCodeSel, positionSel, priceSel, wrasMessageSel)
.then(resultUpdate =>
{
console.log(“END updateRegisterDBProductSel”)
updateTime();
wixLocation.to("/question1")
});
}, 1000);
}
export function updateRegisterDBProductSel(codUserTxtSel, descriptionSel, productCodeSelectedTxtSel, positionSelectedTxtSel, priceSelectedTxtSel, wrasVisibilitySelectedTxtSel) {
console.log(“IN updateRegisterDBProductSel”)
let codUserSel = parseInt(codUserTxtSel, 10)
let productCodeSelectedSel = parseInt(productCodeSelectedTxtSel, 10)
let descriptionSelected = descriptionSel
let positionSelectedSel = parseInt(positionSelectedTxtSel, 10)
let priceSelectedSel = parseInt(priceSelectedTxtSel, 10)
let wrasVisibilitySelectedSel = parseInt(wrasVisibilitySelectedTxtSel, 10)
//Get original record and update fields
return wixData.query(“colSurvey”)
.eq(“codUser”, codUserSel)
.find()
.then((resultDB) => {
if (resultDB.items.length > 0) {
let item = resultDB.items[0];
item.productCodeSelected = productCodeSelectedSel; // fields to be updated
item.descriptionSelected = descriptionSelected;
item.positionSelected = positionSelectedSel;
item.priceSelected = priceSelectedSel;
item.wrasVisibilitySelected = wrasVisibilitySelectedSel;
wixData.update("colSurvey", item);
} **else** {
// handle case where no matching items found
}
return
})
. catch ((err) => {
let errorMsg = err;
});
}