Page 1 of 2
Reading, Modifying, and Updating database column values
Posted: Fri Dec 13, 2013 3:00 pm
by Dustin Moore
I have a page that has a Plus and a Minus button that when clicked will increase or decrease the current value displayed in a label by one. In my database I have a column whose data I would like to place in the label to be adjusted by the Plus or Minus buttons (if the value of the column in my database is 5, then 5 would appear in the label and the Plus or Minus buttons could adjust that number). Then I would like to take that new number and update the column in the database to reflect that number. I have tried many of the tutorials and documents (as well as some youtube webinars) but I can't quite figure it out. I'm new to Appery.io so I apologize if this is a really basic question.
Reading, Modifying, and Updating database column values
Posted: Fri Dec 13, 2013 3:01 pm
by Kateryna Grynko
Hi Dustin,
Please show us what exactly you tried and what doesn't work.
Reading, Modifying, and Updating database column values
Posted: Fri Dec 13, 2013 3:16 pm
by Dustin Moore
I've tried using the read service for the database to retrieve the number from the column in the database and have that sent to the label by mapping the response to the label. Then I have the Plus and Minus buttons to adjust the number, then the submit button invokes the update service for that database which has the label mapped to the appropriate column. I can send more images once I'm back at my PC this evening if it will help. I've attached a picture of the error I'm getting. I know I'm either doing something wrong or missing something...I don't have a lot of programming experience so a lot of this is very new to me.
Reading, Modifying, and Updating database column values
Posted: Fri Dec 13, 2013 6:10 pm
by Maryna Brodina
Hello! Could you post your mapping screenshot and JS you use for + and - buttons?
Reading, Modifying, and Updating database column values
Posted: Fri Dec 13, 2013 10:42 pm
by Dustin Moore
Reading, Modifying, and Updating database column values
Posted: Fri Dec 13, 2013 10:47 pm
by Dustin Moore
And here's the JS...sorry for the photos...the system I had access to doesn't allow screenshots

Reading, Modifying, and Updating database column values
Posted: Fri Dec 13, 2013 10:48 pm
by Dustin Moore
Sorry for the photos...the system I'm on at the moment won't allow screen shots

Reading, Modifying, and Updating database column values
Posted: Sat Dec 14, 2013 2:29 pm
by Alena Prykhodko
Hello Dustin! Sorry for delay, but photos are not readable. Could you please post them in other size?
Reading, Modifying, and Updating database column values
Posted: Mon Dec 16, 2013 9:24 am
by Maryna Brodina
Hello! Could you share your app with a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a?
Reading, Modifying, and Updating database column values
Posted: Mon Dec 16, 2013 12:11 pm
by Dustin Moore
It has been shared. I think I have more to learn about databases so I'm going over more of the support material and I'll try again once I have a better understanding. Thanks