Ken, Thanks in a million :O) Will do..
best regards, Susan ----- Original Message ----- From: "Ken Schaefer" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 1:11 PM Subject: Re: muliple join tables > objRS.Open <QueryName>, objConn, adOpenForwardOnly, adLockReadOnly, > adCmdStoredProc > > I really suggest you look in the MSDN documentation on ADO objects, it is > very helpful. The following page is for the .Open method of the recordset > object, and explains the above in a little more detail: > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/ > mdmthrstopen.asp > > Cheers > Ken > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > From: "Susan Lin" <[EMAIL PROTECTED]> > Subject: Re: muliple join tables > > > 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]
