Inserting Names with apostrophe to a Database Table using Python [duplicate]

Multi tool use
Multi tool use


Inserting Names with apostrophe to a Database Table using Python [duplicate]



This question already has an answer here:



I am encountering an error when trying to insert data into a database using pyodbc.



The error is as follows:



('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL
Server]Incorrect syntax near 'Anthony'. (102) (SQLExecDirectW);
[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed
quotation mark after the character string ')n '. (105)")



The code I am currently using is:


msconn=pyodbc.connect(driver='{Test Server}',
server='TestTest',
database='Test',
trusted_msconnection='yes')
cursor=msconn.cursor()

for index, row in Terms.iterrows():
I1 = 'COLUMNIDENTIFIER'
I2 = row['EID']
I3 = row['Legal Name']

insert_query = """
INSERT INTO Test.Table
VALUES ('{}','{}','{}')
""".format(I1,I2,I3)

cursor.execute(insert_query)

cursor.commit()
cursor.close()
msconn.close()



Checking the source file shows that the cause of the error is a name with an apostrophe. (I3)



Is there a way for me to upload the name with the "'"?



Thanks in advance.



This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.





Don't use format to put values into SQL queries. This is exactly why execute takes additional arguments: to fill in parameters in a static query string. If you do things that way, you don't have to worry about converting them to strings, quoting/escaping, or Little Bobby Tables.
– abarnert
Jul 3 at 4:12


format


execute





If you did need to escape things manually, the MS SQL Server syntax is to put two single quotes in a row, something lik I1.replace("'", "''")—but again, you don't want to do that.
– abarnert
Jul 3 at 4:16



I1.replace("'", "''")




YkGfmR0,yy9WVkPx62yn94U2gk7
-
wqT apZUoj3rw1f6vY7p72x 4CKqt,n,AlQ6eX98R,ay7xbnTg2Dba jC pWSYRr7avxYZz0duqPIdPWpcsMqRzf9QabyxFFlND

Popular posts from this blog

PHP contact form sending but not receiving emails

PHP contact form sending but not receiving emails I have created a contact form using PHP to send the data. The form seems to send fine as there are no errors and success message appears, however I am not receving the emails into the designated inbox. I am using PHPMailer as I originally tried just using the php 'mail' command which I now understand is a bit hit and miss. I cannot see why I would not be receving the emails so I would be very grateful for any help that could be given. I'm quite new to PHP so please be patient with me :) <?php use PHPMailerPHPMailerPHPMailer; use PHPMailerPHPMailerException; $msg = ""; if (isset($_POST['submit'])) { require 'phpmailer/src/Exception.php'; require 'phpmailer/src/PHPMailer.php'; require 'phpmailer/src/SMTP.php'; function sendemail ($to, $from, $body) { $mail = new PHPMailer(true); $mail->setFrom($from); $mail->addAddress($to); $ma...
Read more

Do graphics cards have individual ID by which single devices can be distinguished?

Do graphics cards have individual ID by which single devices can be distinguished? I have several graphics cards of the same manufacturer and same model and I want to distinguish them not only by the pcie socket they reside in but by some individual value I can read from the hardware. Is there such value and if so what would it be called and how could I access it? Right now I'm using modern nvidia cards (10xx series) and nvidia inspector.but I'd prefer if there was any value that was also applicable to amd. I have programming and scripting knowledge. I am running Windows 10 1 Answer 1 This is a powershell example to pull information from video cards. The DeviceID is supposed to be unique but only if the manufacturer supports Windows Display Driver Model (WDDM). (I copied this directly from docs.microsoft.com) $strComputer = "." $colItems = get-wmiobject -class "Win32_VideoC...
Read more

Create weekly swift ios local notifications

Create weekly swift ios local notifications I can create daily notifications but not weekly ones using swift 3 ios 10 User Notifications framework. Daily works fine but when I add in the .weekday parameter it doesn't send me a notification. The code is: for i in 1 ... 7 { let center = UNUserNotificationCenter.current(); let content = UNMutableNotificationContent(); content.title = "Title"; content.body = "content"; content.sound = UNNotificationSound.default(); var dateComponents = DateComponents(); dateComponents.weekday = i; // hours is 00 to 11 in string format if (daynight == "am") { dateComponents.hour = Int(hours); } else { dateComponents.hour = Int(hours)! + 12; } // mins is 00 to 59 in string format dateCom...
Read more