| List: | MySQL and Perl | « Previous MessageNext Message » | |
| From: | Jochen Wiedmann | Date: | July 27 2001 1:51pm |
| Subject: | Re: quoting | ||
| View as plain text | |||
Raul Dias wrote: > I liked the challenge 8) > > my $stmt = "INSERT INTO table SET " . > join (", ", > map{ > "$col_names[$_]=" . $dbh->quote($col_values[$_]) > } (0..$#col_names) > ); > my $sth = $dbh->do($stmt); That works, if all arguments are strings. It doesn't for mixed types. (It probably does for MySQL, but not for other databases.)
| Thread | ||
|---|---|---|
| • quoting | Raul Dias | 24 Jul |
| • Re: quoting | Dodger | 24 Jul |
| • Re: quoting | Christopher Hicks | 25 Jul |
| • Re: quoting | Jochen Wiedmann | 26 Jul |
| • Re: quoting | Raul Dias | 27 Jul |
| • Re: quoting | Dodger | 27 Jul |
| • Re: quoting | Jochen Wiedmann | 27 Jul |
| • Re: quoting | Raul Dias | 27 Jul |
| • Re: quoting | Jochen Wiedmann | 27 Jul |
| • Re: quoting | Dodger | 27 Jul |
