Something i 'm missing 2007-08-15 - By Andrew Kerber
Back
try ... where blah_col=blah_col
(just put the column name in the & variable).
On 8/15/07, Lyall Barbour <lyallbarbour@(protected)> 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.'
try ... where blah_col=blah_col<br>
<br>
(just put the column name in the & variable).<br><br><div><span class=
"gmail_quote">On 8/15/07, <b class="gmail_sendername">Lyall Barbour</b> <<a
href="mailto:lyallbarbour@(protected)">lyallbarbour@(protected)
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div
>Hey everybody,</div>
<div> 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.</div>
<div> </div>
<div>select blah_col</div>
<div>from blah_table</div>
<div>where blah_col = &blah_variable;</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Lyall</div>
<div> </div><br>
--
<div>We've Got Your Name at <a href="http://www.mail.com/?utm_source=mail
_sent_footer&utm_medium=email&utm_term=070621&utm_content=textlink
&utm_campaign=we_got_your_name" target="_blank" onclick="return top.js
.OpenExtLink(window,event,this)">
Mail.com</a><br>
Get a <b>FREE</b> E-mail Account Today - Choose From 100+ Domains</div>
</blockquote></div><br><br clear="all"><br>-- <br>Andrew W. Kerber<br><br>'
;If at first you dont succeed, dont take up skydiving.'
|
|
