Re: DBD::SQLite select fails

[GrandFather]

Not an answer to your question, but if you are starting out with databases you may find Databases made easy helpful. See also the other offerings in the Database Programming section of the Tutorials.

[bulrush]

Thank you. I understand databases just fine. But I assume different flavors of SQL escape different sets of characters, and sometimes do it differently. That was one of my questions.

Not all flavors of SQL adhere 100% to any given SQL spec.

[bulrush]

What I meant was, over the years I find subtle differences in flavors of programming, string escapes, regex, and SQL, they are not all the same. So my assumption was what needs to be escaped in SQLite may not be the same as other flavors of SQL, and a Google search did not help me either.

I've used a few languages that claim to adhere to XYZ standard, but they don't do it 100%, so reading standards is usually a waste of my time. I look for specific documentation on the flavor of X I'm using at the moment.