Jump to content
Sign in to follow this  

How to add/use parameters in AppML model/xml

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


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...