>> , Access can retrieves a not empty recordset but my python code
>> retrieves a empty recordset.
>
> Which is exactly what it _should_ return on that query, unless you have
> records with "e*" in column field1.
>
> The proper SQL clause is:
>
> ... WHERE field1 LIKE 'e*' ...
which would also return an empty recordset unless the OP has
records with "e*" in column field1...
the proper SQL clause would be
... WHERE field1 LIKE 'e%' ...
(in SQL, the "%" and "_" are used as wildcards, not asterisk and
question-mark respectively as they are in most shell expansions)
:)
-tkc
--
http://mail.python.org/mailman/listinfo/python-list
