Re: Using ASP recordset as SQL table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ennex (Ennex_at_discussions.microsoft.com)
Date: 03/03/05 

Date: Thu, 3 Mar 2005 11:35:07 -0800

Bob,

     You asked me to post to both groups together, but I don't see how to do
that. I'm posting from MSDN.Microsoft.com/newsgroups, and when I click on
"New" or "Reply", it only allows for one discussion group. Maybe there's a
better news client I should be using.

> Having said that, there is a workaround:
> Insert the records resulting from your original query into a work table

     By "work table," do you mean what is produced by CREATE VIEW, as
suggested by Dave Methvin over in .scripting.jscript? If so, I'm not sure why
you call that a workaround, because it does exactly what I wanted, which is
to allow me to reference the results of one SELECT in another SELECT.

     If you meant something else by "work table," could you please refer me
to the doc on the procedures?

> Also, you can use the Filter property of your original recordset if you
> simply need to produce a subset of the records in your original recordset

     No, I need to do JOINs between tables and the results of the query.

     Thanks very much for your help.

MB

Relevant Pages

  • Re: Fender AB763
    ... Nice try but this has nothing to do with the original query nor does it ... have anything to do with your posting of an erroneous chart and using ... the information therein to base your meaningless comparison upon. ...
    (alt.guitar.amps)
  • Re: "Bombs away"
    ... >literal interpretation of the phrase? ... The phrase in question was in the ... >title of the posting. ... Please get back to my original query. ...
    (alt.usage.english)
  • Re: "Bombs away"
    ... >>title of the posting. ... Please get back to my original query. ... What you claim was your original question, ... Prev by Date: ...
    (alt.usage.english)