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
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
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
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
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
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:
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
