On 6/21/07, Tim Roberts <[EMAIL PROTECTED]> wrote:
> Can you see any pattern to the rows that are missing? The query seems
> simple enough.
>
Well there were a lot of old-style wildcards in the subqueries (using
* instead of %).
>From Access, the query is run using the sql-89-esque syntax. From
On 6/21/07, Graeme Glass <[EMAIL PROTECTED]> wrote:
>
> If your not forced to use Access, I would suggest looking at sqlite
> (built-in in python2.5 onwards), or available as 3rd party module in
> versions 2.4 and below
>
Access is the only option for this project as this is a legacy
database wi
Hi all,
I'm using Access 2000 .mdb as a backend to my python script and am
seeing some inconsistencies in the results.
If I run the script below, I get 15 rows.
If I run the SAME EXACT query directly in MS Access, I get 12 rows.
Perhaps relevant to the issue - the table referenced in the quer
