Many people are more conscious of what they eat than ever before. (I count myself as a member of that club). The biggest challenge faced by many in the quest for a healthier lifestyle is the ubiquitous “lack of time” excuse. To help out, I have created a simple WAP application that allows for one to search for different foods and get related nutritional information, based on data from the American Diabetes Association. In this article, I’ll go over the creation of the application, and in the process, make you a little bit more health conscious.
Calorie Counter Using WAP and ASP - Hosting (Page 2 of 4 )
The application has to be hosted on a server that allows ASP. Currently this application is hosted at 1ASPHost.com. [Note: You can get a list of ASP-capable hosts here: http://www.aspfree.com/windows-web-hosting.asp. - Editor] Because the application uses a DNS-less connection to connect to the database, the database is loaded in the same directory as the WML and ASP pages.
Food.mdb
Food.mdb is an Access database containing a table called tblFoods.
The above diagram shows the structure of the table. The figure below shows some of the data in a tabular form:
This data was compiled from the American Diabetes Association. There are a total of 979 items in this database.
The next few sections will describe the other files, and list their source code that you can cut and paste into your text editor of choice.