List Info

Thread: NULL checking in Derby
NULL checking in Derby
user name
 2007-10-26 19:43:00 

  


  

    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


  

  
  
   
     
    

  

    Re: NULL checking in Derby
  


  

     country flaguser name
United States		
     2007-10-26 20:35:43
  


  

    
Soumen Saha wrote:
> 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...

Hi Soumen,

I'm afraid I don't know the answer.

I recommend you try asking on derby-userdb.apache.org. I think you
will find a lot more people on that list who know about
Derby.

thanks,

bryan




  


  

    
  

  
  
   
     
    

  

    Re: NULL checking in Derby
  


  

     user name

     2007-10-26 21:37:22
  


  

    

  


  

    Hi Brayan,

Could you do in another way? My aim is to delete all the rows where the OPTION_TEXT is empty..

Regards,
Soumen

On 10/26/07, Bryan Pendleton

 < bpendletonamberpoint.com">bpendletonamberpoint.com> wrote:

Soumen Saha wrote:
>; DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN ('';,null);
&gt;
> 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...

Hi Soumen,

I'm afraid I don't know the answer.

I recommend you try asking on  derby-userdb.apache.org">derby-userdb.apache.org. I think you

will find a lot more people on that list who know about Derby.

thanks,

bryan



  

  
  
   
     
    






 [1-3]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )