How to use a an integer parameter to fetch parameter = "N" or all rows.

Article View: borland.public.interbase.sql

Article #848

Back to borland.public.interbase.sql Previous Next

#848

From: Mitch
Date: Wed, 30 May 2007 07:38

16 lines
1255 bytes

How can I easily query an integer column to get all the rows matching an 
integer or also allow all rows to be fetched? EG:

Item.Project (integer)
Item.Location (integer)

(Case 1)
Select * from Item where
Project = :ProjectID and Location = :LocationID

(Case 2)
Select * from Item where
Project = :ProjectID and Location = all locations

Thanks
Mitch

Technical Details

Message-ID: <465d29fa$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,d43d3e3c175ab47e,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Wed, 30 May 2007 08:38:32 +0100
From: Mitch <mmm@yyy.com>
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: How to use a an integer parameter to fetch parameter = "N" or all
 rows.
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 82.152.165.26
Message-ID: <465d29fa$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1180510714 82.152.165.26 (30 May 2007 00:38:34 -0700)
Lines: 16
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail