Re: [JDBC] MS Access to PostgreSQL

On Fri, 2005-03-11 at 17:52 +0000, Brian Gunning wrote:

[rearranged quoting]

> From: pgsql-jdbc-owner(at)postgresql(dot)org
> --- William Shatner <shatner(dot)william(at)gmail(dot)com> wrote:
> > I have recently migrated from MS Access to
> > PostgreSQL.Previously I had
> > a SQL command
> >
> > ResultSet aGroupResultSet =
> > aGroupPathStmt.executeQuery(
> > "SELECT \"groupID\",\"fullpath\" FROM
> > \"groups\" WHERE
> > \"fullpath\" Like '" +
> > aPath + "'");
> >
> >
> > where aPath was equal to 'folder\another folder\%'.
> >

> I don't think the problem isn't with the backslashes. They are escaped and
> seem to be working fine e.g. to insert a backslash in Access I had to use
> one escape character ('\\') whereas in PostgreSQL four backslashes ('\\\\')
> are required. The line that inserts the % is as follows...
>
> String aPath = group.getPath() + aOldGroupName + "\\%";

are the backslashes in group.getPath() + aOldGroupName escaped ?
does aGroupPathStmt.executeQuery() escape backslashes ?

did you print the SQL statement to screen or logfile to make sure
what is actually sent to executeQuery() ?

does your language support placeholders ? this kind of problems are
usually easier to deal with with them.

gnari