[Opensource] is a bug ?

Pierre Mergaux pmergaux at noos.fr
Sat Jan 18 05:27:16 PST 2003


Even if field is numeric DBOject generate a LIKE expression, but for 
example "like 546%" is not accept by SQL
I propose correct the DBOject as is :

                    myStatement.append(" LIKE ");
                    if (oneFieldValue.startsWith("'")==true)
                        myStatement.append(oneFieldValue);
                    else
                    {
                        myStatement.append("'");
                        myStatement.append(oneFieldValue);
                        myStatement.append("'");
                    }

PMX





More information about the Opensource mailing list