Interesting problem comparing strings with integer values...
bokr at oz.net
Thu Jan 16 10:21:44 CET 2003
On 15 Jan 2003 18:29:54 -0600, Chris Spencer <clspence at one.net> wrote:
> The comparison will not be done inside of a Python interpreter, but in
>an SQL statement. ie...
>select blah from table where value>"999" and value<"3432";
>We're storing arbitrary data in text blobs, so we can't make "value" above an
Does your SQL not have a "convert" from text to integer or float, so you can
write a conversion/comparison expression in SQL while storing only text?
Depending on your SQL, you might be also able to define an SQL view
that makes certain text fields or sub-strings thereof look like number columns
for purposes of SELECT.
More information about the Python-list