Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Perl DBI escape reserved word in Ingres database

by jtech (Sexton)
on Feb 22, 2019 at 12:51 UTC ( [id://1230378]=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    my $sql = "SELECT DISTINCT id FROM mytable WHERE active = ?";
    my $ref =  $dbh->selectall_arrayref($sql,undef,'yes');
    @id = map{ $_->[0] } @$ref;
    die join (", ", @id), "\n";
    
  2. or download this
    my $sql = "SELECT DISTINCT id FROM mytable WHERE open = ?";
    my $ref =  $dbh->selectall_arrayref($sql,undef,'true');
    @id = map{ $_->[0] } @$ref;
    die join (", ", @id), "\n";
    
  3. or download this
    'open'
    '\open\'
    ...
    
    \'\"open\"\'
    \"\'open\'\"
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1230378]
Approved by Discipulus
Front-paged by haukex
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others imbibing at the Monastery: (7)
As of 2024-04-16 07:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found