query con capo null

Article View: free.it.visual-basic

Article #629

Back to free.it.visual-basic Previous Next

#629

From: fuxverona
Date: Wed, 15 Feb 2006 13:50

12 lines
1408 bytes

ciao io devo creare una query che cerchi nel DB dei record questa query
ha 3 parametri da ricercare ma uno di essi potrebbe essere null come
posso fare??

faccio esempio.
campo1 stato
campo2 citta
campo3 paese

io devo fare una query che mi ricechi questi 3 parametri ma uno
potrebbe non esserci come posso fare??
e se un campo fosse vuoto me li riporta tutti

Technical Details

Message-ID: <1140011417.759363.13700@g43g2000cwa.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f94ee,909d80d2fbbf86ee,start
X-Google-Attributes: gidf94ee,public
X-Google-Language: ITALIAN,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: fuxverona@gmail.com
Newsgroups: free.it.visual-basic
Subject: query con capo null
Date: 15 Feb 2006 05:50:17 -0800
Organization: http://groups.google.com
Lines: 13
Message-ID: <1140011417.759363.13700@g43g2000cwa.googlegroups.com>
NNTP-Posting-Host: 82.193.6.34
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1140011424 31898 127.0.0.1 (15 Feb 2006 13:50:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 15 Feb 2006 13:50:24 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=82.193.6.34;
   posting-account=IJjnTg0AAAALxL6sRhe9lv1xCP67bql4