hi all,
i have a problem with queries using lotus.jdbc.domino
it seems that the query must absolutly repect caps and non caps.
for example : (where TEST is a view)
if i make a search for a string like this "Valbone"
and if my query is like this : SELECT myString form TEST WHERE (myString LIKE 'v%') it returns no results.
i must absolutly use : SELECT myString form TEST WHERE (myString LIKE 'V%') (with V in stead of v)
in the same way, if my query is SELECT myString form TEST WHERE (myString LIKE 'A%') it will return no results until my query is SELECT myString form TEST WHERE (myString LIKE 'a%')
what's the problem ? is it because of the Lotus Domino Driver for JDBC? (as i know that this driver already have problems with non english car...)
any idea ?
Best regards X-),
Elise
i have a problem with queries using lotus.jdbc.domino
it seems that the query must absolutly repect caps and non caps.
for example : (where TEST is a view)
if i make a search for a string like this "Valbone"
and if my query is like this : SELECT myString form TEST WHERE (myString LIKE 'v%') it returns no results.
i must absolutly use : SELECT myString form TEST WHERE (myString LIKE 'V%') (with V in stead of v)
in the same way, if my query is SELECT myString form TEST WHERE (myString LIKE 'A%') it will return no results until my query is SELECT myString form TEST WHERE (myString LIKE 'a%')
what's the problem ? is it because of the Lotus Domino Driver for JDBC? (as i know that this driver already have problems with non english car...)
any idea ?
Best regards X-),
Elise