Using greater/less than signs in where clause

  • Resolved masterslate

    (@masterslate)


    10 years ago

    I can’t figure out a way to put a where clause in a query using < > signs. I’ve tried escaping them, I’ve tried surrounding the query with single quotes and double quotes. Neither worked. I’ve tried using > and %3E and > — none of those worked either. Any ideas on what I could be doing wrong or is this a known limitation?

    Thanks for your great work!

    https://www.ads-software.com/plugins/inline-google-spreadsheet-viewer/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Meitar

    (@meitar)

    Huh, good catch, masterslate!

    Unfortunately, angle brackets within shortcode attributes won’t work, as per WordPress Core Trac ticket:28568. If you manually URL encode the angle brackets as you’ve suggested doing, the result is a double-encoded string which returns a value like %253E because it’s URL-encoding the % in your %3E. So as a simple fix for now, I’m going to issue a patch level release that will manually decode only URL-encoded angle brackets.

    In my testing, this means using %3E for > and %3C for < will work inside this plugin’s shortcode’s query attribute. I’ll update the FAQ, too.

    Look for a release later tonight.

    Plugin Author Meitar

    (@meitar)

    Okay, this was a quicker fix than I thought. Please update to the latest version, 0.6.2.2, I just released a few seconds ago, and let me know how this works for you? Thanks.

    Thread Starter masterslate

    (@masterslate)

    Thanks for the quick turnaround. That seems to have fixed that issue. I do have another issue that I thought might have been caused by this, but apparently didn’t fix it. I’ll open a different ticket for that for tracking purposes.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Using greater/less than signs in where clause’ is closed to new replies.