On 10/5/07, <b class="gmail_sendername">Thomas Keller</b> <<a href="mailto:kellert@ohsu.edu">kellert@ohsu.edu</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I think I found it:<br>Instead of a '?' (as with PostgreSQL) you use ':1', etc.<br><br>Other than that DBI handles it in a standard way.<br><br>thanks,<br>Tom<br><br>Thomas J Keller PhD<br><a href="mailto:kellert@ohsu.edu">
kellert@ohsu.edu</a><br>4-2442</blockquote><div><br>I think you have something weird going on -- you are talking about bind parameters, and they are the same with SQLite -- from the DBD::SQLite docs:<br><pre> use DBI qw(:sql_types);
<br> $dbh->{unicode} = 1;<br> my $sth = $dbh->prepare<br> ("INSERT INTO mytable (blobcolumn) VALUES (?)");<br> $sth->bind_param(1, $binary_data, SQL_BLOB); # binary_data will<br> # be stored as-is.
</pre>Note the "bind_param" and the "?" in the ->prepare query.<br><br>-J<br><br></div></div>