John wrote:
Can anyone see the error in the following code. It has to do with the
placeholder in the select statement. Substitution fails to occur at
the $sth1-execute... statement script dies at while (my
$rowref If I replace the placeholder with a literal it works as
expected.
Capacio, Paula J wrote:
John wrote:
Can anyone see the error in the following code. It has to do with the
placeholder in the select statement. Substitution fails to occur at
the $sth1-execute... statement script dies at while (my
$rowref If I replace the placeholder with a literal it
: Monday, December 12, 2005 6:14 PM
Cc: dbi-users@perl.org
Subject: Re: select placeholder
I don't think that is the issue, in fact I don't think it is a DBI/SQL
issue at all because when I do this:
[code]
{
#$custnum = shift @duplist;
#redo if int($custnum) == 0;
$custnum = 000281610
Where you say WHERE custnum == ?, there ought to be only one equals sign.
Ted Behling
-Original Message-
From: John [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 11, 2005 12:40 AM
To: dbi-users@perl.org
Subject: select placeholder
Hi
Can anyone see the error in the following code.
Try SELECT * FROM a1 WHERE custnum = ?
-Original Message-
From: John [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 10, 2005 10:40 PM
To: dbi-users@perl.org
Subject: select placeholder
Hi
Can anyone see the error in the following code. It has to do with the
placeholder in the
Ian Harisay wrote:
Try SELECT * FROM a1 WHERE custnum = ?
Thank you Ian and Ted
That is not the problem, I had previously used a single = and went to
== when it didn't work, tried again this morning - still doesn't work.
SQLite documentation says either is acceptable. A little more
John wrote:
Ian Harisay wrote:
Try SELECT * FROM a1 WHERE custnum = ?
Thank you Ian and Ted
That is not the problem, I had previously used a single = and went to
== when it didn't work, tried again this morning - still doesn't work.
SQLite documentation says either is acceptable. A