Ken,
Many thanks for your kind reply. What I mean is - if I can use the Access "Query"
like I use the table? Do I need to change the commands in using the Query like I am
accessing the Accesss table as below:
"
dim conn
dim rs
dim strID
dim strconn
strconn="DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("FILE_NAME.mdb")
set conn = server.createobject("adodb.connection")
conn.open strconn
set rs = server.createobject("adodb.recordset")
id = Request("id")
SQLstr = "SELECT * FROM TABLE WHERE id = " & id
rs.open SQLstr, conn, 2, 2
"
Thanks in advance :O)
best regards,
Susan
----- Original Message -----
From: "Ken Schaefer" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Monday, August 26, 2002 1:13 PM
Subject: Re: muliple join tables
> ??
>
> 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.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
