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.....
--
Jeff
-------------------
Jeff Johnson
[email protected]
_______________________________________________
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]
