??
A driver is something that you use to connect to a database. So there is an
ODBC driver for Access, and ODBC Driver to SQL Server etc. This means that
the same higher level ADO objects can take to many different databases -
each ODBC driver takes care of the peculiarities of the underlying database
CreateObject is used to instantiate an object instance of a class. So, to
instantiate an ADO Connection object, you would use:
Context.CreateObject("ADODB.Connection")
In the ASP world, the context is Server, hence Server.CreateObject(...)
Mappath() is a method of the Server object, that returns the physical
address of a supplied URL, eg
strPath = Server.Mappath("/default.asp")
None of these have anything to do with JOINS inside Access. A JOIN is
something to do with SQL.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Susan Lin" <[EMAIL PROTECTED]>
Subject: Re: muliple join tables
Dear Sam or anyone there,
Would appreciate if you could kindly advise how to connect the Access query
in further details. So far, I've been using tables connection for ASP
programming. Are the Driver, MapPath, createobject used in the same way?
TIA :)
best regards,
Susan
----- Original Message -----
From: "Sam Thompson" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Monday, August 19, 2002 6:57 PM
Subject: Re: muliple join tables
> Multiple inner joins are abit different in Access, the easiest way to do
it
> is to create a query in design view, select each field and check the box
> which says "Show". Access will do the hard work for you. You can then save
> the query in Access, and call it from your asp page (select * from
> mySavedQuery).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
