Can anyone tell me why this bit of code is not working?
[code]statdata = system.db.runPrepQuery(“select stationNum, stationPre, stationName from stationlist where stationnum = ?”,[stationNum],database = myDB)
rtData = system.db.runPrepQuery(“select %s , %s, %s, %s from WWater where t_stamp Between ‘9/10/2011 0:00:00’ and ‘9/11/2011 0:00:00’” % (dailyRt,dailySrt,totRt,totSrt),database = myDB)
Running it gives me an attribute error on extend. With debug prints I have confirmed that the queries are returning the expected values now I just need to concatenate the lists.
My end game is to iterate through 22 stations and create a data set with 7 columns from the two queries above and 22 rows for a daily runtime report.