Something i 'm missing 2007-08-15 - By Lyall Barbour
Back
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_colfrom blah_tablewhere
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 http://www.mail.com !
Get a FREE E-mail Account Today - Choose From 100+ Domains
<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">Mail.com</a><br>
Get a <b>FREE</b> E-mail Account Today - Choose From 100+ Domains</div>
|
|
