Thursday, April 26, 2007

Quick SQL

I'm almost embarrassed to admit this, I didn't know how to escape a quote (') in a sql string when doing an insert, 'hors d'ouvres'. My only consolation was that my hunch was right, double up the single quote within the string: 'hors d''ouvres'. Just like it!

No comments: