python sql query single quote in a string

[mg24]

Hi Team,

I am extracting sql table data via python , while extracting data , portfolio contains single quote in its records.


hence my second select query is not working. due to single quote in strings portfolio.
how to handle dynamically.

and portfolio = ‘xx_xxxxx_spread_jun’22’ <-------------‘22’ issue here.


select * from customer.table1 where
MarketDate = '2022-06-30-00:00:00'
and portfolio = 'xx_xxxxx_spread_jun'22'


clubbing sql records and header into variable Info.

1) first query.

result = cursor.execute(qr1)
for idx,row in enumarate(result,start=1)
	info = dict(zip(hd,row))

	qry2 = 
		"""select * from {database}.[dbo].[{tbl}] where
		[MarketDate] = '{info[MarketDate]}'and
		[Portfolio] = '{info[Portfolio]}"""


2) second query.
	output2 = cursor.execute(qr2)  <------- unable to execute query2

[deanhystad]

What is the error message? Can you print out qr2 so we can see the query.