Just checked the Pg docs, don't see a quote function. What is it part of?
> Are you using the "quote" function? You have to use it if you are to
> guarantee that the data will be acceptable as "input".
>
> $myVar = $myDB -> quote ($myVar)
>
>
>> I'm using the Pg perl interface. But, think my problem was that I
> had
>> unescaped single quotes in the string. Added the following to my
> code to
>> escape them and it works now:
>>
>> $self->{errors} =~ s"'"\\'"g; # escape single quotes
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Randy Perry
sysTame
Mac Consulting/Sales
phn 561.589.6449
mobile email help(at)systame(dot)com