Gossamer Forum
(Advanced Search)
for
Aug 16, 2002, 3:17 AM
Paul
Veteran (19537 posts)
Aug 16, 2002, 3:17 AM
Views: 13448
Shortcut
Quote Reply
A query
If I use the following:

SELECT * FROM Table WHERE Col1 != '2' AND Col2 = '2'

...and I have one row:

Col1 = NULL
Col2 = 2

....why is nothing being selected?.....I get no errors from DBI->errstr

Last edited by:

Paul: Aug 16, 2002, 3:18 AM
Subject Author Views Date
Thread A query Paul 13448 Aug 16, 2002, 3:17 AM
Thread Re: [Paul] A query 		lanerj 12977 Aug 16, 2002, 6:06 AM
Thread Re: [lanerj] A query 		Paul 13016 Aug 16, 2002, 6:27 AM
Thread Re: [Paul] A query 		lanerj 12967 Aug 16, 2002, 7:45 AM
Thread Re: [lanerj] A query 		Paul 12977 Aug 16, 2002, 8:15 AM
Thread Re: [Paul] A query 		Stealth 12981 Aug 16, 2002, 9:05 AM
Thread Re: [Stealth] A query 		Paul 12944 Aug 16, 2002, 9:06 AM
Thread Re: [Paul] A query 		Alex 12921 Aug 16, 2002, 12:39 PM
Post Re: [Alex] A query 		Paul 12923 Aug 16, 2002, 12:42 PM
Thread Re: [Alex] A query 		Paul 12912 Aug 16, 2002, 12:49 PM
Post Re: [Paul] A query 		Alex 12916 Aug 16, 2002, 1:00 PM