Re: How to use quotation marks in query-strings ?

[Felix Geerinckx]

Tim Vantag Wrote:

> But. When I try to run this query in perl-program I get errors because of CONCAT

Not because of CONCAT().

> String found where operator expected

This is a Perl error.

> my $sql = "SELECT s.name, CONCAT('"',f.lastname,'"')AS lastname FROM `firsttable` f, `secondtable` s WHERE f.id = s.tID AND something='$variableID'";

Use Perl's qq{} quoting scheme:

my $sql = qq{
    SELECT 
        s.name, 
        CONCAT('"',f.lastname,'"') AS lastname 
    FROM `firsttable` f, `secondtable` s 
    WHERE 
        f.id = s.tID AND 
        something='$variableID'
};

--
felix
Please use BBCode to format your messages in this forum.