Re^2: DBD::MySQL bind variable error


We don't bite newbies here... much
	PerlMonks

Re^2: DBD::MySQL bind variable error

by UnderMine (Friar)

on May 12, 2006 at 22:04 UTC ( [id://549125]=note: print w/replies, xml )

Need Help??

in reply to Re: DBD::MySQL bind variable error
in thread DBD::MySQL bind variable error

Something like this at the start

$command='insert into mailstore.received (SenderName,SenderEmailAddres
+s,SentOnBehalfOfName,ReplyRecipientNames,SenderEmailType,SentOn,Recei
+vedTime,MessageClass,Size,Subj,SentTo,Unread,InternetCodepage,importa
+nce,EntryID,ConversationIndex,ConversationTopic,Class,BodyFormat,Body
+) values (?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,?)';
$sth=$dbh->prepare($command);
[download]

and in the loop

@values= map $msg->{$_}, qw{SenderName SenderEmailAddress SentOnBehalf
+OfName ReplyRecipientNames SenderEmailType SentOn ReceivedTime Messag
+eClass Size Subj SentTo Unread InternetCodepage importance EntryID Co
+nversationIndex ConversationTopic Class BodyFormat Body} ;

$rv=$sth->execute(@values);
[download]

UnderMine