This has had me scratching my head for a while...

my $crid = $crm->db->selectrow_array("SELECT idPerson FROM Person WHER
+E email = ? OR altEmail = ?", undef, $data{'email'}, $data{'email'});

print "ERROR: " . $crm->db->errstr if $crm->db->err;

print "#$data{'email'}# - $crid";
[download]

The print statements are only there for debugging. The # is around the email to check no extraneous spaces had crept in which they haven't. $crm is my CRM module and the db method returns the database handle.

The output I get is #me@example.com# - 0
idPerson is an auto increment INT which starts at 1. There is no zero in the database!

If I manually query the database I get this:

SELECT idPerson FROM Person WHERE email = 'me@examle.com' OR altEmail 
+= 'me@example.com'

 90
102
[download]

Yet my code returns 0.

Things I have tried:

• Pulling $crm->db into a separate variable first - no change
• Replacing the placeholders with the variables WHERE email = '$data{'email'}' - no change.
• Hardcoding the email WHERE email = 'me\@example.com' - that works!
• Pulling the email into a separate variable my $email = $data{'email'} then putting that into the query WHERE email = '$email' - doesn't work
• Forcing array context my ($crid) = $crm->db->selectrow_array - no change

I have found a workaround:

my $query = $crm->db->prepare("SELECT idPerson FROM Person WHERE email
+ = ? OR altEmail = ?");
$query->execute($data{'email'}, $data{'email'});
my $crid  = $query->fetchrow_array;
print "ERROR: " . $crm->db->errstr if $crm->db->err;
[download]

But I have selectrow_array working like this in other places. I don't understand what is going on here!

The DBI documentation says that selectrow_array is the equivalent of prepare, execute and fetchrow_array. It also says that selectrow_array returns undef if there is an error. Here it is returning zero which is not in the database!

Can you help me understand what is going on here?

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.