List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 9 2001 3:47am
Subject:Re: SELECT * FROM allofthetables
View as plain text  
At 9:09 PM -0500 9/8/01, Deryck Henson wrote:
>How do I select all of the tables in a database and use a whre clause like
>this??::
>
>SELECT * FROM alltables(substitute with command) WHERE User = 'username'

You can't.

>
>I need this for my site (Code Cafe- Free source code) so that the user can
>see all the code he has uploaded.  It is done in ASP, but all I need is the
>sql query string.  Thanx
>
>- Deryck H
>- http://www.comp-u-exchange.com


-- 
Paul DuBois, paul@stripped
Thread
SELECT * FROM allofthetablesDeryck Henson9 Sep
  • Re: SELECT * FROM allofthetablesPaul DuBois9 Sep
  • Re: SELECT * FROM allofthetablesMarjolein Katsma9 Sep
  • Re: SELECT * FROM allofthetablesBenjamin Pflugmann9 Sep
  • Re: SELECT * FROM allofthetablesDeryck Henson9 Sep
    • Re: SELECT * FROM allofthetablesBenjamin Pflugmann10 Sep