Jump to content

How to add/use parameters in AppML model/xml


AppMLNewbie

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...