Thanks for the gentle nudge. As usual the list is absolutely correct and
most appreciated.
-Paul
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 12:01 AM
To: Paul Fontenot
Cc: [EMAIL PROTECTED]
Subject: Re: quotes, quotes, quotes...
On
From: "Paul Fontenot" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject:quotes, quotes, quotes...
Date sent: Wed, 30 May 2001 23:58:49 -0700
Paul,
use placeholders as follows (and add error checking yourself):
> =
On Wed, 30 May 2001, Paul Fontenot wrote:
> I am getting this error and I know what is causing it, but I have no idea
> how to fix it, any help would be great. The script steps through the
> /var/log/messages file on a linux server and puts
> The entries into a mysql database. However when it get
I am getting this error and I know what is causing it, but I have no idea
how to fix it, any help would be great. The script steps through the
/var/log/messages file on a linux server and puts
The entries into a mysql database. However when it gets to the 'hlt' line in
the messages file it just ba
Please ask your question on a general perl list. This list only answers DBI
related questions.
Thank you
Reinke
- Original Message -
From: "shahn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 12:48 PM
Subject: How can I get a directory listing of the serve
Dear all,
Using the Net::FTP, how can I get a directory listing of the server's
current directory ?
ftp->ls() methode does not return a directory listing, just ARRAY..
Thanks a lot.
-shahn
> "Will" == Will W <[EMAIL PROTECTED]> writes:
Will> I'm new to the list and to DBI. I'm at the stage where I'm trying to
Will> identify useful resources. I've used Perl for several years and I've had
Will> some formal training in RDBMS design and a little experience with
Will> Paradox back i
Well that's because you only fetched one row. fetchrow is deprecated and
replaced by fetchrow_array()
How about trying this...
while (@array = $query->fetchrow_array())
{
foreach (@array)
{
print $_, " | ";
}
print "\n";
}
Ilya Sterin
-Original Message-
From: [EMAIL PRO
perhaps?, change your single-slash (\) to double-slashes (\\)
ie.,
CHANGE:
$dsn='Driver=Microsoft Access Driver (*.mdb);DBQ=d:\data.mdb';
TO:
$dsn='Driver=Microsoft Access Driver (*.mdb);DBQ=d:\\data.mdb';
-Original Message-
From: Krung Saengpole [mailto:[EMAIL PROTECTE
Dear,
I am 2 differents output from psql and use Postgres
% su - postgres
% psql hrdb
hrdb=> select * from employee where middlename like '%LAMINE%';
MAMADOU | LAMINE | DIATTA | SYSTEM ENGINEE | [EMAIL PROTECTED]|
677-4417985 |780-393-3675 |403-915-7162 |407-915-7162 |SOCCER, BIKING|
05-29-2001
A
Jorge,
Most of the drivers only support bind_param on those kind of types of
columns. You have to treat these with special care. I can say that because
I've done it in mysql and oracle, I guess DBD::ProxyServer is no exception.
Hope this helps,
Anton
-Original Message-
From: Jorge L.
I was accessing an Access Database through a proxy server from unix.
It worked fine with selecting certain columns.
I was creating SQL on the fly like:
SELECT type FROM Documents WHERE foo=$bar
When i selected a memo type colunm (I set LongReadLen fine), it gave me
errors like this:
Error: Serv
Out of curiosity, why wouldn't you use a DSN?
Eric
-Original Message-
From: Krung Saengpole [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 12:38 PM
To: [EMAIL PROTECTED]
Subject: DSNless connection.
Dear all,
I have another easy problem (yours), how can I connect to Access da
What error are you getting?
Ilya Sterin
-Original Message-
From: Krung Saengpole
To: [EMAIL PROTECTED]
Sent: 05/30/2001 1:38 PM
Subject: DSNless connection.
Dear all,
I have another easy problem (yours), how can I connect to Access
database with DSNless DBI? I try below:
$dsn='Drive
Dear all,
I have another easy problem (yours), how can I connect to Access database with DSNless
DBI? I try below:
$dsn='Driver=Microsoft Access Driver (*.mdb);DBQ=d:\data.mdb';
$dbh=DBI->connect("DBI:ODBC:$dsn",'','',{RaiseError=>1})
or die $DBI::errstr ;
It couldn't connect to database
Hello,
When installing DBD::ODBC, the make test returns the following error:
Dyld: /usr/bin/perl can't open library: .libs/libiodbc.dylib (No such file
or directory, errno = 2)
I tried disregarding it and continuing with the install, but then apache
returns the same error after the install. Ha
Thank you very much for this, Bart. Your comments directly address many
of my concerns. I'll be following this up with some more specific
questions under a new subject.
- Original Message -
From: Bart Lateur <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 2:47 A
Thanks for the advice.
- Original Message -
From: Sterin, Ilya <[EMAIL PROTECTED]>
To: Michael A Mayo <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; Will W <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 9:41 PM
Subject: RE: Newbie looking for resources
> Or you can go with XML for data sto
Thanks for your comments, Mike. They have helped shape my awareness of
some issues.
You ask what I find lacking in the current documentation. In a word,
redundancy. I prefer to work out of two or more books on the same
subject when studying. I really hate it when I lose time because I have
misint
Look at comments below.
-Original Message-
From: Tim Scott
To: Trevor Webster
Cc: DBI Users
Sent: 05/30/2001 2:09 AM
Subject: Re: DBI -> Access
Thanks for your input on this guys. Here's some more information which
might
help, but I think it precludes these problems...
The access datab
I meant, I couldnt use HOME environment variable to address .my.cnf file,
because in the web server this environment variable doesnt point to my
home directory so I have to hard code the address of .my.cnf file as
mysql_read_default_file.
Regards
-
D'Oh.
When I removed the permissions Access created a copy of the .mdb file called
'Secure ...' so I went to change the User DSN to point at that instead.
Then I noticed that the DSN setup had defaulted in 'ReadOnly'...
Works fine when I uncheck this :).
Thanks for your help.
Tim
- Origin
On Tue, 29 May 2001 09:06:50 -0700, Will W wrote:
>I need this to be compact enough
>for fast downloads and free of any proprietary code (it will be freeware
>available over the net). I have identified DBI:CSV as one possible
>approach.
I personally wouldn't use XML or CSV. Why not? Lack of effi
Some further fiddling found a problem with 'workdate'. I've sorted that, but
it still makes no difference. :((
The values it's passing to '$sth->execute' are:
1531499623, -1516480662, 2001-5-29 00:00:00, 3, May-2001
Help!
Tim
- Original Message -
From: "Tim Scott" <[EMAIL PROTECTED]>
T
Thanks for your input on this guys. Here's some more information which might
help, but I think it precludes these problems...
The access database file is a file on my local hard drive to which I have
full and complete access. I can indeed add to this very table through Access
itself.
The PERL s
Hi,
I got the same error on hpux 11 and I did the same thing. But like you, I don't know
of it's ok.
I already sent an email in this list about that.
David
"John C. Hardt" <[EMAIL PROTECTED]> on 29/05/2001 20:53:11
why?
Coldfusion has it's own database interface tags.
on the other hand if you have existing apps that you want to run from
coldfusion, you might need to create a custom tag that will evoke perl app.
Anton
-Original Message-
From: vortex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29
27 matches
Mail list logo