If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ASP recordset as SQL table
Hi experts, I'm porting a database developed in Access to a Web site. In Access, I define a number of queries that are then used in other queries just as if they were tables. How do I do the same thing in ASP? I am thinking that what I want to do is something like the following. I would open a recordset that holds the results of a query: oRS1.Open('SELECT fields FROM table WHERE criterion', ...) and then I want to open another recordset that performs a SQL operation on the first recordset oRS2.Open('SELECT fields FROM oRS1 WHERE criterion', ...) But I don't know how to do that. How do I reference an established recordset in a new SQL statement? I can't just put the name of the recordset there because the table name that goes into a SQL statement is a string, and the recordset is an object, not a string. Am I making sense? I'm sure there must be a way to do this, but I can't find any documentaiton of such a procedure. Thanks for your help. Regards, Marshall Burns www.Ennex.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to insert record to Access via SQL from an ASP page | Norman Yuan | General Discussion | 1 | February 2nd, 2005 08:23 PM |
SQL criteria for deleting one table from another | Quan | Running & Setting Up Queries | 1 | January 24th, 2005 10:12 PM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
Access & OleDb - generating schema changes, problem with identity/counter fields. | Thomas Tomiczek [MVP] | Database Design | 9 | November 5th, 2004 10:32 AM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |