On Tue, 19 Nov 2002 13:05:38 -0500, [EMAIL PROTECTED] (Chris Faust)
wrote:
> How about (one of many ways):
>
> system ( $CommandString ) or die &process_error("$CommandString);
Um, no.
system() returns $?, so 0 on success and something else on failure.
Either use "system(...) and die" or "syste
On Tue, 19 Nov 2002 20:29:05 -0600 "Seline, Chris [R&D/0111]" <[EMAIL PROTECTED]>
wrote:
> unsubscribe
[unrelated lines snipped]
I doubt this will do much good since you didn't read the responses
to the last person who sent such a request to the list, but if you
send email to [EMAIL PROTECTED]
unsubscribe
-Original Message-
From: Andrew Hamm [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 07, 2002 10:38 PM
To: DBI users
Subject: ChopBlanks and DBD::Informix
Hi folks,
I'm closely (re)scrutinising the DBD::Informix doco for 1.00.PC1 and notice
that it says
Note that you ca
> code snippet:
>
> use DBI;
> my $dbh = DBI->connect('DBI:ODBC:OST', 'user', 'pass')
> or die "Couldn't connect to database: " . DBI->errstr;
>
> sub get_max_id {
> my $be_table=@_[0];
> my $st_maxid = $dbh->prepare("select max(OST_ID) from $be_table where
> event_status='U
You still might have a problem, if it's 0.43 with the "global destruction".
My repository (ftp.esoftmatic.com) referenced in the faq has a later
version. If you run into another problem, try that one. If you don't have
problems and you are going into production, stay with what works. Shortly,
I
> From: Michael A Chase [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 14, 2002 8:47 AM
>
> I recommend using explicit column names instead of '*'. If someone changes
> the column order on you it could ruin the rest of your processing.
That's what fetchrow_hashref() is for. Asterisks are
Just a little throw-away example for you, in addition to Chris' email...
---
#!/usr/bin/perl -w
use strict;
use Omni::DB; # You probably 'use DBI;'
use CGI;
my $q = new CGI;
my $dbh = Omni::DB::connect_prod();
The problem is that you're redefining $maxid inside your unless statement.
When you use "my" inside a block like that, the variable takes on the scope
of the block. Take off the "my" inside the unless and that should modify the
correct variable.
As to your second question, I don't see anything wro
Hi,
I made some bugfixes to the postgres pure perl driver.
- driver errors on queries that return row with more than 8 NULL values
- driver errors on queries that retrun rows with 0-length values.
I already tried to contact the author but have not yet got any feed back. If
anybody is intereste
Hope this isn't too simple a question.but I can't find an example in my
"Programming the Perl DBI"...platform is NT, ActivePerl 633...database is
SQLServer2000, connection is DBI:ODBC
When I select the max (id) from table where status = 'U'
and there aren't any records with a status of 'U', t
Just to confirm I installed http://xmlproj.com/PPM/DBD-ODBC.ppd which has an
ODBC.pm file with a version of 0.43. I reproduced the problem before
installing, installed and retested, and the problem did not recur. The
Microsoft Access driver seems to be, from looking at the control panel,
version
>
> Just for the sake of the archives I would like to note that I encountered
> this bug against Microsoft Access.
Ok -- can you upgrade and verify? Activestate's version is 0.28 was
released over two years ago! There were two identified problems which
caused access violations, one was during "g
How about (one of many ways):
system ( $CommandString ) or die &process_error("$CommandString);
sub process_error {
print "System Call $CommandString failed\n";
# and do whatever else you want to do
}
-Chris
>> -Original Message-
>> From: Shao, Chunning [mailto:[EMAIL PROTECTED]]
>> S
Just for the sake of the archives I would like to note that I encountered
this bug against Microsoft Access.
- Original Message -
From: "Jeff Urlwin" <[EMAIL PROTECTED]>
To: "Ronald Schmidt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 9:44 PM
Subject: RE: :ODBC
$? is where you should look. The return code is going to depend on what command you
are running, what OS you are on, and obviously whether or not the command succeeded.
In general commands exit with 0 if they succeed or greater than 0 if they don't, but
this is merely a guideline. You can also
say,
use strict;
use DBI;
$CommandString = "exp $username[$i]\/$passwd[$i]\@$instance[$i] log =
$file_dir$owner\_$table.log";
system ( $CommandString );
if (failed)
{
.
}
How do I define failed?
Thanks
DBD::ODBC 0.43 tests failed under cygwin perl 5.8.0 DBI 1.30 on NT4 SP 6a
MERANT 5 32 bit ODBC driver 0.52.00.00That's the driver. It seems that
everything else is ok, but the bind parameter stuff. 0.43_xx might be
better for you, as the tests have been improved...
Regards
Jeff
t/07bind..
Dear Chris,
Thanks a lot.
It worked according to your suggestion.
row0 was the key and row1 the value.
Seems I was puzzled with the syntax to add to a hash
%somelabels =();
$somelabels{$row4[0]}=$row4[1];
Caio e arriverderci.
Chris Faust wrote:
> I'm not sure what this is doing, but is row4[0]
Has anyone built this, I'm getting this error when trying to build the
pre-requisite package gdtextUtil-0.80 :-
bash-2.05b$ perl Makefile.PL
Checking if your kit is complete...
Looks good
C:\cygwin\bin\perl.exe: *** unable to remap C:\cygwin\bin\cygpng12.dll to
same address as parent(0xB9) !
I'm not sure what this is doing, but is row4[0] your key and row4[1] your
value?
seems like this:
while ((@row4) = $sth4->fetchrow_array) {
push @ids, "@row4[0]";
if ($listcounter == 0) {
$hashstring .= "@row4[0],'" . "@row4[1]'";
}
else {
bash-2.05b$ perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=cygwin, osvers=1.3.12(0.5432), archname=cygwin-multi-64int
uname='cygwin_nt-5.0 kmbestst 1.3.12(0.5432) 2002-07-06 02:16 i686
unknown '
config_args='-de -Dmksymlinks -Dusemul
Use trace.
Tim.
On Mon, Nov 18, 2002 at 09:30:50PM -0500, [EMAIL PROTECTED] wrote:
> Hi all,
> I've got a problem that I absolutely can't figure out, and I was
> hoping somebody here might know what's up. I'm running MySQL on Solaris 8
> with perl version 5.6.1, DBI version 1.13, mysql DB
On Mon, Nov 18, 2002 at 12:35:25PM -0600, Duin, Harry wrote:
> I am rather new to DBI and a few weeks ago I was geven a program by my
> Oracle DBA that showed I can write to a
> BLOB data type by setting the ora_type attribute in bind to 24, as in:
>
> $sth->bind_param(1, $data, { ora_type => 24 }
Dear List,
I try to bind a hash containing the result of a query to a popup button.
If I make the hash 'manually' it is not using the result of my selection than
everything works fine.
If I populate the hash from the selection than it will not display. So I presume
that my hash creation contains a
24 matches
Mail list logo