RE: quotes, quotes, quotes...

2001-05-30 Thread Paul Fontenot
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

Re: quotes, quotes, quotes...

2001-05-30 Thread Bodo Eing
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): > =

Re: quotes, quotes, quotes...

2001-05-30 Thread Herbert.Liechti
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

quotes, quotes, quotes...

2001-05-30 Thread Paul Fontenot
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

Re: How can I get a directory listing of the server's current directory

2001-05-30 Thread Reinke Bonte
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

How can I get a directory listing of the server's current directory

2001-05-30 Thread shahn
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

Re: Newbie looking for resources

2001-05-30 Thread Randal L. Schwartz
> "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

RE: Postgres select problem

2001-05-30 Thread Sterin, Ilya
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

RE: DSNless connection.

2001-05-30 Thread Philip DiFalco
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

Postgres select problem

2001-05-30 Thread [EMAIL PROTECTED]
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

RE: Binding Parameter

2001-05-30 Thread Kokarski, Anton
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.

Binding Parameter

2001-05-30 Thread Jorge L. Allen
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

RE: DSNless connection.

2001-05-30 Thread Brose, Eric
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

RE: DSNless connection.

2001-05-30 Thread Sterin, Ilya
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

DSNless connection.

2001-05-30 Thread Krung Saengpole
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

DBD::ODBC Make Test Problem

2001-05-30 Thread Justin Kelley
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

Re: Newbie looking for resources

2001-05-30 Thread Will W
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

Re: Newbie looking for resources

2001-05-30 Thread Will W
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

Re: Newbie looking for resources

2001-05-30 Thread Will W
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

RE: DBI -> Access

2001-05-30 Thread Sterin, Ilya
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

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-05-30 Thread Mohammad Shoja
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 -

Re: DBI -> Access

2001-05-30 Thread Tim Scott
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

Re: Newbie looking for resources

2001-05-30 Thread Bart Lateur
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

Re: DBI -> Access

2001-05-30 Thread Tim Scott
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

Re: DBI -> Access

2001-05-30 Thread Tim Scott
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

Re: DBI-1.15

2001-05-30 Thread David . Raimbault
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

RE: perl/dbi and coldfusion

2001-05-30 Thread Kokarski, Anton
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