Hey List,<br><br>I have a problem I'm trying to run this piece of code inserting values to a row in a mysql database where "post_content" is type longtext: <br><br> my $sth1=$dbh->prepare("INSERT INTO wp_posts(post_author, post_date, post_date_gmt, p
<br>ost_content,post_title, post_status, comment_status, ping_status,post_name, post_modified, po<br>st_modified_gmt,guid)<br> VALUES('$post_author','$post_date','$post_date_gmt','@post_content','$post_title','$p<br>
ost_status','$comment_status','$ping_status','$post_name','$post_modified','$post_modified_gm<br>t','$guid')") or die; # "Couldnt prepare statement: " . dbh->errstr;<br> my $rv1 = $sth1->execute();
<br><br>But I'm trying to insert text file to post_content and showing this error when I ran the script:<br><br><br>BD::mysql::st execute failed: You have an error in your SQL syntax; check the<br>manual that corresponds to your MySQL server version for the right syntax to
<br>use near 't know what a CHM file isNULL Just think of the Help program that<br>comes up when ' at line 2 at posting.pl line 75.<br><br><br>But if replace the text file for a string on @post_content I have no error running the script. Any ideas or suggestions of what I'm doing wrong?
<br><br>Thanks,<br>Luis<br><br>