Query a SQL DB and make a table based on returned data
I have been able to accomplish the listed topic, but my problem is in making a table that retains the previous queries and adds the new one below it. Right now I can only get one record, as when the page reloads it only gets the new query without saving the old one.
The user scans a barcode and submits it using a macro, I redirectToCurrentUmbracoPage, send the query result to javascript and it builds a table based on the query results.
Would I store the user inputs in an array and modify the query to search for all records again? Modify the javascript to somehow add to the current table since the schema should be the same? Something else I am missing here? Any help would be greatly appreciated!
Query a SQL DB and make a table based on returned data
I have been able to accomplish the listed topic, but my problem is in making a table that retains the previous queries and adds the new one below it. Right now I can only get one record, as when the page reloads it only gets the new query without saving the old one.
The user scans a barcode and submits it using a macro, I redirectToCurrentUmbracoPage, send the query result to javascript and it builds a table based on the query results.
Would I store the user inputs in an array and modify the query to search for all records again? Modify the javascript to somehow add to the current table since the schema should be the same? Something else I am missing here? Any help would be greatly appreciated!
is working on a reply...