Subject | missing WHERE |
---|---|
Author | Francesco Lamonica |
Post date | 2003-12-01T12:07:13Z |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I just noticed that my app (written in C++ and connecting to FB using the API)
submitted a query like:
SELECT field1 FROM table1 join table2 on (table1.field2=table2.field2) AND
condition1 AND condition2;
i forgot to change the first AND to a WHERE keyword and the query worked
perfectly.
FB1.0.3 on Linux
is that normal?
thanks
- --
Francesco Lamonica: f DOT lamonica AT tin DOT it
PGP Fingerprint: 5870 92BA 8DFF 1ACF DE2E B94D 46EC 5505 7C64 4EF1
Favourite quote: There's no spoon
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQE/yy7xRuxVBXxkTvERAoblAJwPARKa81l9O79l3R1QNr96ofRuWACg/mZV
VsghQI5eMCz9lFs9XQG+ACg=
=1TAG
-----END PGP SIGNATURE-----
Hash: SHA1
I just noticed that my app (written in C++ and connecting to FB using the API)
submitted a query like:
SELECT field1 FROM table1 join table2 on (table1.field2=table2.field2) AND
condition1 AND condition2;
i forgot to change the first AND to a WHERE keyword and the query worked
perfectly.
FB1.0.3 on Linux
is that normal?
thanks
- --
Francesco Lamonica: f DOT lamonica AT tin DOT it
PGP Fingerprint: 5870 92BA 8DFF 1ACF DE2E B94D 46EC 5505 7C64 4EF1
Favourite quote: There's no spoon
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQE/yy7xRuxVBXxkTvERAoblAJwPARKa81l9O79l3R1QNr96ofRuWACg/mZV
VsghQI5eMCz9lFs9XQG+ACg=
=1TAG
-----END PGP SIGNATURE-----