Is there an alternative to using ( ’ ) in pub:execSQL? Here’s an example, the $dbSQL has the following informaiton -
insert into table_A ( field_1, field_2, field _3 )
values ( ‘%value one%’, ‘%value two%’, ‘%value 3%’)
An error will occur if a user types something like “I can’t use this word or don’t becuase it causes an error”. If values one, two or three contains ( ’ ) in it, it kills the SQL. Is there a way around this? Thanks.