Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^2: DBI Substring index query and passing value

by SriniK (Beadle)
on Dec 11, 2012 at 10:41 UTC ( #1008260=note: print w/replies, xml ) Need Help??


in reply to Re: DBI Substring index query and passing value
in thread DBI Substring index query and passing value

Hi,
Thanks for your replay.

$name will be like "Christin". the Direct result in sql will be
phone_no Mail_ID +00 00 0000 0000 ********.*****@******.com
In that query the actual result will be +00 00 0000 0000$$********.*****@******.com$$$******, in that im splitting the required phone no and mail id using sub string in sql

hope you understand.
The result is there in SQL. But while running in perl it not showing result must be some special charcter issue.
I tried various methods but not able to get the answer. As of now i have changed the query and splitting done in script.
Thanks
Srinivasan

Replies are listed 'Best First'.
Re^3: DBI Substring index query and passing value
by Anonymous Monk on Dec 11, 2012 at 11:12 UTC

    $name will be like "Christin".

    Well, currently, $name is $name; single quotes don't interpolate. Do check how I modified your query code. (Also worth looking is 7548)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1008260]
help
Chatterbox?
[Corion]: Meh. I need to find myself a better "programming" feed than r/programming (which is just HackerNews reposts and advertisements, very little code). Maybe I should select a list of links that I liked on r/programming and then google for ...
[Corion]: ... an aggregator site that also listed (ideally) all of these links once. And maybe also have an exclude list to blacklist some of the most spammy links that the site may have never mentioned at all
[marto]: I gave up reading HN at all, and feel much better for it :P
[Corion]: Now, how to best automate that Google search ... :-)
[Corion]: marto: Yeah, I'm also short of not reading it at all. I already stopped reading it in the morning because it gave me a foul mood.

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (9)
As of 2017-07-24 13:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I came, I saw, I ...
























    Results (354 votes). Check out past polls.