Knowledgebase
Studio433 Support > Help Desk > Knowledgebase

Search help:


Active Server Pages

Solution

What is ASP?

Active Server Pages (ASP) is a powerful server-side scripting language initially designed for use on Microsoft Servers, and is embedded in HTML pages. The language is a little more complex than PHP, but is very similar in principle. It allows dynamic web pages to be created quickly and easily.

The ASP product provided on the Studio433 Virtual servers is iASP (Instant ASP).

Using ASP

After adding your script to your web page, you simply need to change the file name suffix from ".htm" or ".html" to ".asp". This causes the page to be processed as ASP, and the required output is then sent to the browser as HTML.

Testing ASP

Here is a simple sample script that demonstrates ASP:

<HTML>
<HEAD>
<TITLE>Demonstration Page</TITLE>
</HEAD>
<BODY>
<CENTER>
<% 
dim ftsize, ftcolor
for ftsize = 1 to 7
%>
<FONT SIZE = <%=ftsize%>> Isn't Studio433 wonderful?<BR>
<% next %>
</CENTER>
</BODY>
</HTML>

That script is really simple, but getting to know ASP will reveal many poerful features.

Connecting to your MySQL database

As MySQL is ODBC-compliant you can upload, download and manipulate your data using your Windows 98/2000 desktop and Microsoft Access.

The basic command that you need to use in your ASP script is this:-

ConnectionString="DRIVER=org.gjt.mm.mysql.Driver;URL=
    {jdbc:mysql://IPnumber:3306/databasename};uid=username;pwd=password;"
set con = Server.CreateObject("ADODB.Connection") con.open(ConnectionString) 

Note - although it may seem a security risk to include your password in the page source, ASP only generates the resulting page as HTML and users cannot view the original source of the ASP.

Sources of information

There are many resources of good information about ASP. Here are a few that may be useful:

  • Instant ASP downloadable manuals, lots of help
  • Webmonkey tutorials and help
  •  
    Was this article helpful? yes / no
    Article details
    Article ID: 18
    Category: Web site design
    Date added: 2013-08-27 19:19:33
    Views: 567
    Rating (Votes): Article rated 3.4/5.0 (23)

     
    « Go back

     
    Powered by Help Desk Software HESK - brought to you by Help Desk Software SysAid