• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Failed Query
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Failed Query


  • Subject: Re: Failed Query
  • From: Gino Pacitti via Webobjects-dev <email@hidden>
  • Date: Tue, 14 Jan 2020 14:26:41 +0000

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
> <email@hidden> wrote:
>
> Thanks Pierre
>
>  I will test this out…
>
>
>
>> On 14 Jan 2020, at 12:57, GILQUIN Pierre <email@hidden> 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=email@hidden] 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
>> <email@hidden> 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=email@hidden] 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      (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Failed Query
      • From: OCsite via Webobjects-dev <email@hidden>
References: 
 >Failed Query (From: Gino Pacitti via Webobjects-dev <email@hidden>)
 >RE: Failed Query (From: GILQUIN Pierre via Webobjects-dev <email@hidden>)
 >Re: Failed Query (From: Gino Pacitti via Webobjects-dev <email@hidden>)
 >Re: Failed Query (From: Gino Pacitti via Webobjects-dev <email@hidden>)

  • Prev by Date: Re: Failed Query
  • Next by Date: Re: Definitely solved: More SharedEC woes: relationships into SEC not saved with more EOF stacks
  • Previous by thread: Re: Failed Query
  • Next by thread: Re: Failed Query
  • Index(es):
    • Date
    • Thread