Skip to main content
3 events
when toggle format what by license comment
Mar 23, 2015 at 16:35 comment added Phrancis Yes, using prepared statements is a good habit to keep with any DB-accessing code. Remember, database administrators don't deal with bugs, only with regrets!
Mar 23, 2015 at 16:21 comment added Bob Stout As for the case-sensitivity, I had to rewrite part of that query and didn't notice I used both "end" and "End". It reads either the same, but good catch nonetheless. Also, I'm not using PreparedStatements because there's no user interaction in the code -- it's all driven from the database. While it's moot in this case, I probably should default to PreparedStatements just to stay in the habit of using them.
Mar 23, 2015 at 16:16 history answered Mathieu Guindon CC BY-SA 3.0