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
- re: Accessing last_insert_id problem. Jeff Snoxell
- re: Accessing last_insert_id problem. Wico de Leeuw
- Re: Accessing last_insert_id problem. Michael T. Babcock
- re: Accessing last_insert_id problem. Paul DuBois
- re: Accessing last_insert_id problem. Jeff Snoxell
- re: Accessing last_insert_id pro... Wico de Leeuw
- thread_cache . what is it ? (no ... cristian ditoiu
- Re: thread_cache . what is it ? ... Benjamin Pflugmann
- Re: Accessing last_insert_id problem. Paul DuBois
- Re: Accessing last_insert_id problem. Matthew Smith
- Re: Using Perl DBI quote() method with NULL v... Jeff Snoxell
- Re: Using Perl DBI quote() method with NU... Paul DuBois
- Re: Using Perl DBI quote() method with NU... walt
- Re: Using Perl DBI quote() method with NU... Keith C. Ivey
- Re: Using Perl DBI quote() method with NU... Rodney Broom
- Re: Using Perl DBI quote() method with NU... Salam Baker Shanawa
- Re: Accessing last_insert_id problem. Jeff Snoxell
- Re: Accessing last_insert_id problem. Paul DuBois
- RE: Accessing last_insert_id problem. Will Merrell
- Badly placed ()'s and also access denied Gary Hostetler
- RE: Badly placed ()'s and also access den... Jennifer Goodie