On Fri, 29 Oct 2004 17:18:20 -0600, Reidy, Ron wrote:
>Or (from Bart Lateur):
>
>> my $SQL = 'SELECT * FROM students WHERE id NOT IN ('
>> . join ',' , @ids
>> . ')'
>> ;
I'd only ever do that for numerical id's. For the generic case, I4d use
placeholders, like any
You need as many "?" as you have entries in your "IN" operator list.
As Niles points out, in your example you had two entries, thus you need 2 "?"s.
Ron Reidy provided this example from Bart Lauer...
> my $SQL = 'SELECT * FROM students WHERE id NOT IN ('
> . join ',' , @ids
>
Sunil-
Since you are passing more than one param in your in try this:
select a from b where c in (?,?)
then pass sjhd and sdh in your ->execute(sjhd,sdh);
>>-Original Message-
>>From: Sunil A.V. [mailto:[EMAIL PROTECTED]
>>Sent: Friday, October 29, 2004 4:15 PM
>>To: [EMAIL PROTECT
If you are using Oracle, use a global temporary table.
Or (from Bart Lateur):
> my $SQL = 'SELECT * FROM students WHERE id NOT IN ('
> . join ',' , @ids
> . ')'
> ;
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Sunil
Perl DBI
When I prepare a query with
select a from b where c in (?)
and send 'sjhd,'sdh' as paremeter to bind, its not working as desired. Whats the
correct way of using prpared statements and binding in case of 'in' and 'not in'
queries
> What do you mean by clean out?
I mean unpacking DBD-Oracle-1.16.tar.gz from scratch and starting again -
"make clean" gets rid of most stuff but starting again makes extra sure when
things get confusing.
> I placed a fresh copy of DBD::Oracle in
> c:\cygwin\lib\perl5\site_perl\5.8.5\cygwin-thr
What do you mean by clean out? I placed a fresh copy of DBD::Oracle in
c:\cygwin\lib\perl5\site_perl\5.8.5\cygwin-thread-multi-64int\DBD and
then
I set ORACLE_HOME to c:\Oracle\Ora81 and did "perl makefile.pl -v" and
this is the result:
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce ([EMA
Tim Bunce wrote:
- Forwarded message from Denesa K Shaw <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
X-SPF-Guess: pass (seems reasonable for [EMAIL PROTECTED] to mail through 158.81.14.31)
Subject: DBD Install
To: [EMAIL PROTECTED]
From: Denesa K Shaw <[EMAIL PROTECTED]>
Date: Thu
This appears to be a known problem, see
http://groups.google.com/groups?hl=en&lr=&q=test.pl+uninitialized+%22dbi+onl
y%22:
### What's that warning?
printf "%5d NullP sth/s perl %8s %s (%s %s %s)\n\n",
$count/$dur, $], $Config{archname},
$Config{gccversion} ? 'gcc' :
Hi Tim,
Following is my perl file:
-
#!/usr/bin/perl
require "config.pl";
my $conn = DBI->connect($DATA_SOURCE, $USERNAME, $PASSWORD) or die
"$DBI::errstr";
my $query = "SELECT
nvl(to_char(topup_datetime,'-mm-dd'),to_char(pt_val_datetime,'-mm-dd
')),pt_status,int
It would help if you could show us a small piece of code that
demonstrates the problem. At least the SQL + bind_param calls etc.
http://www.catb.org/~esr/faqs/smart-questions.html
Tim.
On Fri, Oct 29, 2004 at 10:37:21AM +0530, Rachita wrote:
> Hi Tim / Reidy,
>
> Thanks for the info.
>
> The s
Hi Tim / Reidy,
Thanks for the info.
The same procedure is running perfectly fine when I run it at SQL Plus
prompt. Moreover i have not done any changes except to upgrade my Oracle
from 8.1.7 to Oracle 9.2.0.1.0
I have 2 servers. On the production server, I have just upgraded the
database and no
Andy,
I've tried that before and I just tried it again, i.e. I set ORACLE_HOME
to c:\Oracle\Ora81. No luck though, I got the exact same error message.
-Original Message-
From: Andy Hassall [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 28, 2004 3:25 PM
To: Vassilev, Lubomir G.; [EMAIL
13 matches
Mail list logo
