Re^2: 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
[download]

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

Comment on Re^2: DBI Substring index query and passing value Download Code

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)	[reply] [d/l] [select]