' 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 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) and with the
> question mark it gets entered as a funky block that,
> when read from mysql and printed by perl, is "NULL".
> This is probably more of a MySQL question than perl
> but I haven't been able to find anything in any of the
> MySQL documentation about it so I'm not so sure.
>
> I've currently sidestepped the problem by using the
> HTML special character notation (the text is HTML
> content) but it's a duct-tape/coat-hanger solution
> that doesn't work for me in the long term.
>
> Any help is appreciated.
>
> _42
>
> __________________________________________________
> Do You Yahoo!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
S/MIME Cryptographic Signature
