MappingSqlQuery with parameters(Simple question)

[oober]

I would like to do the following query but it fails.

select * from table where field like '%?%'

where ? is the parameter

The problem is that when the parameter is in quotes Spring can't see it and complains about missing parameters.

How would I do this query?

[ErikFK]

Hi,

I would like to do the following query but it fails.

select * from table where field like '%?%'

where ? is the parameter

The problem is that when the parameter is in quotes Spring can't see it and complains about missing parameters.

How would I do this query?

How about simply adding "%" in front of and at the end of the parameter before passing it to the query? This is the way we did it - and I think this is the "right" way to do it.

Erik

[oober]

Lol Thanks

The simple things are getting so difficult these days hehe :shock: