... but not in the case when integers are in a dictionary (please, try to execute your example by yourself first)
"Ola Natvig" <[EMAIL PROTECTED]> wrote: news:[EMAIL PROTECTED] > Maksim Kasimov wrote: > > > > in php-scripts, to insert data to database, i'm doing like this: > > > > ... > > $query_param = array( > > 'field0' => 1, > > 'field1' => 3, > > 'field2' => $var2, > > 'field3' => $var3, > > ); > > ... > > > > $sql = "INSERT INTO $table (".implode(", ", > > array_keys($query_param)).") VALUES ('".implode("','", $query_param)."')"; > > > > how it can be done, using python (elegantly, without cycles)? > > > > > > sql = "INSERT INTO %s (%s) VALUES (%s)" % (table, ','.params.keys()), > ','.join(param.values())) > > should do the trick. > > > -- > -------------------------------------- > Ola Natvig <[EMAIL PROTECTED]> > infoSense AS / development -- http://mail.python.org/mailman/listinfo/python-list
