Re: A Quick MySQL Question

2010-05-27 Thread Victor Subervi
On Thu, May 27, 2010 at 1:37 PM, Dennis Lee Bieber wlfr...@ix.netcom.comwrote: On Wed, 26 May 2010 08:29:21 -0400, Victor Subervi victorsube...@gmail.com declaimed the following in gmane.comp.python.general: valueList = (%value1, %value2, %value3) If I'd coded it correctly, there

Re: A Quick MySQL Question

2010-05-26 Thread Victor Subervi
On Wed, May 26, 2010 at 2:42 AM, Dennis Lee Bieber wlfr...@ix.netcom.comwrote: I was, for that example, assuming that the user input values was being used in a select query and hence wrapped it with wildcard markers so that the phrase would match anywhere in the data field. In said thread

Re: A Quick MySQL Question

2010-05-25 Thread Victor Subervi
On Tue, May 25, 2010 at 3:50 AM, Dennis Lee Bieber wlfr...@ix.netcom.comwrote: On Mon, 24 May 2010 13:37:58 -0400, Victor Subervi victorsube...@gmail.com declaimed the following in Parameterized queries process the parameters to ensure that they are safe for use in the SQL statement.

A Quick MySQL Question

2010-05-24 Thread Victor Subervi
Hi; I have the following: #sql = 'alter table %s alter column %s set default %%s;' % (store, col) #cursor.execute(sql, colValue) cursor.execute('alter table %s alter column %s set default %s;' % (store, col, colValue)) database.commit() Now I don't like that third