AppMLNewbie Posted December 19, 2014 Share Posted December 19, 2014 In the AppML tutorial a sample application with Northwind.mdb is given for download. In the model section an xml document provides a connection to the database with a select statement such as Select * from Products. However, from time to time, we need to provide a select statement that includes some parameters for the where clause, for example: Select * from Products where CategoryID = @CategoryID and SupplierID=@SupplierID. I would appreciate it if someone can advise, and provide an example, on how to handle the input parameters of @CategoryID and @SuppierID, in the xml as well as in the html pages. Often, the input parameters can be chosen from a dropdown list such as dropdown_Categories and dropdown_Suppliers. In such cases, how do we code these in the related html pages? Thanks and regards Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now