Following is the code I am using to read a row from a mysql table. The name that is in the jTextField_permName text field is 'Schaff's Angus Ranch'. I get an error because of the tick mark in first part of the name. It partially says:
server version for the right syntax to use near 'S ANGUS RANCH'' at line 1
How do I allow the use of punctuation marks in the data? THANKS!