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

Reply via email to