Re: how to access final SQL from parameterized ADO

dondraper wrote:
Sorry, I was not clear enough. I need to access the SQL from ADO after
the execute has occurred. I want to be able to store the entire sql so
that it may retrieved in the future and same query ran again without
the need for the original query values.

Is there a way to do this from ADO?


No. all you can do is save the parameter values somewhere (perhaps in
Session or Application) and re-use them with the same sql statement (or
with a stored procedure).

Why would you need to be able to do this?

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Involved query / possible over Access assistance.
    ... Also, Standard SQL doesn't include a bit operator, but most SQL products ... read some database design books or articles on the WEB for info on ... However, I want to store ... > I want to then do a query for a given week. ...
    (microsoft.public.access.queries)
  • Re: Bypassing Parameters in a Query?
    ... Open your query in design view, then choose "SQL View" from the "View" menu. ... being plain text - you can copy and paste it straight into a newsgroup post. ... > parameter where you say [Parameter Prompt]? ...
    (microsoft.public.access.queries)
  • Re: ASP Page tyring to query AS/400 file
    ... SQL State: 37000, Error Code: -104 ... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ... IBM says this MS Query is aliasing one of the fields in the query ... this newsgroup is not relevant. ...
    (microsoft.public.scripting.vbscript)
  • RE: Running diferent query with one command
    ... I would create a table that would store this information ... You don't have to "know how to use SQL". ... Query result will look like this. ... Duane Hookom wrote: ...
    (microsoft.public.access.queries)
  • Re: SQL to allow a "no preference (all) choice
    ... and reading the names of the tables in your sql statement. ... your query with aliases either. ... > MeetingDay are all of the days of the week, ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)