A small question.
One of my queries is not running correctly with this driver. The where clause is this...
WHERE tblWebGroups.acronym LIKE "*.RU.*"
...which does not match the string "FDG.RU.MAIN.40Scanner-Personal"
I have tried other wildcards % etc, but does not work.
|
It should be WHERE tblWebGroups.acronym LIKE '%.RU.%'
|
As I said in my previous email, I have tried different wildcards...
tblWebGroups.acronym LIKE '%.RU.%' does not work.
This works fine using the old jbdc odbc driver, but not your driver.
The field I am trying to match contains values like:
FDG.RU.MAIN.40Scanner-Personal
The pattern 'FDG.RU.%' does match
The pattern '%.RU.%' does not match
Please advise
|
|
Thanks. v3.1.051 fixed a bug for utilizing index on LIKE '%'. It will be available in 24 hours.
|
Main
webmaster@hxtt.com