try:
myQuery ="""your sql code """%( (‘foo’, ‘bar’))
and then
cursor.execute(myQuery)
regards,
Matteo
Il 01/02/2011 18:22, Tom Hawkins ha scritto:
Hi,
I’m trying to
Thanks for all the replies - it's now working fine with ? (after some
delay caused by testing with a single parameter query but forgetting
that the parameter has to be supplied as a single-member list)...
Tom
Tom Hawkins
Principal Scientist
Innospec Inc
Tel: +44 (0)151 356 6197
Fax:
Wow! Glad I joined this list. That fixed the problem. Thanks!
On Tue, Feb 1, 2011 at 10:57 PM, Mark Hammond wrote:
> The best I can think of is that somehow the toolbar states or other
> preferences are causing the problem - try deleting the registry key
> HKEY_CURRENT_USER\Software\Python 2.6
On 1:59 PM, Tom Hawkins wrote:
Thanks for all the replies - it's now working fine with ? (after some
delay caused by testing with a single parameter query but forgetting
that the parameter has to be supplied as a single-member list)...
Tom
*Tom Hawkins*
Principal Scientist
Innospec Inc
T
On Wed, Feb 2, 2011 at 10:42 AM, Mike Driscoll
wrote:
>
> Personally, I use SqlAlchemy for almost all my database work. It takes a
> little longer to learn, but I find it easier to use in the long run.
>
>
Yeah I agree with this. And if you feel the need to work with ODBC
directly, consider the P
Matteo Boscolo wrote:
> try:
> myQuery ="""your sql code """%((‘foo’, ‘bar’))
> and then
> cursor.execute(myQuery)
No, no, no! Don't EVER do that. The whole reason these parameter
substitution schemes exist is because it prevents code like this, which
is open to SQL injection attacks.
The only
Lance Case wrote:
> I’ve installed the standard ‘pywin32-212’ app that comes with ESRI’s
> ArcGIS 10. Pythonwin.exe ran fine for me for a while, but I’ve somehow
> managed to break it. I’m getting “PyWin32 has stopped working”. When I
> check the Event Application log, the error says “Faulting modu
