UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Mysql And Apostrophe, Office 2010    
 
   
icemonster
post May 5 2012, 02:16 AM
Post #1

UtterAccess Veteran
Posts: 324
how to handle inserting a string with an apostrophe? i just realized this is actually a problem for me because some names have an apostrophe.

right now this is my value field in the insert:

'" & Me.txtlastname & "'

how to properly quote it to be able to insert a quotation or apostrophe properly?
Go to the top of the page
 
+

Posts in this topic
- icemonster   Mysql And Apostrophe   May 5 2012, 02:16 AM
- - dipetete   You can use Chr(34) (") instead of ('). R...   May 5 2012, 02:49 AM
- - niesz   You'll need to double any existing quotes, so ...   May 5 2012, 06:44 AM
- - icemonster   worked like a charm, perfect.   May 5 2012, 10:18 AM

« Next Oldest · Access Modules · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 10:54 PM