Re: Insert or Update a path from textbox...

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: <david(dot)catasus(at)1as(dot)es>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Insert or Update a path from textbox...
Date: 2010-05-31 22:33:35
Message-ID: BC0CC8CD-2393-4B92-94C1-008FA3C752B6@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 31 May 2010, at 23:27, <david(dot)catasus(at)1as(dot)es> wrote:

> Hi,
>
> I'm just try to insert or update an actually table with Microsoft .NET platform VS2005.
>
> The problem is that de "\" dissapear when I make the insert or Update.

Postgres is interpreting those backslashes as escape characters. Either escape them or turn on standard_conforming_strings.

That said, if you're having this problem your queries are probably vulnerable to SQL injection too, they're certainly not parameterised or Postgres would have done the escaping for you.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.

!DSPAM:737,4c04394a10151125916774!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2010-05-31 22:56:36 Re: Installing version 8.4
Previous Message david.catasus 2010-05-31 21:27:35 Insert or Update a path from textbox...