 | | | Something i 'm missing | Something i 'm missing 2007-08-15 - By Stefan Knecht
Back
Assuming this is a number, as you don't have any quotes around
&blah_variable
Just put blah_col in as the value when the prompt comes up ?
sys@(protected)> drop table t;
Table dropped.
sys@(protected)> create table t (x int);
Table created.
sys@(protected)> insert into t values (1);
1 row created.
sys@(protected)> insert into t values (2);
1 row created.
sys@(protected)> insert into t values (3);
1 row created.
sys@(protected)> commit;
Commit complete.
sys@(protected)> select * from t where x = &foo;
Enter value for foo: 1
old 1: select * from t where x = &foo
new 1: select * from t where x = 1
X
-- ---- --
1
sys@(protected)> select * from t where x = &foo;
Enter value for foo: x
old 1: select * from t where x = &foo
new 1: select * from t where x = x
X
-- ---- --
1
2
3
sys@(protected)>
Stefan
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
>
--
=========================
Stefan P Knecht
Consultant
Infrastructure Managed Services
Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg
Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@(protected)
http://www.trivadis.com
=========================
Assuming this is a number, as you don't have any quotes around &blah
_variable<br><br>Just put blah_col in as the value when the prompt comes up ?<br
><br>sys@(protected)> drop table t;<br><br>Table dropped.<br><br>sys@(protected)
> create table t (x int);<br><br>Table created.<br><br>sys@(protected)>
insert into t values (1);<br><br>1 row created.<br><br>sys@(protected)> insert
into t values (2);<br><br>1 row created.<br><br>sys@(protected)> insert into t
values (3);
<br><br>1 row created.<br><br>sys@(protected)> commit;<br><br>Commit complete.
<br><br>sys@(protected)> select * from t where x = &foo;<br>Enter value for
foo: 1<br>old 1: select * from t where x = &foo<br>new
1: select * from t where x = 1
<br><br> X<br>-- ---- --<br>
1<br><br>sys@(protected)> select
* from t where x = &foo;<br>Enter value for foo: x<br>old 1:
select * from t where x = &foo<br>new 1: select * from t where
x = x<br>
<br> X<br>-- ---- --<br>
1<br>
2<br> 3<br>
<br>sys@(protected)><br><br><br>Stefan<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>=========================<br>
<br>Stefan P Knecht<br>Consultant<br>Infrastructure Managed Services<br><br
>Trivadis AG<br>Europa-Strasse 5<br>CH-8152 Glattbrugg<br><br>Phone +41-44-808
70 20
<br>Fax +41-808 70 12<br>Mobile +41-79-571 36 27<br><a href="mailto:stefan
.knecht@(protected)">stefan.knecht@(protected)</a><br><a href="http://www
.trivadis.com">http://www.trivadis.com</a><br><br>=========================
|
|
|