Hi,

here I am again. Unfortunately nobody answered on my last mail while I 
still didn't resolve this problem. So if anyone has an idea.... thanks!

Here is a new problem:

I want to insert data containing characters like < > " @ using DBD::ODBC. I 
quoted every value using $dbh->quote(). But I still get the error 
"[Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in der INSERT 
INTO-Anweisung. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)"

here is my code (in the real script I create this code dynamically, but for 
testing I printed a sample):
        $dbh->do("INSERT INTO rsl (  thread, date_str, content-type, body, date, 
message-id, topic, subject, email ) VALUES (  'Re: Studium PhF', 'Mon, 15 
Nov 99 12:34:16 -0100', 'text/plain; charset=''US-ASCII''', NULL, 
'19991115123416', '<[EMAIL PROTECTED]>', 'Studium 
PhF', 'Re: Studium PhF', '[EMAIL PROTECTED]' )");

Can anyone tell me my mistake? Thank you all.

Christian 

Reply via email to