Ilya,
Actually, I tried entering the data from the mysql client that installs
with the mysql server.
Then, there is no padding. So when I retreive the data, I get only the
data that I entered
manually, and no spaces padded. Also previously I have used mysql
varchar fields with PHP,
and that da
Well if you would look at the mysql documentation, you would notice that
varchar pads the data with spaces:-)
You can either switch to text data type, s/\s*$//; the paces out of the
extracted data, or there might be something for DBD::Mysql as there is for
DBD::Oracle (ora_type => ORA_CHAR), but
Hello,
I am facing a peculiar problem with dbi (1.14) / mysql (3.23.22-beta).
whenever i enter data
to a varchar column in a mysql table using dbi, there is a lot of spaces
suffixed to the data.
I think it fills up the column to its total width with spaces. As a
result the display of the data
Where did you get the server=... parameter. Definitelly not from the
docs:-) It's actually host=...
DBI->connect("DBI:mysql:host=www.server.com.br;database=database",
"user", "password");
Ilya
> -Original Message-
> From: Roberto Slepetys Ferreira [mailto:[EMAIL PROTECTED]]
> Sent: We
As someone who's spent alot of time supporting this from both sides of the
fence (customer support and being the customer), I think you're going to run
into trouble unless you can guarantee that the system it will run on is only
used for your application. And even then, you'll have some problems u
Dear DBI users,
I am currently using the DBI 1.18 to connect to a MySQL that was in an the same host
than the perl scripts without trouble.
Today, I tried to connect to that server trought an external server using the DBI
module, but I receive the error below:
DBI->connect(server=www.server.c
If you are going to send the client a complete kit, you should probably
build Perl/DBI/DBD/... in a comparable machine and send them an archive of
the whole perl tree. With tar and gzip or bzip2, its only a few megabytes.
perllib.so contains the actual interpreter that is invoked by 'perl'. It
Ok. Good enough, and good explanation for why. That's exactly what I was
looking for. Guess I'll keep typing that extra line :-). Thanks much.
Steve H.
-Original Message-
From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 2:58 PM
To: Steve Howard; DBI USER
Perl has to copy every column value returned by fetchrow() to the
corresponding element of @array. With bind_columns(), no copying is
required. That is a major performance improvement if you have more than a
few rows.
--
Mac :})
** I normally forward private questions to the appropriate mail lis
Hi Steven,
We support some specific versions of Solaris and HP-UX only,
So we will not have hard time with customers, we don't want to
lert customers worry about installing since this will bring
allot of headache to our technical support dept.
Suppose I compiled Perl, DBI and DBD::Informix, on
Bodo
Thank you very, very much for your e-mail. That's just what I needed. I
know that I should have been using placeholders for a long time and never
got round to it - it seemed complicated. I've just spent a couple of hours
getting them into my brain for an application that I thought was too
Is there any performance advantage of using a:
$sth->bind_columns(undef, \(@array[0..$#cols]));
while ($row = sth->fetchrow_arrayref) {}
instead of skipping the bind columns and just doing:
while (@array = sth->fetchrow) {}
I just wonder why I normally type an extra line (Looking for a rea
> -Original Message-
> From: Mojdeh Ghiaie [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 04, 2001 6:29 AM
> To: [EMAIL PROTECTED]
> Subject: Please help for BDI for Win32
>
>
> Hi,
>
> I am working with Perl5.004 on Win ME and have a
You should really be using ActivePerl from www.a
Right and you will have to install the Oracle client to to be able to
compile DBD::Oracle, unless you are using ActiveState for Linux.
Ilya
> -Original Message-
> From: Vittorio De Martino [mailto:[EMAIL PROTECTED]]On Behalf Of Victor
> Sent: Wednesday, July 04, 2001 6:36 AM
> To: dbi-us
> Our company is developing allot of Perl script using DBI and DBD::Informix,
>
> We want to send these scripts to our customers, along with compiled
> Perl+DBI+DBD::Informix.
>
> What is the best way to do this.
If all of your customers run the same versions of the O/S, Informix and
Perl and
- Forwarded message from "Mahdi A. Sbeih" <[EMAIL PROTECTED]> -
From: "Mahdi A. Sbeih" <[EMAIL PROTECTED]>
To: "Tim.Bunce" <[EMAIL PROTECTED]>
Subject: Just direct me where to go
Date: Wed, 4 Jul 2001 16:42:55 +0200
Hi Tim,
Our company is developing allot of Perl script using DBI and DB
If you have winzip for windows, it can handle tar files just fine. If you
don't, you can download it at www.winzip.com
Or ifyou have PPM in your installation, you should be able to install DBI
from the internet by just typing:
PPM INSTALL DBI
from your DOS command prompt.
Steve H.
-Origin
Hi all,
I m still struggling with a big problem with installing DBD::Oracle on
Hp unix.
environment---
OS: HP-UX 11
Oracle: 8.1.6.1
Perl : 5.6.0
C-compiler: B3901BA B.11.01.06 HP C/ANSI C Developer's Bundl
Jason [[EMAIL PROTECTED]] wrote:
> Hello all,
>
> please let me start by saying I'm fairly new to 'perl administration'. I am
> having difficulty adding the following module, "DBD-Oracle-1.07.tar.gz". I
> hope you can add some insights. Here is what I did:
>
> 1) downloaded, untared and unzi
Hi,
I am working with Perl5.004 on Win ME and have a
database on VisualFoxpro6.0. So I need to connect to
the database, but unfortunately I did not find the
source of DBI for my purpose, because all of them were
available in tar files not zipe files and windows.
Please help me and let me know how
Hi Neil Lunn,
I've downloaded Sun's Forte 6 C++ and installed it properly. Meanwhile I've
set the compiler path to /opt/SUNWspro/bin as first choice (gcc is taken
away). It means that I am using Solaris native compiler, but I encountered
many compiling errors as follows:
...
"/usr/perl5/5.00503/
Date sent: Tue, 03 Jul 2001 21:28:12 +0100
To: [EMAIL PROTECTED]
From: Ian Summers <[EMAIL PROTECTED]>
Subject:Re: Bind Parameters with MS Access
Ian,
>
> The real problem is that I'm trying to think of a way to speed up updating
Thanks Michael!
No, I'm running perl and DBI under a debian linux laptop but I think
that I'll need the SQL*Net all the same.
Ciao
Vittorio
Michael A. Chase [dbi-users] <03/07/01 08:05 -0700>:
> If you plan to run under WinNT, you should probably be using ActiveState
> Perl and their PPM to ins
23 matches
Mail list logo