Still not working …. Could it be the length of the string?
This is the searched for String - pi_1G0qENIo1HLeQd0O7rTZlOAx This is the database Varchar - pi_1G0qENIo1HLeQd0O7rTZlOAx I have this in my connection Dictionary - useUnicode=true&characterEncoding=UTF-8 The database is configured for UTF-8 and the column has this Collation - utf8_general_ci The search for string is returned from a POJO Any other ideas? > On 14 Jan 2020, at 12:59, Gino Pacitti via Webobjects-dev > <webobjects-dev@lists.apple.com> wrote: > > Thanks Pierre > > I will test this out… > > > >> On 14 Jan 2020, at 12:57, GILQUIN Pierre <pierre.gilq...@hcuge.ch> wrote: >> >> Yes strange >> >> A case issue ? May be try Transaction.PAYMENTINTENTID.ilike() >> Or a encoding utf8/iso issue … >> >> >> >> De : Webobjects-dev >> [mailto:webobjects-dev-bounces+pierre.gilquin=hcuge...@lists.apple.com] De >> la part de Gino Pacitti via Webobjects-dev >> Envoyé : mardi 14 janvier 2020 13:34 >> À : WebObjects-Dev Mailing List List >> Objet : Re: Failed Query >> >> Thanks I will give it a go… >> >> Funny thing is that the ‘old’ code works and then just on occasion does not… >> >> >> >> >> >> >> On 14 Jan 2020, at 12:25, GILQUIN Pierre via Webobjects-dev >> <webobjects-dev@lists.apple.com> wrote: >> >> Hi, >> >> I Dont know if your old style qualifier is correct, so you may try something >> like this with the corresponding ERXKey : >> myQual = Transaction.PAYMENTINTENTID.eq(paymentIntentID) ; >> >> De : Webobjects-dev >> [mailto:webobjects-dev-bounces+pierre.gilquin=hcuge...@lists.apple.com] De >> la part de Gino Pacitti via Webobjects-dev >> Envoyé : mardi 14 janvier 2020 13:04 >> À : WebObjects-Dev Mailing List List >> Objet : Failed Query >> >> Hi >> Anyone had experience of queries that should return an object as the row >> exists but EOF throws a NoSuchElementException? >> >> This is some code: >> >> >> Transaction transactionEo = >> QueryDatabase.TransactionForPaymentIntentIdQuery(customCharge.getPayment_intent(), >> _ec); >> >> >> public static synchronized Transaction >> TransactionForPaymentIntentIdQuery(String paymentIntentID, EOEditingContext >> _ec) throws NoSuchElementException { >> >> >> NSArray<String> args = new NSArray<String>(new String[]{ >> paymentIntentID }); >> EOQualifier myQual = >> EOQualifier.qualifierWithQualifierFormat("purchaseIntentId = %@", args); >> >> log.info("Qualifier " + myQual); >> >> >> return Transaction.fetchRequiredTransaction(_ec, myQual); >> >> } >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/ginokris%40mac.com >> >> This email sent to ginok...@mac.com > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/ginokris%40mac.com > > This email sent to ginok...@mac.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com