[ADMIN] Re:

1998-11-30 Thread Bill Cunningham
Ken Wills wrote: > Hi! > > I have an annoying problem, that I just haven't been able to get around yet. When I >parse the > input from a form and go to insert it eveything works fine as long as the user >doesn't use > the ' character in the input. I've tried using qw{} and qq{}, which either do

Re: [ADMIN] Re:

1998-11-30 Thread Terry Mackintosh
Hi Ken, Bill and all Na! First, as a web interface you should be using PHP 3.x, you are right? OK, that said, do this: $chktext = ereg_replace("'", "''", $chktext); That will take every ' in the data, and replace it with '' (2 ') which is how you escape a ' in PostgreSQL (and all SQL?). Hope t

Re: [ADMIN] Re:

1998-11-30 Thread The Hermit Hacker
On Mon, 30 Nov 1998, Terry Mackintosh wrote: > Hi Ken, Bill and all > > Na! > First, as a web interface you should be using PHP 3.x, you are right? Actually, my personal preference is perl for web interfaces *shrug* Marc G. Fournier Systems Administrato