Using Perl DBI quote() method with NULL values?

[Jeff Snoxell]

Hello,

I've got a mysql table with a lot of fields and I'm using a map statement to pass each of my values for a new record through the quote system so-as to have everything nicely wrapped up. Problem is that I can't find any way of writing a null value to my DB when the value has first passed through quote().

I've tried:

my $err = $MyDatabase->do('INSERT INTO MyTable VALUES(' .
join(",",map($MyDatabase->quote($_),
0, # REF
0, # PARENT REF
$FormData{'Title'} . " " . $FormData{'Name'} . "",
$FormData{'Email'} . "",
"\N", # <-- I REALLY WANT THIS TO BE A NULL VALUE!
etc.,
etc.,
etc.....
)) .
')');

Which works fine except the "\N" isn't entered into my database as a null value. I've also tried '\N' and '' and "".

Any ideas how I can solve this easily?

Thanks,


Jeff

---------------------------------------------------------------------
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