=======================case1==============================: import sqlalchemy test1 = "631f2f68-8731-4561-889b-88ab1ae7c95a" cmdTest1 = "select * from analyseresult where uid = " + test1 engine = sqlalchemy.create_engine("mssql+pyodbc://DumpResult:123456@localhost/DumpResult") c = engine.execute(cmdTest1) ======================case2===============================: import sqlalchemy test2 = "123" cmdTest2 = "select * from analyseresult where uid = " + test2 engine = sqlalchemy.create_engine("mssql+pyodbc://DumpResult:123456@localhost/DumpResult") c = engine.execute(cmdTest1)
!!!!! case1 :wrong,(sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'f2f68') case2:work! -- http://mail.python.org/mailman/listinfo/python-list