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.Image


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

Hopefully this helps. Here are the mapping shots...JS is on the wayImageImageImageImage


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 screenshotsImageImage


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 shotsImageImage


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