Re: Hj�lp til SQL

Article View: dk.edb.database

Article #15120

#15120

From: Mads Lie Jensen
Date: Tue, 10 Jul 2001 17:33

22 lines
1693 bytes

On Tue, 10 Jul 2001 16:44:13 +0200, "Cliff Huxtable"
<oldblackguy@thatbigoldhouse.com> wrote:

>> SELECT prodID FROM din_tabel WHERE typeID = 1 and typeID = 3
>>
>
>�h.... Ja, det var ogs� mit eget umiddelbare g�t, men det returnerer alts�
>et tomt recordset... :(

Selvf�lgelig g�r den det. typeID kan ikke v�re b�de 1 og 3 i samme
post.

Brug i stedet

SELECT prodID FROM din_tabel WHERE typeID=1 OR typeID=3


-- 
Mads Lie Jensen - mads@gartneriet.dk - ICQ #25478403
http://www.gartneriet.dk

Directory Opus - nu ogs� til windows - http://www.gpsoft.com.au

Technical Details

Message-ID: <n1fmkt8rdinvqaruhv6per991ck0mk62h9@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!newsrouter.euroconnect.net!news.cybercity.dk!not-for-mail

References:

<3b4adf9e$0$3243$ba624c82@nntp01.dk.telia.net> <pnplktcff70bnegdioufgp1li3miapdfp3@4ax.com> <3b4b14f4$0$31243$ba624c82@nntp01.dk.telia.net>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,66a3426525c70bc6
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-10 11:05:32 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!newsrouter.euroconnect.net!news.cybercity.dk!not-for-mail
From: Mads Lie Jensen <mads@gartneriet.dk>
Newsgroups: dk.edb.database
Subject: Re: Hj�lp til SQL
Date: Tue, 10 Jul 2001 19:33:47 +0200
Organization: Gartneriet
Lines: 22
Message-ID: <n1fmkt8rdinvqaruhv6per991ck0mk62h9@4ax.com>
References: <3b4adf9e$0$3243$ba624c82@nntp01.dk.telia.net> <pnplktcff70bnegdioufgp1li3miapdfp3@4ax.com> <3b4b14f4$0$31243$ba624c82@nntp01.dk.telia.net>
NNTP-Posting-Host: port15.cvx1-hj.ppp.cybercity.dk
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: news.cybercity.dk 994788324 70056 217.157.69.16 (10 Jul 2001 18:05:24 GMT)
X-Complaints-To: abuse@cybercity.dk
NNTP-Posting-Date: Tue, 10 Jul 2001 18:05:24 +0000 (UTC)
X-Newsreader: Forte Agent 1.8/32.548

Reply to Parent Message