时间戳

首页 > 解决方案 > DatabaseError: 对 sql 对象执行失败': 要执行的第一个参数必须是字符串或 unicode 查询

python - DatabaseError: 对 sql 对象执行失败': 要执行的第一个参数必须是字符串或 unicode 查询

问题描述

server = "UAT101"
db = "mydb"
con = pyodbc.connect('DRIVER={SQL Server};SERVER=' + server + ';DATABASE=' + db +';Uid=uat101_read;Pwd=*****')

max_week = pd.read_sql("select max(FWEEK) from mytable", con).astype('int')
max_week = max_week.iloc[0].astype('str')

min_week = pd.read_sql("select min(FWEEK) from SOE_DC_ML_8K.dbo.RAWDATA_DC_CONSOLIDATED where FWEEK in (select distinct top 2 FWEEK from mytable order by FWEEK desc)", con).astype('int')
min_week = min_week.iloc[0].astype('str')

query = "Select [FWEEK],[DPS_NUM] from mytable where (fweek = '"+max_week+"' or (fweek = '"+min_week+"' and NEW_DPS_FLG = '1'))"

df = pd.read_sql(query, con)

DatabaseError: 执行失败 sql ' Select [FWEEK],[DPS_NUM],[COMMODITYDESC],[SYST... Name: 0, dtype: object': 要执行的第一个参数必须是字符串或 unicode 查询。

我在执行df = pd.read_sql(query, con)语句时遇到错误

标签： pythonsql-serverpyodbc

解决方案

推荐阅读