Re: Something i'm missing

  • From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
  • To: lyallbarbour@xxxxxxxxxxxxxxx
  • Date: Wed, 15 Aug 2007 10:13:14 -0500

try ... where blah_col=blah_col

(just put the column name in the & variable).

On 8/15/07, Lyall Barbour <lyallbarbour@xxxxxxxxxxxxxxx> wrote:
>
> Hey everybody,
>    This is probably something easy and simple i'm missing.  I'm using the
> & in the WHERE clause of a query to get certain information.  How do i get
> ALL the information, too.  Essentially, blanking out the where clause.
>
> select blah_col
> from blah_table
> where blah_col = &blah_variable;
>
> When the prompt comes up, if i just want all in info, is it possible to
> get this?  I just hit enter and didn't work.
>
> Lyall
>
>
> -- We've Got Your Name at 
> Mail.com<http://www.mail.com/?utm_source=mail_sent_footer&utm_medium=email&utm_term=070621&utm_content=textlink&utm_campaign=we_got_your_name>
> Get a *FREE* E-mail Account Today - Choose From 100+ Domains
>



-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Other related posts: