I originally posted this as plain text, but the blog software stripped out important characters, meaning everyone had to clean it up.

So I finally cleaned up the external references w/in the original file and zipped it up.  Such a shame that WordPress.com won’t host a zip file!

Here’s the file hosted on MediaFire.com, a nice free hosting site.  Just click the “Click here to start download..” link above the ad.

If that download link doesn’t work, try the direct link.

Someone commented that this has trouble handling the IN clause, but it seems to work fine for me.  Please let me know if you find any bugs or have improvement suggestions.

Stew

p.s. Sorry if Mediafire changes the URL (again!)

8 Responses to “apex_ir_query package”


  1. [...] the package.  Let me know if you find it useful or have suggestions to [...]

  2. Dietmar Aust Says:

    Hi Stew,

    I am really interested in your solution, could you please send me the code? Or make the package downloadable? In your blog post the package is somewhat messed up due to the html conversion of special characters.

    Thanks,
    ~Dietmar.

  3. Stew Says:

    Dietmar,

    Thanks for the interesting in the solution.

    Sorry for the obfuscation caused by the HTML. I’ll post a zip file soon.

    Stew

  4. Paulo Vale Says:

    Stew,
    I’d also like to see this working.

    Thanks

  5. Tim Says:

    Is the zipped package available for download, I’m amped to try this solution?

  6. Tyson Jouglet Says:

    You also make a reference to aeo_misc_tools.string_is_valid_date() from within this package. So you are going to have some dependency issues…

  7. stewstryker Says:

    Tyson,

    Yes, sorry about that! I published this without checking for any local code dependencies. That function call is to simply check if the incoming string is a valid date. In the case of my application, the format is mm/dd/yyyy.

  8. cl3ft Says:

    Can you please repost your zip file the link to mediafire is broken.

    Thanks a million

    cl3ft


Leave a Reply