|
 |
access_asp thread: Help with SQL statement.
Message #1 by "Vandael Tim" <vandael_tim@h...> on Thu, 18 Apr 2002 13:09:44
|
|
Hello,
i have a problem with my SQL statement,
in my table there are 2 colums, ID and Name.
ID is auto-nummering and Name are the names of the sort.
In the colum Name thare are Veiligheid, Proces, Zelfcontrole, Werk, ....
What i want now is, that he selects all except the Proces value.
sql = "SELECT * FROM Soort ORDER BY ID"
thnx
Vandael Tim
Message #2 by "Peter Rooney" <peter.rooney@p...> on Thu, 18 Apr 2002 13:30:14 +0100
|
|
Try this:
sql = "SELECT * FROM Soort WHERE Name <> 'Proces' ORDER BY ID"
Peter
-----Original Message-----
From: Vandael Tim [mailto:vandael_tim@h...]
Sent: 18 April 2002 13:10
To: Access ASP
Subject: [access_asp] Help with SQL statement.
Hello,
i have a problem with my SQL statement,
in my table there are 2 colums, ID and Name.
ID is auto-nummering and Name are the names of the sort.
In the colum Name thare are Veiligheid, Proces, Zelfcontrole, Werk, ....
What i want now is, that he selects all except the Proces value.
sql = "SELECT * FROM Soort ORDER BY ID"
thnx
Vandael Tim
--
Virus scanned by edNET.
Message #3 by Abdul Sami <abdul_sami_20@y...> on Thu, 18 Apr 2002 05:35:26 -0700 (PDT)
|
|
The sql could be
sql = "SELECT * FROM Soort where name<>proces ORDER BY ID"
--- Vandael Tim <vandael_tim@h...> wrote:
> Hello,
>
> i have a problem with my SQL statement,
> in my table there are 2 colums, ID and Name.
>
> ID is auto-nummering and Name are the names of the sort.
> In the colum Name thare are Veiligheid, Proces, Zelfcontrole, Werk, ....
>
> What i want now is, that he selects all except the Proces value.
>
> sql = "SELECT * FROM Soort ORDER BY ID"
>
> thnx
>
> Vandael Tim
=====
Abdul Sami
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
|
|
|
View Cart
