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 PROTECTED]
