(BRIAN) [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 16, 2004 10:33 AM
To: dbi-users@perl.org
Subject: Perl DBI Documentation Proposal: Using NULLs in Placeholders
Fellow DBI Users,
Tim Bunce has asked me to help revise the NULLs subsection in the "Placeholders
and Bind Values&qu
Suggested changes {before : after}.
On 12/16/2004 09:33 AM, CAMPBELL, BRIAN D (BRIAN) said:
Undefined values, or C, are used to indicate NULL values.
You can insert {: or} update columns with a NULL value as you would a
non-NULL value. These examples insert and update the column
C with a NULL valu
Fellow DBI Users,
Tim Bunce has asked me to help revise the NULLs subsection in the "Placeholders
and Bind Values" section in the DBI documention for DBI 1.47. Attached is the
proposed text to be included, along with an associated perl script. You are
invited to review them. Please send comm
CAMPBELL, BRIAN D (BRIAN) wrote:
$sth = $dbh->prepare("CREATE TABLE $tablename (key int, mycol char(8))");
You might want to change the name of the first column since KEY is a SQL
keyword and some databases will reject it. That might also apply to the
NAME column in your examples.
--
Jeff
