Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: problems with DBI and am oracle statement

by serf (Chaplain)
on Jan 11, 2006 at 13:38 UTC ( #522439=note: print w/replies, xml ) Need Help??

in reply to problems with DBI and am oracle statement

You have nested single quotes (')s

I'm sorry I don't currently have access to a database to test this against, but I believe this should work:

my $sth = $dbh->prepare(q~ select smt.uniqueid, smt.creationtime,, att.val, gsm.msisdn from dagenericsmt smt, dagenericsmtattribute att, dagsmproduct gsm where smt.uniqueid = att.genericsmt_uniqueid and smt.product_uniqueid = gsm.uniqueid and smt.smtstatus=2 and smt.smtcommand=3 and in ('GSM/Cur/IMSI','GSM/Rpl/IMSI') and smt.acktime is null order by smt.uniqueid ~)
Also - when you're posting code - if you use <code> ... </code> tags around the code it will format it correctly for you and make it downloadable.

It's also easier for us (and you) to read if you can split it up and indent it some logical way. :o) Update: (like dragonchild's *beautiful* example below - definitely gets my ++!)

Replies are listed 'Best First'.
Re^2: problems with DBI and am oracle statement
by Alex_T2 (Initiate) on Jan 11, 2006 at 13:50 UTC
    thx alot serv your q~ ~ stuff works
    kind regards

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://522439]
NodeReaper . o O ( Did I forget to leave the gas on? )

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (4)
As of 2018-07-21 13:19 GMT
Find Nodes?
    Voting Booth?
    It has been suggested to rename Perl 6 in order to boost its marketing potential. Which name would you prefer?

    Results (449 votes). Check out past polls.