Jeff,
Thanks for your help. Your example helped me get my placeholders
working. I missed that {} was needed as a parameter before my
placeholder variable. Very cool!
If I can be of any help with the key lookup bug, just let me know. I
look forward to getting your fix. FYI, I'm using DB
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Version 1.41 of DBD::Pg, the PostgreSQL database driver for the DBI
module, has been released. This version is primarily a bug fix for
1.40: if you are using that version (or less), you are highly
encouraged to upgrade. COPY support has been overhaul
Jim Lambert wrote:
I tried placeholders, but my query did not return any results with them.
Try this short script and send me the results. If this script succeeds
and your placeholders, fail, please send me an example of your use of
placeholders.
#!perl -w
$|=1;
use strict;
use DBI;
my $dbh = D
Hi Tim,
while(my @row = $sql->fetchrow_array){
$sql1->execute("$row[3]");
What DBD module are you using?
If Oracle, are any of the fields CHAR?
is MySql, the fields are char
Xaver
You really should be using placeholders, not using them is slowing you
down considerably since it means the statements are parsed for every
single value you pass.
I tried placeholders, but my query did not return any results with
them. For example: in the get() method, when $addr = '[EMAIL PR
Hi Jim,
I'm using DBD::DBM, and the queries I think should be quick and based
on the dbm key are taking forever and my strace output confirms that
the whole dbm file is being searched.
You really should be using placeholders, not using them is slowing you
down considerably since it means the sta
Hi,
I'm using DBD::DBM, and the queries I think should be quick and based
on the dbm key are taking forever and my strace output confirms that
the whole dbm file is being searched.
In the module included below, you'll see the get() method.This
method includes the SELECT that I think, should
Jonathan,
Q1
> * Version of IDS (or SE, XPS, OnLine) - though that is not going to
> material this time.
> Not sure what you are asking here, sorry.
What do you get if you run 'onstat -V'? Is the IDS server running on
the HP machine - or is it in fact somewhere else?
For example, (give
On Thu, Apr 07, 2005 at 01:05:49PM +0200, xaver biton wrote:
>
> while(my @row = $sql->fetchrow_array){
> $sql1->execute("$row[3]");
What DBD module are you using?
If Oracle, are any of the fields CHAR?
Tim.
Dear Cory,
On Apr 7, 2005 6:01 AM, Cory Cox <[EMAIL PROTECTED]> wrote:
> Thanks for getting back to me so fast. We went back and tried to eliminate a
> few variables and went through the readme files once again. I did a clean
> compile of Perl 5.8.6 and all modules. We still get the same erro
I am trying to install the DBD-ODBC version 1.13. We are getting a ton of
errors at make. Does anyone have an suggestions? We are running Perl-5.8.6 on
an HPUX box version 11.11. We are trying access an Informix database. I read
we could use ODBC for this. Thanks for any help you can provi
Patrick Galbraith wrote:
>Steve,
>
>What compiler have you used? For the server, we don't use Cygwin for
>our official binaries, so I'm wondering if there are any issues in
>using Cygwin vs. MSVC++ (or whatever) to compile DBD::mysql.
>
>
I use MS VC++ 6.0 SP5 to build Perl, MySQL and DBD-mysq
Steve,
What compiler have you used? For the server, we don't use Cygwin for
our official binaries, so I'm wondering if there are any issues in
using Cygwin vs. MSVC++ (or whatever) to compile DBD::mysql.
thanks!
Patrick
On Apr 7, 2005, at 1:07 AM, Steve Hay wrote:
Ron Savage wrote:
On Wed, 6 Apr
Hi,
Perhaps if you list what you want to happen and what is happening in
more detail we can help.
Ok
my $sql = $dbh->prepare(q{select col1, col2, col3 from test});
the second:
my $sql1 = $dbh->prepare(q{select row1, row2, row3 from test1 where
test1.row = ?})
$sql->execute();
while(my @col = $s
On 04/07/2005 04:05 AM, xaver biton said:
i've 2 select query. the first one is like
my $sql = $dbh->prepare(q{select * from test});
If all you want is col4, it would be safer to use "SELECT col4...".
the second:
my $sql1 = $dbh->prepare(q{select * from test1 where test1.row = ?})
$sql->execute();
Thanks for getting back to me so fast. We went back and tried to eliminate a
few variables and went through the readme files once again. I did a clean
compile of Perl 5.8.6 and all modules. We still get the same error. Here are
the answers to your questions:
* Version of Perl (5.8.6)
Hi,
i've 2 select query. the first one is like
my $sql = $dbh->prepare(q{select * from test});
the second:
my $sql1 = $dbh->prepare(q{select * from test1 where test1.row = ?})
$sql->execute();
while(my @row = $sql->fetchrow_array){
$sql1->execute("$row[3]");
while(m
Ron Savage wrote:
> On Wed, 6 Apr 2005 09:33:36 -0700, Patrick Galbraith wrote:
>
>Hi Folks
>
>
>
>> Thanks so much for your patch! I do need to check out windows
>> issues. I didn't realise that windows doesn't have LONG LONG. If
>> possible, I'd like to pick your brain about getting a setup to
18 matches
Mail list logo