On 18 May 2004 19:12:19 -0000 [EMAIL PROTECTED] (PerlDiscuss - Perl Newsgroups and mailing lists) wrote:
> I cant find a simple perl function to replace characters in a string. Im > trying to inserts strings like "bob's" into a database and need to convert > that to "bob''s" so that sql doesnt whine when i do an insert. > > Any suggestions? hi try to use DBI module see perldoc DBI and quote method quote $sql = $dbh->quote($value); $sql = $dbh->quote($value, $data_type); Quote a string literal for use as a literal value in an SQL statement, by escaping any special characters (such as quotation marks) contained within the string and adding the required type of outer quotation marks. $sql = sprintf "SELECT foo FROM bar WHERE baz = %s", $dbh->quote("Don't"); For most database types, quote would return 'Don''t' (including the outer quotation marks). > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > <http://learn.perl.org/> <http://learn.perl.org/first-response> > > > -- Frédéric Sapet *********************** Génoplante-Info 523 place des Terrasses 91000 Evry 01 60 87 37 59 [EMAIL PROTECTED] *********************** -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>