Return-Path: 
 <general-return-400-apmail-db-general-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-general-archive@www.apache.org
Received: (qmail 51397 invoked from network); 27 Oct 2007 00:43:33 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 27 Oct 2007 00:43:33 -0000
Received: (qmail 92337 invoked by uid 500); 27 Oct 2007 00:43:20 -0000
Delivered-To: apmail-db-general-archive@db.apache.org
Received: (qmail 92288 invoked by uid 500); 27 Oct 2007 00:43:20 -0000
Mailing-List: contact general-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:general-help@db.apache.org>
list-unsubscribe: <mailto:general-unsubscribe@db.apache.org>
List-Post: <mailto:general@db.apache.org>
Reply-To: general@db.apache.org
List-Id: <general.db.apache.org>
Delivered-To: mailing list general@db.apache.org
Received: (qmail 92273 invoked by uid 99); 27 Oct 2007 00:43:20 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Oct 2007 17:43:20 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of soumensaha@gmail.com
 designates 209.85.198.186 as permitted sender)
Received: from [209.85.198.186] (HELO rv-out-0910.google.com) (209.85.198.186)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Oct 2007 00:43:24 +0000
Received: by rv-out-0910.google.com with SMTP id b22so858194rvf
        for <general@db.apache.org>; Fri, 26 Oct 2007 17:43:00 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
        bh=ycxsrJF7qnUReUGiHa3ber9LjV5sYNDJCP61jf02yKg=;
        b=GuuTHZlGVPtZhrOIjwZCGzuYlzCIRCtOz4nCVf1JAuoiL02xNkPZfLHLIKxL64+uyml8JI+iMu/cprokwm7jpydc1VrhE+m+47pcG5+cFsexSdknymreeCRacEv+QKJkz5nsy4Cq2Tvy6DaGTGD90VJ/Pvtg5eDWyKBVc8d7C9g=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=ao8Q00PcO1hIFfvgpOdx5YbJG4AZJchpcG74aF7sO3I8cr5YUuwVeiPa8FF+0MsuBC5xA51KRIHU2dwqOpf3z0Sp5I6XTHrUf2z2GV0sPb8PlcLYsaixkEgR+Ej63GDIEaSpzu5N+ob35nTgSjzedgOwifLviVwfd9DBumZ5hvA=
Received: by 10.142.103.6 with SMTP id a6mr1026526wfc.1193445780895;
        Fri, 26 Oct 2007 17:43:00 -0700 (PDT)
Received: by 10.142.165.18 with HTTP; Fri, 26 Oct 2007 17:43:00 -0700 (PDT)
Message-ID: <1eb85fd50710261743m78eb4f0fl576aeeeb0c44ec4f@mail.gmail.com>
Date: Fri, 26 Oct 2007 20:43:00 -0400
From: "Soumen Saha" <soumensaha@gmail.com>
To: general@db.apache.org
Subject: NULL checking in Derby
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_5495_4687038.1193445780885"
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_5495_4687038.1193445780885
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN ('',null);

This is working in SQL Server but not in Derby... The error is Error code
-1, SQL state 42X01: Syntax error: Encountered "NULL" . Could some one
please tell the solution...

Thanks & Regards,
Soumen

------=_Part_5495_4687038.1193445780885
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN (&#39;&#39;,null);<br><br>This is working in SQL Server but not in Derby... The error is<span style="color: rgb(204, 0, 0);"> <span style="color: rgb(153, 0, 0);">Error code -1, SQL state 42X01: Syntax error: Encountered &quot;NULL&quot; 
</span></span><span style="color: rgb(153, 0, 0);">.</span> Could some one please tell the solution...<br><br>Thanks &amp; Regards,<br>Soumen<br>

------=_Part_5495_4687038.1193445780885--