CODEWITHSUNDEEP
pythonsql-serverpandasdatabase-cursorrfc1738
Dhruv Kumar
Dhruv Kumar

Reputation: 1

Using panda gives and error, but same command in cursor works

 import pandas as pd
 data_BG2= pd.read_sql("SELECT * FROM [dbo].[Bullgear geometry] WHERE [Bullgear]=?", "3810907-01110", cnxn)

where cnxn is the connection

This is the first time I am using Panda and I keep getting the following error

ArgumentError: Could not parse rfc1738 URL from string '3810907-01110'

This error is only there if a searching for a string in the database. if I search for a float or an integer it works.

If I run it via a cursor like below the exact same code works.

cursor=cnxn.cursor()
cursor.execute("SELECT * FROM [dbo].[Bullgear geometry] WHERE [Bullgear]=?","3810907-01110")

for i in cursor:
    print (i)

Upvotes: 0

Views: 50

Answers (0)

Related Questions