ADODB Insert Question (Syntax)

From: Date: Tue, 07 Aug 2007 20:34:00 +0000
Subject: ADODB Insert Question (Syntax)
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-260325@lists.php.net to get a copy of this message
Hi What is the proper way to get the ADODB class to automatically add quotes to the below sql ? I'm guessing that the below fails because none of the variables get quoted with the method, qstr. $sql = "insert into email (to_name, to_email, from_name, from_email, subject, message, timestamp, ip) "; $sql .= "values ($to_name, $to_email, $from_name, $from_email, $subject, $message, $time, $ip)"; I tried something like the below to no avail $sql .= "values($conn->qstr($to_name), $conn->qstr($to_email), .......)"; Is there an accepted way to place multiple $variables inside an ADODB insert statement? many thanks

« previous php.general (#260325) next »