db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tom_ <tom12...@web.de>
Subject Re: sql query using LIKE
Date Wed, 02 Jan 2008 15:06:06 GMT

Nik-31, thank you for putting this in my question. You should open your own
thread. I still can't re-open the database.

tom_



Nik-31 wrote:
> 
> sweet, that fixed my next problem.. now i just have to get set the JTable  
> properly...
> On Wed, 02 Jan 2008 17:38:46 +0900, Oystein Grovlen  
> <Oystein.Grovlen@sun.com> wrote:
> 
>> Nik wrote:
>>> I'm getting an SQL excpetion using LIKE to match a String.
>>> String query = "SELECT *" +                                           "  
>>> FROM "+ tableName +
>>>                        "WHERE DAY_OF_WEEK LIKE \""+
>>>                        searchTerms+"\"";
>>> is there some other way I should be doing this?
>>
>> You need to use single quotes for the search term, not double quotes.
>>
>> --
>> Øystein
>>
>>
> 
> 
> 
> -- 
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
> 
> 

-- 
View this message in context: http://www.nabble.com/Failed-to-start-database-tp14561205p14579703.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message