Subject Apostrphe within single quotes
Author Jack Cane, PhD
Suppose a user's input contains a search string like O'Rourke. The resulting
query would then contain the qualifier, ".where Last_Name containing (or =)
'O'Rourke'. To avoid a SQL error, this needs to be changed to 'O''Rourke'.
The obvious solution is simply to advise the user to add the second
apostrophe manually. To try and avoid that, I have played with this a bit,
but cannot find my way out of the semantic box created by the ambiguity
between the apostrophe in the name and the ending single quote. Wondered if
any of you know of a solution.

tks,

jwc



[Non-text portions of this message have been removed]