Re: [pysqlite] Error when using table alias

--===============1644088438==
Content-Type: multipart/alternative; boundary=0016e6476052e57efc04655d7fd8

--0016e6476052e57efc04655d7fd8
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

I just tried the query on the using SQLite shell, and it's returning the
same error as pysqlite.  I should have tried that before posting to this
list.

Sorry for wasting your time.  I will go and post this error to the SQLite
mailing list instead.


On Wed, Mar 18, 2009 at 12:35 AM, Roger Binns <[email protected]> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> mercado wrote:
> > Any ideas?
>
> What happens if you issue the same query using the same version of the
> SQLite shell?  That will narrow whether the cause is pysqlite (unlikely)
> or SQLite.
>
> To grab an older version of SQLite, alter this URL to the desired version:
>
>  http://sqlite.org/sqlite-amalgamation-3.6.11.tar.gz
>
> Roger
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAknAegIACgkQmOOfHg372QR6zACfaOizX2csuShBtZlKVCtan7sj
> FHIAoNAgDAm9FQ7M/ZGvIiXUyrdj4v0a
> =QOjI
> -----END PGP SIGNATURE-----
> _______________________________________________
> list-pysqlite mailing list
> list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
>

--0016e6476052e57efc04655d7fd8
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I just tried the query on the using SQLite shell, and it&#39;s returning th=
e same error as pysqlite.=A0 I should have tried that before posting to thi=
s list.<br><br>Sorry for wasting your time.=A0 I will go and post this erro=
r to the SQLite mailing list instead.<br>
<br><br><div class=3D"gmail_quote">On Wed, Mar 18, 2009 at 12:35 AM, Roger =
Binns <span dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]">rogerb=
@rogerbinns.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" =
style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8=
ex; padding-left: 1ex;">
-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA1<br>
<br>
mercado wrote:<br>
&gt; Any ideas?<br>
<br>
What happens if you issue the same query using the same version of the<br>
SQLite shell? =A0That will narrow whether the cause is pysqlite (unlikely)<=
br>
or SQLite.<br>
<br>
To grab an older version of SQLite, alter this URL to the desired version:<=
br>
<br>
 =A0<a href=3D"http://sqlite.org/sqlite-amalgamation-3.6.11.tar.gz" target=
=3D"_blank">http://sqlite.org/sqlite-amalgamation-3.6.11.tar.gz</a><br>
<br>
Roger<br>
-----BEGIN PGP SIGNATURE-----<br>
Version: GnuPG v1.4.9 (GNU/Linux)<br>
<br>
iEYEARECAAYFAknAegIACgkQmOOfHg372QR6zACfaOizX2csuShBtZlKVCtan7sj<br>
FHIAoNAgDAm9FQ7M/ZGvIiXUyrdj4v0a<br>
=3DQOjI<br>
-----END PGP SIGNATURE-----<br>
_______________________________________________<br>
list-pysqlite mailing list<br>
<a href=3D"mailto:list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org">list-pysqlite=
@lists.itsystementwicklung.de</a><br>
<a href=3D"http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysq=
lite" target=3D"_blank">http://itsystementwicklung.de/cgi-bin/mailman/listi=
nfo/list-pysqlite</a><br>
</blockquote></div><br>

--0016e6476052e57efc04655d7fd8--

--===============1644088438==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
--===============1644088438==--