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
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 } );
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 DBD
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
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 {
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)
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]
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
$? 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
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 bug
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]]
Sent:
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
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
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',
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
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 wrong
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();
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
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
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');
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
On Tue, 19 Nov 2002 20:29:05 -0600 Seline, Chris [RD/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] you
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 system(...)
23 matches
Mail list logo