On 8/25/10 3:09 PM, Jeff Johnson wrote: > What is wrong with the statement below? > > Traceback (most recent call last): > File > "C:\Python25\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line > 312, in RunScript > exec codeObject in __main__.__dict__ > File "D:\_vfp7dev\Dpwin\pdf\dpwin2pdf.py", line 27, in<module> > cur.execute(cheader % item) > File "D:\dabo\db\dCursorMixin.py", line 332, in execute > raise dException.DBQueryException(errMsg, sql) > DBQueryException: no such column: '0003110', '08/17/2006', '07', '00', > '60', '0.0', '0', '0.000000', '0.00', 'Y', 'N', 'N', 'N', '08/17/2006', > '20060817', '004011', '1', '1480', '', '', '/ / : :', '112977', > ' ', '0003110', 'Login/Paperwork' > > > > SQL: insert into dctemp (employee, paydate, payevent, paycode, paymins, > paymiles, payquant, payrate, payamount, team, trainer, trainee, > routepro, trandate, tripdate, tripno, tripq, tripseq, routeid, edituser, > edittime, iddcpay, status, namesort, codesort) values (['0003110', > '08/17/2006', '07', '00', '60', '0.0', '0', '0.000000', '0.00', 'Y', > 'N', 'N', 'N', '08/17/2006', '20060817', '004011', '1', '1480', '', '', > '/ / : :', '112977', ' ', '0003110', 'Login/Paperwork']) > > Is it the list of values? How do I turn ['0003110','08 ...... ] into > '0003110',08.....
Yes, you need to convert your list into a string. But now I have a few questions: + Who/what is generating this SQL? + What is making this go through pywin.RunScript? + Do you really mean for all those fields to be string type? Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
