What
is ASP?
ASP
is an abbreviation for Active
Server Pages. The code inside ASP is mixed in with standard HTML
and is NEVER seen by the browser. ASP
pages run in ALL browsers.
top
How do I connect
to my Access Database?
You connect
using DSNless connections. This is faster than a system DSN
since it saves a trip to read the registry each attempt. The
following is an example of how you can set up your connection.
<%
accessdb="yourdatabasename.mdb"
myDSN="DRIVER={Microsoft Access Driver (*.mdb)};"
myDSN=myDSN & "DBQ=" & server.mappath(accessdb)
query="SELECT * FROM customers etc..."
'(your
SQL query)
SET connect = Server.CreateObject("ADODB.Connection")
connect.open (myDSN)
SET RS = connect.execute(query) '(Load
Record Set)
.....the
rest of your code......
%>
top
Where
should I upload my database to?
You should upload your database to the root directory of your
webspace . It is preferable to ensure your database is password
protected. top
How do I use
server side includes?
Save the code to be included as yourincludefile.inc or
yourincludefile.asp , or yourincludefile.txt. Simply put the include code within HTML pages, inside comment
tags. You will need to save the pages as ASP rather than HTML.
Examples:
<!--#include file="yourincludefile.inc"-->
<!--#include virtual="yourincludefile.inc"-->
When the
page is loaded by a browser the contents of yourincludefile.inc
will be included within the page. top
I'd
like to download
an ASP email Script
We have an example on our downloads
page top
What ASP components are installed?
Jmail (mail) and ASPUpload top
Where can I
get more help?
We recommend http://www.learnasp.com
a brilliant resource written by Charles Carroll. There are
hundreds of lessons and lots of code here, plus links to all the
top ASP sites. top
Back to Support Index
View Cart