pyodbc - problem passing None as parameter

Tim Golden mail at timgolden.me.uk
Fri Oct 23 11:30:00 CEST 2009


Frank Millman wrote:
> Thanks, Tim, for the detailed explanation. I appreciate your taking the 
> time.
> 
> It was difficult for me to use the code that you posted, because under my 
> present setup I define my SQL statements externally, and the WHERE clause 
> has to conform to one or more rows of six columns -
>     Test (WHERE or AND or OR)
>     Left bracket (either present or blank)
>     Column name
>     Operator
>     Expression
>     Right bracket (either present or blank)
> 
> I therefore used the workaround that I mentioned above, and it seems to work 
> fine, for both pyodbc and psycopg2.

I'm glad you managed to get something working. :)
I do similar things when needs be, being
more of a pragmatist than a purist most of the time.

(The should-NULL-be-special debate is occasionally
as fiery in the SQL world as the should-self-be-automatic
or tabs-or-spaces quesetions are in the Python world).

TJG



More information about the Python-list mailing list