-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Yes I tried that and it does not work.
>
> > Which database is this? I have never had Postgres complain about
> > keywords or characters inside a quoted string before! This search is
> > almost certainly ANSI SQL compliant and your vendor has screwed this up.
>
> Oh sorry I should have mentioned that. I am fixing an existing a Visual
> Basic 6.0 interface using ADO through an ODBC driver written by Mini
> soft into an HP3000 server running an IMAGE database. IMAGE is some
> sort of HP proprietary database. What a mix!
MS VB you can use &8888 (whatever the correct code is for those characters
is...) to substitute for escaping them.
Russell
> > If you structure of your partnumber is always the same, you could
> > probably use a LIKE operator to get around this problem (but probably
> > with a BIG performance penalty):
> >
> > SELECT * FROM PRODUCT WHERE PARTNUMBER LIKE '12345%6%';
> >
> > If your partnumbers can vary in structure, this is risky. The above
> > query would also match: 1234579768
> > 12345(16)
> > etc
> >
> > --ronan
>
> Hmmm. Not sure because the part number could be in the database both
> ways. For example:
> 12345(6)
> 123456
> Not sure if that will work but I will try it. Thanks for your
> suggestions! :-)
>
> Regards
> Russ
>
> -----------------------------------------------------------------------
> This list is provided as an unmoderated internet service by Networked
> Knowledge Systems (NKS). Views and opinions expressed in messages
> posted are those of the author and do not necessarily reflect the
> official policy or position of NKS or any of its employees.
- --
Linux -- the OS for the Renaissance Man
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFA1vPUAqKGrvVshJQRAqoGAKDWDyQaglgp1lZMWxmcXlkAl6YJdwCg5jUE
+PVtyrj4wCzCZ3LeZ5S1oHU=
=4/lm
-----END PGP SIGNATURE-----
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 17:58:46 EDT