[ python-Bugs-1475080 ] example code in what's new/sqlite3 docs

[SourceForge.net]

Bugs item #1475080, was opened at 2006-04-23 12:51
Message generated for change (Comment added) made by akuchling
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1475080&group_id=5470

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Documentation
Group: Python 2.5
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: James Pryor (jpryor68)
Assigned to: A.M. Kuchling (akuchling)
Summary: example code in what's new/sqlite3 docs

Initial Comment:
The documentation at
<http://docs.python.org/dev/whatsnew/node15.html#SECTION0001540000000000000000>

contains the following example code:

<code>
# Never do this -- insecure!
symbol = 'IBM'
c.execute("... where symbol = '%s'" % symbol)

# Do this instead
t = (symbol,)
c.execute('select * from stocks where symbol=?', ('IBM',))
</code>

The second block should instead read:

<code>
# Do this instead
t = ('IBM',)
c.execute('select * from stocks where symbol=?', t)
</code>


----------------------------------------------------------------------

>Comment By: A.M. Kuchling (akuchling)
Date: 2006-04-26 08:25

Message:
Logged In: YES 
user_id=11375

Fixed in SVN; thanks for pointing this out.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1475080&group_id=5470