I have a variable that contains a comma seperated listing of between 1 and 8 tanks. I want to run an SQL proceedure for each one. I know I should be able to use split() and loop through the tanks from the list running the proceedure for each one, but I am having difficulty doing it.
Unless you just want moral support, you’re going to have to elaborate
[code]tday = fpmi.db.dateFormat(event.source.parent.parent.dtSelectedDate,“yyyy-MM-dd H:mm:ss”)
tankToList = “803, 804, 914”
for each tank in tankToList
fpmi.db.runupdateQuery(“exec usp.updateTanks ‘%s’,’%s’” % (tank,tday)[/code]
I know the syntax is not correct, but I think it will give you an idea of what I am trying to accomplish. I want to run this SQL procedure for each tank in the list passing it the new tank number and date.
Try the following:
tday = fpmi.db.dateFormat(event.source.parent.parent.dtSelectedDate,"yyyy-MM-dd H:mm:ss")
tankToList = "803, 804, 914"
NewtankToList = string.split(tankToList,',')
for each tank in NewtankToList:
fpmi.db.runupdateQuery("exec usp.updateTanks '%s','%s'" % (tank,tday)
Almost there. The newTankToList has the list of tanks in it, but I get an error on the for loop:
import string Tday = fpmi.db.dateFormat(event.source.parent.parent.dtSelectedDate,"yyyy-MM-dd H:mm:ss") NewtankToList = string.split(tankToList,",") print NewtankToList for each tank in NewtankToList: print tank
Won’t even let me close the code window. It generates the error:
"Unable to register action actionPerformed Parse Error: Traceback(innermost last): (no code object) at line 0 SyntaxError: ('invalid syntax',",29,18,'\tfor each tank in NewtankToList:'))
Sorry, my mistake - there is no “each” keyword. The for loop should be
for tank in NewtankToList:
Just to check, you shouldn’t be indenting the lines after ‘import string’ - the only line you should be indenting is the last one, as it is in the for loop.
That was it. Thanks so much!!