OK, let's say you've got the case where you construct an INSERT
statement to put a new entry into an existing table. But the
formatting is wrong (you're short one field in the entry).
What's the code in perl to catch that problem, assuming you've been using
perl to construct the string and then use the mysql dbi functions to
interface with mysql? (See below).
I start it with:
$db_handle = DBI->connect('DBI:mysql:database=*****_DB;host=mysql;',
'*****', '********', {RaiseError => 1,
AutoCommit => 1});
I then construct the mysql statement (an insert statement) and call:
$db_handle->do($db_input);
Thanks,
--Cindy
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
