ASP (Active Server Pages) | SQL - (Structured Query Language) | Access Database Todays Date is: 9/24/2017
Home 
Home 
Contacts 
Us 
About Us 
Welcome 
ASP / Access 
CSS (New) 
Jobs We've Done 
Wikipedia Article(s) 
MalsonNash Media (XML/RSS Feed) 
Arizona Association For Foster & Adoptive Parents 
Million Pound Challenge 
Powder Coating It! 
WMS (Weight & Body Management System) 
Published & Awards 
Experts Exchange 
ASP (Active Server Pages)
We are very proud of the work that we do with ASP, it is a fascinating scripting language that takes SQL Queries from a database and produces some of what I consider to be the best pages on the internet.

SQL - (Structured Query Language) is used in gathering information from a database and displaying it to the client's browser.

Access is part of the Microsoft Office Suite of Development Tools.
We use Office 2007 but produce our tutorials and examples with the Office 2000 format.

Example of some of our code:

<%
Gets = Request.QueryString("id")
Set rs=Server.CreateObject("ADODB.RecordSet")
Sql = "SELECT Field1, Field2, Field3 FROM Table1 WHERE Field1="&Gets&""
rs.open sql, conn
%>

What the above code means and what it does.

Gets (This is a Query name that is used to access the URL String and gather the information that it has and matches it against the data that is stored in your database.
If the information in the database matches what the URL string is, then the data will be processed and the Query will be made, and the page will then display the given records)

sql This is our SQL Query to our database tables.
SELECT This is our SELECT statement, this statement shows our FieldNames and Table that associates with the FieldNames, to gather the data that the Query is made towards.

rs Is our recordset. This is what we use to display the records that are held within our database.
An example of a recordset in use: <%=rs("Field2")%>
This will display the information that is located within the Field2 that associates with the Field1 Query.

conn This is our Connection String. (Not displayed in this example)
A connection string is used to connect to a database. Without this, we will not be able to display data from our database.

ASP is pretty simple to learn, what makes it difficult is adding in JavaScript and other Client Side scripting to it, to make your pages stand out.

If you wish to learn more about ASP and how it all work. You can do a search on the Internet, or contact me and I will be happy to send you over more examples (or) information on the subject that I love so much.
To contact me please choose from the Menu [Contact Us] Choose ASP from the dropdown menu.

Thank you
Wayne Barron
Links will become available soon
CFF Coding Design's Networking Community
Coding Source
Codes for Experts Exchange TA's
The Internets Knowledge Base
Weight & Body Management System
Valid XHTML 1.0 Transitional Valid CSS!