sql, query I'm not sure about perl, but I know in JSP you can substitue ? for values to avoid getting SQL syntax errors from variable values that have funky characters, apostrophes and the like.
I'm not sure if Perl implements the same SQL statement syntax but with php and stripslashes - it's not needed. HTH MS ----- Original Message ----- From: "Keith C. Ivey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Daneman" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 1:45 PM Subject: Re: Question mark becomes NULL > On 24 Feb 2003, at 21:07, Daneman wrote: > > > INSERT INTO MyTable (MyFields) VALUES ($val1, $val2, etc); > > > > Question marks are no longer replaced with NULL values in the text > > column this way, still, when I enter question marks into the charvar > > fields, the record is not taken into he database. I'm not sure whether > > this is a mySQL or a Perl problem at this stage. > > I think it's a user problem, but it's hard to be absolutely sure > because you still haven't posted the exact Perl code you're using, so > I'm having to guess what you're doing. From what you have above it > appears that you are not putting quotes around your strings or > escaping special characters in them, so you're probably getting SQL > errors. Are you getting any error message? Do you have RaiseError > on, or at least PrintError? > > -- > Keith C. Ivey <[EMAIL PROTECTED]> > Tobacco Documents Online > http://tobaccodocuments.org > Phone 202-667-6653 > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
