[Tutor] New to Python and programming and need suggestion

Daniel Yoo dyoo@hkn.eecs.berkeley.edu
Sun, 7 Jan 2001 03:47:27 -0800 (PST)


> The stuff about '%' is the stuff on string interpolation.  With '%', you
> can build up your SQL statements pretty easily:
> 
>     fname = 'Curtis'
>     lname = 'horn'
>     stmt = """insert into names (first_name, last_name) 
>               values ('%s', '%s')" % (fname, lname)
> 
> is one example.

... err... that is, if I had done it properly.  Oops.  The last line
should have been:

     stmt = """insert into names (first_name, last_name) 
               values ('%s', '%s')""" % (fname, lname)

instead.  I had forgotten to close off the triple quotes.