Re: retrieving column names from a table using DBI module

On Wed, 19 Feb 2003 08:15:27 -0500, Dave K wrote: Hi Dave >advice. If you would like to see another approach you can visit: >http://www.geocities.com/k2001evad/pindex.html Thanx for the demo. -- Cheers Ron Savage, [EMAIL PROTECTED] on 20/02/2003 http://savage.net.au/index.html

Re: DBD::Informix 1.04.PC1 on Mandrake 9.0 -- where's www.informix.com gone?

Franck PORCHER wrote: I have to install a DBD driver for Informix on a Linux box (Mandrake 9.0) in a need to access an existing Informix database site hosted on another AIX machine. I found the latest package on CPAN (DBD-Informix-1.04.PC1.tar.gz). Yes - it should be good to go as long as you h

Re: CPAN install of DBD::mysql fails during tests

At 9:08 +1000 2/20/03, Peter Kiem wrote: Hi, I am trying to use CPAN to install DBD::mysql which seems to work fine but then fails all the tests as it is trying to connect to the test database using the root user with no password. Is there some way I can tell it what password to use? Surely I d

CPAN install of DBD::mysql fails during tests

Hi, I am trying to use CPAN to install DBD::mysql which seems to work fine but then fails all the tests as it is trying to connect to the test database using the root user with no password. Is there some way I can tell it what password to use? Surely I don't have to change my MySQL root password

Re: retrieving column names from a table using DBI module

On Wed, 19 Feb 2003 09:13:48 +, [EMAIL PROTECTED] wrote: > >Hi, Hi Philip >fetchrow_hashref returns a reference to a hash, with each hash >having the >column name as it's keys. > >$row = $sth->fetchrow_hashref; > >print "$row->{NAME},$row->{ADDRESS}" Sure but there are other things to consid

Re: retrieving column names from a table using DBI module

Manisha Hello Hi I am working with Perl CGi. There is a query where i have to select all columns in a table and display the data on the web page. the query is something like "select * from But the problem is I am not able to get the column names. I am using the DBI module. Is there a way to get

Re: book on perl oracle dB integration

Hi Manisha, > I am searching for a book on Perl oOacle Database Integration. I have found > similar books on Java Oracle DB Integration but not for perl. > If anyone knows of one please let me know of it. You could always try: => http://www.oreilly.com/catalog/perldbi/ => http://www.oreilly.com/

problem reinstalling DBD-mysql-2.1025 after upgrading PERL

Hello Please help! I've just upgraded my development machine but I'm having problems with DBD-mysql after upgrading PERL from V5.6.0 to V5.8.0. The database is running fine and DBI looks like it installed OK but when I try and access it from a PERL program it says: install_driver(mysql) failed: C

Re: Q: MySQL table type & DBI

At 19:58 +1100 2/19/03, Ron Savage wrote: Folks Is there a DBI/DBD::mysql call which will retrieve the table type (ie one of MyISAM/ISAM/Heap/...)? SHOW TABLE STATUS will give you this, along with a bunch of other information. -- Cheers Ron Savage, [EMAIL PROTECTED] on 19/02/2003 http://savag

Re: Q: MySQL 'v' Postgres column attributes

On Wednesday, February 19, 2003, at 01:03 AM, Ron Savage wrote: Is there a Postgres DBI/DBD::Pg call which will retrieve the column attributes the way "show columns from $table" does under MySQL? column_info(). http://search.cpan.org/author/TIMB/DBI/DBI.pm#column_info David -- David Wheel

Re: retrieving column names from a table using DBI module

Hi, fetchrow_hashref returns a reference to a hash, with each hash having the column name as it's keys. $row = $sth->fetchrow_hashref; print "$row->{NAME},$row->{ADDRESS}" or whatever. Similarly, you could use fetchall_hashref or selectall_hashref. I understand that the hashref functions are

Q: MySQL table type & DBI

Folks Is there a DBI/DBD::mysql call which will retrieve the table type (ie one of MyISAM/ISAM/Heap/...)? -- Cheers Ron Savage, [EMAIL PROTECTED] on 19/02/2003 http://savage.net.au/index.html

RE: ora_session_mode

You don't need to connect as sysdba/internal for that. Try in sqlplus: ALTER USER your_user_name DEFAULT ROLE DBA and then try the perl script again. Could be your user has the right to be DBA but has set that active. (if that makes sense, gotta run to a meeting, sorry) ---

Q: MySQL 'v' Postgres column attributes

Folks Is there a Postgres DBI/DBD::Pg call which will retrieve the column attributes the way "show columns from $table" does under MySQL? -- Cheers Ron Savage, [EMAIL PROTECTED] on 19/02/2003 http://savage.net.au/index.html

book on perl oracle dB integration

Hello, I am searching for a book on Perl oOacle Database Integration. I have found similar books on Java Oracle DB Integration but not for perl. If anyone knows of one please let me know of it. Thanks Manisha - Do you Yahoo!? Yahoo! Shopping - Send Flowers f

Re: retrieving column names from a table using DBI module

On Tue, 18 Feb 2003 17:57:12 -0500, Manisha Gupta wrote: >Hello Hi Manisha I see you've been given 3 answers. I suggest reading DBI.html. The data you want is clearly documented in DBI.html (generate this from DBI.pm), under the heading 'Statement Handle Attributes' -- Cheers Ron Savage, [EMAIL P

Re: DBD::Oracle userenv('TERMINAL')

Hello, did you try DBMS_APPLICATION_INFO.SET_CLIENT_INFO('any information you like') ; to set the session dependend client information? You can retrieve this later via V$SESSION.CLIENT_INFO or via DBMS_APPLICATION_INFO.READ_CLIENT_INFO(:g_client_info ); where :g_client_info is a bind variable. For

RE: :Oracle userenv('TERMINAL')

Not sure about setting terminal but if all you want to do is identify what is going on from v$session or something then check out DBMS_APPLICATION_INFO package. You can set various things that allow you to track how your code is proceeding etc HTH Ken. > -Original Message- > From: [EMAI