Re: [Perl-unix-users] MySql Update Error

2003-03-31 Thread Anthony Ettinger
Can you provide the lines that have your $statementHandler and sql code? --- "V. Rajaraman [Sys-Support]" <[EMAIL PROTECTED]> wrote: > > Hi All, > > I use DBI to update Mysql table, when i do that i > facing the below error. > What is the error ? > > Error : > > can't execute the query: DBI:

[Perl-unix-users] MySql Update Error

2003-03-29 Thread V. Rajaraman \[Sys-Support\]
Hi All, I use DBI to update Mysql table, when i do that i facing the below error. What is the error ? Error : can't execute the query: DBI::st=HASH(0x1eadc28) Thanks in advance. ___ Perl-Unix-Users mailing list [EMAIL PROTECTED] To unsubscribe: htt

Re: [Perl-unix-users] mysql ping on DBI

2003-03-19 Thread Simon Oliver
Martin Moss wrote: So the question I have is "How" do I insert the ping subroutine into my own custom DBI class which calls DBI and maintains the dbh connection. The old way (and I think it still works) is to use DBIx-AnyDBD but this functionality has now been included in the DBI itself - see

[Perl-unix-users] mysql ping on DBI

2003-03-18 Thread Martin Moss
All,   I have a problem in that I want to check if a DBI connection is still active. For this I have heard you can use ping. But From the documents I've found I see that ping is always set to return true for DBD::mysql. But DBD::Oracle has a ping routine defined which does a valid check. The

[Perl-unix-users] Mysql modules::Install Problem

2001-06-24 Thread jorn . meijers
Goodmorning to all you Perl Hackers ! The last week I have have big difficulties trying to install all the modules to give get Perl to connect with Perl. The following modules had to be installed: - Data-ShowTable-3.3.tar.gz - DBI-1.16.tar.gz - Msql-Mysql-modules-1.2216.tar.gz I used Perl modul

Re: [Perl-unix-users] Mysql

2001-06-24 Thread Anthony E.
the perl modules you need are DBI.pm and DBD::MySQL.pm you can obtain them from cpan.org. as for php, your page will connect to the db via some other built in php method. the documentation on DBD and DBI should have examples for connecting to the db in perl. - Anthony E. --- Johnno <[EMAIL PR

[Perl-unix-users] Mysql

2001-06-24 Thread Johnno
I have installed MySql and it is working find... what perl modules do i need to install to be able to access the database via a perl script?? and will this also work with php files that access the database?? Johnno ___ Perl-Unix-Users mailing list.

[Perl-unix-users] mysql to oracle

2001-05-05 Thread Pragneshkumar Gandhi
Hi all It is Pragneshkumar Gandhi From INDIA I have one database in mysql and i want to transfer that in oracle 8i i am using mysql 3.22.25 on linux 6.1 and oracle 8.1.6 for linux.(enterprice edition) i created database in oracle called "bt"; and i transfer all DDL and DML stuff of that database(