Обсуждение: Rewriting queries?

Поиск
Список
Период
Сортировка

Rewriting queries?

От
Phil Davey
Дата:
I'm using Postgresql 7.0 on debian linux.
I have a program running on a windows box which comes in two parts.
The first part creates the necessary tables and writes the information to
them. The second part is supposed to analyze the info in these tables.
(It's actually Resource Management, part of Citrix Metaframe)

The problem is, the analysis part is sending queries in the wrong format.
Things like backslashes, quotes are either missing or in the wrong place.
An example is 'c:\', the backslash confusing the database.
'c:\\' seems to work.

This analysis program is self contained and I have no way of finding, let
alone fixing these queries.

Is there any way to have these queries automatically fixed along the way
somewhere?

Thanks for any help.
--
Phil Davey
http://www.pod-designs.net/philandjo.html
E-mail pod@pod-designs.net                          ICQ 46295740
Just because you're smart, doesn't mean you can't act stupid....