Hey - I further read more on the quote option and that was totally the wrong direction to fix my problem. I'm trying to add memo's to a database, some memos are way more the 255 characters so I changed the "memo_text" field into a blob columntype instead of "varchar(255) not null." Heres my code:
$time = time;
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime($tim
+e);
$mon++;
$year += 1900;
$memo = "Original Message\n------------\n$INPUT{'memo'}";
$memo_final = $memo . "\n\nCreated by: $username\nDate Created: $year-
+$mon-$mday\n\n";
use DBI;
my $dbh_m = DBI->connect('DBI:mysql:MEMO') or print "Couldn't con
+nect to database: " .
DBI->errstr;
$sql_m = "
INSERT
INTO memo
VALUES
(
'?',
'$year-$mon-$mday',
'$INPUT{'user'}',
'$INPUT{'ref'}',
'$INPUT{'username'}',
'notread',
'$memo_final'
)
";
$sth_m = $dbh_m->prepare($sql_m) or print "preparing: ",$dbh_m->errst
+r;
$sth_m->execute or print "executing: ", $dbh_m->errstr;
$sth_m->finish;
$dbh_m->disconnect;
&header;
print <<EOF;
<B>Memo to $INPUT{'user'} successfully added.</b>
<br>
EOF
&footer;
Now, previously when the column type was "varchar(255) not null" , this insert code worked fine and all memos were added successfully.
But when I altered the table to make it a blob column type this insert code returns a error giving me:
executing: You have an error in your SQL syntax near 've been trying t
+o figure out how come this doesn't work for me. I have a insert ' at
+line 12
Part of that error message is due to the fact that the memo I tried insterting included the sentence 'I've been trying to figure out how come this doesn't work for me. I have a insert '
Thank you,
Anthony |