Stateful App
About This Space
Stateful Customer Inquiry App
Last updated on February 14, 2020
Public Permissions: View Open/Fork Run Comment
Stateful App
This appprovides an example of a simple database inquiry and the use of database-driven components.
Database Driven Auto-Complete
The customer number textbox provides auto-complete functionality that shows available customer numbers, along with the corresponding customer names. The user simply starts typing into the box to see available choices.
This functionality is accomplished without any extra Node.js code thanks to the database-driven widget capabilities found in NodeRun. The textbox widget has the following properties set for auto-complete:
- choices database table
- choices options field
- choices value field
Other properties can help further refine the auto-complete functionality:
- choices selection criteria
- choices parameter value
- max choices
- contains match
- case sensitive
Retrieving Full Customer Information
Customer information is retrieved and then placed on the screen using pjs.query(), which accepts an SQL statement along with any parameters to bind to the SQL. The results of pjs.query() are returned into a JavaScript array without the need for a callback function. This simplifies top-down business application programming.
More Spaces By Alex (@alex)
This workspace illustrates the basic setup of an HTML page that includes external JavaScript and CSS files
45613
0
0
27632
0
0
This is the completed example for the Stateful To-Do List Application walkthrough (https://noderun.com/docs/walkthroughs/stateful_todo_list_app) and the starting point for the Drag and Drop walkthrough (coming soon). Please feel free to fork this workspace to use as a starting place for you own projects or for the walkthroughs.
28937
0
0
Displaying information in grids is fundamental to developing applications. This demo application displays a list of products in a grid.
47146
0
0
Displaying information in grids is fundamental to developing applications. This demo application displays a list of products in a grid.
45370
0
0
Displaying information in grids is fundamental to developing applications. This demo application displays a list of products in a grid.
45060
0
0
Be the first to comment:
Comments