Hi, I am trying to insert a record in the access table, the value has a quote and could not insert the record. Any idea how I can insert records like this quotes.
Thanks S cursor.execute("INSERT INTO PicsPostInfo(Pics_name) values ('Site Name's Harbor.JPG')") Traceback (most recent call last): File "<interactive input>", line 1, in <module> ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Site Name's Harbor.JPG')'. (-3100) (SQLExecDirectW)") We value your opinion. Please take a few minutes to share your comments on the service you received from the District by clicking on this link<http://my.sfwmd.gov/portal/page/portal/pg_grp_surveysystem/survey%20ext?pid=1653>.
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor