Docunext Technology

I’m trying to get prepared queries to take an order by sort parameter, either ASC or DESC. The problem I am running into is that both ASC and DESC are not integers, but the shouldn’t get quoted when passed to the database. I’ve gotten around this in the past by calling it an integer, but I guess MDB2 checks the type (no it doesn’t). Argh. I’m looking at bindValue or bindParam as a possibility, but I don’t think that will work.

From what I’ve gathered, MySQL simply doesn’t support wildcard substitution of the ASC or DESC keywords. That’s kind lame, but I imagine it was a “bug” in metabase that allowed me to do it before.

Docunext is a website focused on plain, old fashioned documentation, technical notes, and how-to’s. However, that doesn’t mean we can’t feature some artwork. All artwork featured here is copyright the original artist, and may not be used without permission.