Re^9: Writing NULL values to a MySQL record via DBI

You are welcome. Thank you in return for simply having the desire to write more secure (and maintainable) code. :)

If you have more questions i recommend starting a new thread tomorrow, and reference this one to let others know what advice has been given so far. Good luck!

Comment on Re^9: Writing NULL values to a MySQL record via DBI

Replies are listed 'Best First'.
Re^10: Writing NULL values to a MySQL record via DBI by ureco (Acolyte) on Feb 27, 2015 at 16:36 UTC
It worked, :o) the values that are not defined in the CSV file are now being written as NULL's in the database. Huge thanks, I need to read up on what exactly the second variable (containing the undef) is doing, I think I get the rest of it, but most of the simple examples only show a like for like match on the placeholders to the variables. But, that is for additional knowledge - my immediate problem is resolved.	[reply]

Replies are listed 'Best First'.

Re^10: Writing NULL values to a MySQL record via DBI
by ureco (Acolyte) on Feb 27, 2015 at 16:36 UTC

It worked, :o) the values that are not defined in the CSV file are now being written as NULL's in the database. Huge thanks, I need to read up on what exactly the second variable (containing the undef) is doing, I think I get the rest of it, but most of the simple examples only show a like for like match on the placeholders to the variables. But, that is for additional knowledge - my immediate problem is resolved.

[reply]