Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re: retrieve info

by huck (Prior)
on Sep 11, 2018 at 23:32 UTC ( #1222165=note: print w/replies, xml ) Need Help??

in reply to retrieve info

what does $input look like? does it contain a %?

possibly you might want something like $search->execute('%'.$input.'%'); SQL LIKE Operator

Replies are listed 'Best First'.
Re^2: retrieve info
by bigup401 (Pilgrim) on Sep 12, 2018 at 13:48 UTC


      As part of basic testing/debugging you should always run your the SQL you have in your code against your database using your test data using one of the standard interfaces. For anything complex I develop my SQL code in SQL Developer (oracle specific) to ensure it all works as expected, before embedding it in my perl code.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1222165]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2022-01-24 19:47 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (65 votes). Check out past polls.