Forum | Appery.io

Yeah, I was able to get the join to work on the Web SQL database, here is the command I used incase others have questions on this subject: 'SELECT Categories. objectId, Categories.BasicCategory, Categories.SubCategory, UserSelectedCategories.Category_Id, UserSelectedCategories.Marked FROM Categories...

OK, thanks for your help, but all I need to do was ask the question and then I figured it out. I got rid of the variable and just included the (localStorage.getItem('Selected')) in the query and it world like a charm. Next level I need to do a join, wish me luck.

I just tried using

"'+SelectedSuperCategory+'"

and it sort of worked. I do get filtered data, but it is the wrong data.

???

Hello, In my app I have a list that is populated from a Web SQL database (as learned in the "Building a mobile app with the Appery.io and local SQLite databases" tutorial. I have used the javascript from that tutorial and have successfully copied the two tables I need local and can use a j...

Thanks,

I also found your tutorial on creating a local SQL database, this might also help me achieve what I'm looking for. I really dig this tool, I keep finding things that make it better.

Thanks for the support

Thanks, I will give it a try

Thanks for the reply. I had already done all of that, but the problem was that I need the value from the selected 'Master' collapsible header for the second service parameter. But I have decided to use multiple pages with sists instead of collapsibles, it doesn't look at cool, but it works as I need...

Thanks

Hello, I have a collapsible list that I am populating with a REST service which works nicely. Now I would like to nest another collapsible list inside the first and also populate it with a REST service based on the header value of the selected header. I have tried many tricks and the best I have don...

EXACTLY what I needed!

Thanks

Search found 37 matches

Web SQL Query

Web SQL Query

Web SQL Query

Web SQL Query

Getting (currently expanded) header text value

oauth

Getting (currently expanded) header text value

Getting (currently expanded) header text value

Getting (currently expanded) header text value

Is there a way to configure REST URL dynamically ?