Re: Special characters from perl to MySQL

2001-10-22 Thread Etienne Marcotte
' needs to be changed to '' (two ') and not backslashed... you should use quote function if it's not numbers it will make sure that you have the right formatting to enter data in your DB Etienne Matt Klicka wrote: > I'm trying to enter data into MySQL and can't seem to > be able to enter the qu

Re: Special characters from perl to MySQL

2001-10-18 Thread Brett W. McCoy
On Thu, 18 Oct 2001, Matt Klicka wrote: > I'm trying to enter data into MySQL and can't seem to > be able to enter the question mark and the quote > characters. I've tried every way of quoting (and > backslashing) I can think of to no avail. With the > quote I get an error from MySQL saying the q

Re: Special characters from perl to MySQL

2001-10-18 Thread Casey West
On Oct 18, 2001 at 04:03 -0700, Matt Klicka took the soap box and proclaimed: : I'm trying to enter data into MySQL and can't seem to : be able to enter the question mark and the quote : characters. I've tried every way of quoting (and : backslashing) I can think of to no avail. With the : quote I

Special characters from perl to MySQL

2001-10-18 Thread Matt Klicka
I'm trying to enter data into MySQL and can't seem to be able to enter the question mark and the quote characters. I've tried every way of quoting (and backslashing) I can think of to no avail. With the quote I get an error from MySQL saying the query was bad (i.e. the query ended at the quote) an