Darren Edgerton wrote:
Hi,
my environment:
Perl v5.8.0 built for aix-64all
DBI-1.32
DBD-Informix-1.04.PC1
i have compiled and installed Perl 64 bit ok
i have compiled and installed DBI ok
now for DBD Informix:-
when i run 'perl Makefile.PL' i get:
===
When I"m compiling DBD-ODBC-1.04 Its looking for a file called
libudbc.h A search even on good turns up little. The ODBC client I
installted was unixODBC-2.2.4.. Any ideas?
--
Jason
On Wed, 29 Jan 2003 00:28:07 +0100, you ("alex"
<[EMAIL PROTECTED]>) wrote:
>> while (my @row = $sth->fetchrow_array()) {
>> print join("\t", @row), "\n";
>> }
>i've tryed this... but it hasn't worked... i will re-try our...
>
>> my $sql = 'SELECT COUNT(*) FROM temp';
>yes - but this will
Of course, you can do it all with array references if your a glutton for
punishment. I can never remember how and always have to look it up with
working code.
my $rs = $dbh->selectall_arrayref("select * from table");
# count
print "count: $#$rs\n";
# each row
my $rr;
foreach $rr (@$rs) {
print
> $html .= "Item: $row ";
oh *g* - thats the idea :-) - a point for appending the $html string... i
will change this... sometimes if you look too long on a code you get
blockhead... :-)
thx
Alex
> > How did you plan on *retrieving* the data if not through a loop? If you
> > plan on actually getting all the data, you'll have to loop through all the
> > rows I think. Maybe you could post a code fragment?
>
> here is the old code... based ob a file
>
> my @data=split(/\r?\n/,$part[2]);
>
> > very difficult in my code... i will have a look if i can change the
code.
> > isn't it possible without a "while" ?
>
> How did you plan on *retrieving* the data if not through a loop? If you
> plan on actually getting all the data, you'll have to loop through all the
> rows I think. Maybe yo
> > my $sql = 'SELECT COUNT(*) FROM temp';
> yes - but this will result in a additional select and therefor more database
> activity :-(
Not a huge cost if it's against an index
> > my $i = 0;
> > while (my @row = $sth->fetchrow_array()) {
> > $i++;
> > }
> very difficult in my code..
> while (my @row = $sth->fetchrow_array()) {
> print join("\t", @row), "\n";
> }
i've tryed this... but it hasn't worked... i will re-try our...
> my $sql = 'SELECT COUNT(*) FROM temp';
yes - but this will result in a additional select and therefor more database
activity :-(
> my $i = 0;
Both questions are in the manual, which you can reread many times w/o
fully grasping all the details.
> 1. how can i put the output of a select query to a array?
my $dbh = DBI->connect('', $user, $pass);
my $sql = 'Select field1, field2 from temp';
my $sth = $dbh->prepare($sql);
$sth->execute()
hi
i'm realy a newbie to DBI and mostly all works, what i have done and found
out with the manuals and examples around the net... but their are two
problems around "select" - i cannot solve myself. i'm using DBD-ODBC and
MsSQL2K.
1. how can i put the output of a select query to a array?
2. i need
OK, what if I don't have an explicit statement handle (eg
$dbh->do('...')), or if from the signal handler I don't know what
statement is executing, or (the most likely case) the statement handle
is not in scope.
I tried $dbh->cancel(), but that didn't work either.
Steve
-Original Message
On Tue, 2003-01-28 at 11:27, Bob X wrote:
> Is the Sybase DBD still being developed?
>
Yes. Why do you ask?
Michael
--
Michael Peppler Data Migrations, Inc.
[EMAIL PROTECTED] http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl dev
I see in the fine manual, the suggested way of interrupting an executing
statement from within a signal handler is to use the cancel function.
Unfortunately, it doesn't give an example of its use. I tried simply
doing DBI->cancel(), but receive the following error :
Can't locate auto/DBI/cancel.
Is the Sybase DBD still being developed?
Thank you
Very helpful material
Paul Dubois wrote:
At 18:15 + 1/28/03, aa wrote:
Hi,
So how can i change the path setting
Depends on your shell. You might find this helpful:
http://www.kitebird.com/mysql-cookbook/path.pdf
It explains how to set your PATH for the mysql program, but m
At 18:15 + 1/28/03, aa wrote:
Hi,
So how can i change the path setting
Depends on your shell. You might find this helpful:
http://www.kitebird.com/mysql-cookbook/path.pdf
It explains how to set your PATH for the mysql program, but mysql_config
is probably in the same directory.
Paul D
Hi,
So how can i change the path setting
Paul Dubois wrote:
At 9:09 + 1/28/03, aa wrote:
Hello,
Can anyone help me on this please
The directory in which mysql_config is located must be in your
PATH setting.
From: [EMAIL PROTECTED] (Aa)
Thanks
for pointing me to the right list, to b
Hi Kathryn
On Dienstag, Januar 28, 2003, at 06:13 Uhr, [EMAIL PROTECTED] wrote:
I have experienced exactly the same failure when attempting to install
DBI
1.32 on AIX 4.3.3.0 using Perl 5.005_03.
Did you manage to solve the problem using Tim's suggestions?
Well, neither I nor Tim had the time
I'm running ActivePerl on windows 2000 and I'm truing to get a database connection
going to and Access database.
In the README file disributed with DBI there is a crucial line stating:
:"Fetch the DBD::* driver module you wish to use and unpack it?"
I've been browsing the webpages all dat and r
Christian,
I have experienced exactly the same failure when attempting to install DBI
1.32 on AIX 4.3.3.0 using Perl 5.005_03.
Did you manage to solve the problem using Tim's suggestions?
Any help would be much appreciated - I attach details from my 'make test'.
Thanks,
Kathryn
==
We have just upgraded perl from version 5.6 to 5.8. One of my DBI scripts
was used to run well in old version. It returned the following error message
now. I am new in perl and DBI and couldn't figure out the problem.
Thank you for your time and any help is most appreciated
Jane
DBI connect
Mark,
Thanks. I've tried installing on another server and it has got a bit
further. The make test is still failing but now for different reasons, so
I'll try to get to the bottom of this before posting another mailing to the
list!
Kathryn
** HSBC's website is at www.hsbc.com **
**
ORA-01747:
01747, 0, "invalid user.table.column, table.column, or column
specification"
Looks like due to being called in the subroutine, your SQL text is getting
munged-- have you tried running the script with DBI_TRACE=1 set in the
environment so you can see what's going on?
SRH
--
SRH
--
Greetings,
I am encountering a strange problem with DBD-Oracle-1.12 with DBI-1.20, or
DBI-1.32 on Solaris 8 with two different versions of Perl: 5.6.1 and 5.8.0
respectively.
I have created a background process that performs a few tasks, which include
updating a remote oracle table used for repor
Hello,
Please can someone help with the following problem as I have been searching
the internet for two days looking for a solution. Although I have come
across the same problem in the List Archives, I cannot find any replies to
these mails that give a solution.
I am trying to install the Perl D
At 9:09 + 1/28/03, aa wrote:
Hello,
Can anyone help me on this please
The directory in which mysql_config is located must be in your
PATH setting.
From: [EMAIL PROTECTED] (Aa)
Thanks
for pointing me to the right list, to be honest I didnt know which
one to post to,
And mysql_config is
Hello,
Can anyone help me on this please
--- Begin Message ---
Thanks for pointing me to the right list, to be honest I didnt know
which one to post to,
And mysql_config is in this location,
/usr/local/mysql/bin/mysql_config
i.e mysql is in /usr/local/mysql/
is this the 'normal' location?
W
28 matches
Mail list logo
