p = ','.join( params )
cmd = "select %s from measures into outfile '/tmp/auto.plt'"
curs.execute( cmd, p )
outputs to /tmp/auto.plt:
scaling,redness,timestamp
scaling,redness,timestamp
whereas if i do
curs.execute( "select scaling,redness,timestamp from measures into outfile '/tmp/auto.plt'" )
/tmp/auto.plt: gives: (which is what i want)
3 1 2007-04-13 23:18:41
\N 1 2007-04-14 23:03:40
try:
p = ','.join( params )
cmd = "select %s from measures into outfile '/tmp/auto.plt'"%p
curs.execute( cmd)