perl dbi

How to delete a photo from a blog?

Hello Guest

• Login
• Register…
• Start blog

• Who, Where, When
• What can I do?
• What to Read?

• Polls
• Avatars
• Interests

• Cities and Countries
• Random blog
• Users search

• Search
• Games
• Tests
• QAIX

• Сообщества
• Talxy Chat
• Horoscope
• Online

Зарегистрируйся!

QAIX > Perl web-programming > perl dbi 18 July 2008 20:30:17

Recent blog posts:

Free iPod nano raffle for…
Aimersoft 2008 Christmas promotion: "Free iPod nano raffle for Chrismas" and "Buy 1 Get…

How to convert Rhapsody to…
Music purchased from Rhapsody is under DRM protection, which stops customers from playing the downloaded…

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded…

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

They have birthday today:

xiongchong

henna diah

все >>

Forums:

topic feeds

• QAIX all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous

Discuss:

why infix:<div>:(Int, Int…
HaloO, I realized from the typed literal thread that S03 now explicitly states that div on two Ints…

[rt.cpan.org #41329] VMS…
<URL: http://rt.cpan.org/Ticket/Display.html?id=41329 > Thanks, applied

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…

Files, Directories, Resources…
The S16: chown, chmod thread seems to be too unix-focussed. Perl6 is being born in a world dominated by…

Support for ensuring invariants…
Hi all, I occasionally find myself annoyed at having to do something like this (I use Perl5 vernacular…

Recent forum topics:

Recent forum comments:

RE: Updating A Portion Of A Site
Thanks! I remembered just before I came back to check. It's amazing the things you forget. Thanks…

RE: Updating A Portion Of A Site
Use a FrontPage include file - see Help on Included Content. Or, if all pages are asp or PHP, use a…

RE: Index Files
What they are telling you is the home page of your site (before you publish it) must be named index.htm…

RE: Website diifers from local copy
I see it as a 40x68 icon (clear your cache) - as for the position check w/ Google API help Neither issue…

RE: Forced submit
"Ellie" <ellymay999nospam@nospamnetzero.com> wrote in message…

RE: access denied
IUSR account doesn't have access to cmd.exe by default (assuming you are using anonymous…

RE: access denied
Hey guys, I'm totally out of my league here, I don't even know how I got stuck with this problem, it's…

RE: Forced submit
Ellie wrote on 05 sep 2008 in microsoft.public.inetserver.asp.general: You cannot…

RE: [patch@34995] vms.c - Memory…
On Wed, Dec 3, 2008 at 7:38 PM, John E. Malmberg <wb8tyw@qsl.net> wrote: Thanks, applied as…

RE: why infix:<div>:(Int, Int…
On Thu, Dec 4, 2008 at 3:26 PM, David Green <david.green@telus.net> wrote: Using…

Moderators:

Administrator
Protorioris


perl dbi
Christopher Burger 18 July 2008 20:30:17
	Hello, I using the perl dbi and mysql and I was wondering if their was a load command with this. The following statement works with php LOAD DATA LOCAL INFILE '$file_location' INTO TABLE $table FIELDS TERMINATED BY ',' However I can not get the same command to work in perl. Any answers would be appreciated. Chris Burger
		Add comment


Rajsekar R 31 May 2006 17:45:37 [ permanent link ]
	Hi , how do i ensure that DBI is installed in my machine.. will it be automatically installed when perl is installed... i am getiing error when i start using use DBI; and i need to connet to ORACLE DATABASE. please help me regding this issue.. regds R . Rajasekar
		Add comment


Chris Werner 31 May 2006 18:15:26 [ permanent link ]
	Hello, R . Rajasekar perl -e 'use DBI;' I would ask what platform you are using that does not have perl installed? Most unix platforms will already have a default installation of perl and DBI. If you are installing on windows, you will likely use ActiveState; it has been a while since I installed active state, but I seem to recall that it installed DBI. Oracle and the DBD driver are another story. DBD::Oracle will be required to use DBI to connect to an Oracle database. No, this is not likely installed on a default installation. Perhaps you could post more information: platform, error message, connection code... Hope this helps, Christian Werner -----Original Message----- Hi , how do i ensure that DBI is installed in my machine.. will it be automatically installed when perl is installed... i am getiing error when i start using use DBI; and i need to connet to ORACLE DATABASE. please help me regding this issue.. regds R . Rajasekar
		Add comment


David Landgren 31 May 2006 18:22:29 [ permanent link ]
	Chris Werner wrote:> Hello, R . Rajasekar> perl -e 'use DBI;'> I would ask what platform you are using that does not have perl installed?> Most unix platforms will already have a default installation of perl and> DBI. If you are installing on windows, you will likely use ActiveState; it> has been a while since I installed active state, but I seem to recall that> it installed DBI. DBI is not core. You have to install it from CPAN or via ppm on ActiveState. David -- Much of the propaganda that passes for news in our own society is given to immobilising and pacifying people and diverting them from the idea that they can confront power. -- John Pilger
		Add comment


Ron Reidy 31 May 2006 18:32:24 [ permanent link ]
	Neither DBI nor DBD::Oracle are installed as part of the Perl distro. To see if either module is installed: $ perl -MDBI -e '0' $ perl -MDBD::Oracle -e '0' If you need to install either module, google will be your friend. -----Original Message----- From: R, Rajsekar [mailto:Rajasekar.R@ps.net] Sent: Wednesday, May 31, 2006 7:46 AM To: dbi-users@perl.org Subject: perl- dbi Hi , how do i ensure that DBI is installed in my machine.. will it be automatically installed when perl is installed... i am getiing error when i start using use DBI; and i need to connet to ORACLE DATABASE. please help me regding this issue.. regds R . Rajasekar This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
		Add comment


Jonathan Leffler 31 May 2006 20:01:40 [ permanent link ]
	On 5/31/06, R, Rajsekar <Rajasekar.R@ps.net> wrote:> how do i ensure that DBI is installed in my machine..> will it be automatically installed when perl is installed...> i am getiing error when i start using use DBI;> and i need to connet to ORACLE DATABASE. You've received a few workable answers - but there's a better one. perl -MDBI -e 'print "$DBI::VERSION\n"' This tells you which version of DBI you have installed - which can be even more valuable than simply knowing that DBI is installed. Similarly: perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERSION\n"' Similarly for any other (civilized) module - whether in the DBI/DBD collection or not. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
		Add comment


Philip Garrett 31 May 2006 20:06:20 [ permanent link ]
	-----Original Message----- From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com] Sent: Wednesday, May 31, 2006 12:02 PM To: R, Rajsekar Cc: dbi-users@perl.org Subject: Re: perl- dbi> On 5/31/06, R, Rajsekar <Rajasekar.R@ps.net> wrote:> > how do i ensure that DBI is installed in my machine..> > will it be automatically installed when perl is installed...> > i am getiing error when i start using use DBI; and i need to connet to ORACLE DATABASE.> You've received a few workable answers - but there's a better one.> perl -MDBI -e 'print "$DBI::VERSION\n"' Or this: perl -MDBI -e 'DBI->installed_versions' which tells you what DBD modules are installed, and the versions of pretty much anything that matters to DBI, as someone recently pointed out to me. E.g.: $ perl -MDBI -e 'DBI->installed_versions' Perl : 5.008003 (i586-linux-thread-multi) OS : linux (2.6.5) DBI : 1.50 DBD::Sponge : 11.10 DBD::SQLite : 1.11 DBD::SQLRelay : 0.37 DBD::Proxy : install_driver(Proxy) failed: Can't locate RPC/PlClient.pm in @INC DBD::Oracle : 1.17 DBD::File : 0.33 DBD::ExampleP : 11.12 DBD::DBM : 0.03 Philip
		Add comment


Jeff Zucker 31 May 2006 20:09:48 [ permanent link ]
	Jonathan Leffler wrote:> You've received a few workable answers - but there's a better one.> perl -MDBI -e 'print "$DBI::VERSION\n"'> This tells you which version of DBI you have installed - which can be> even more valuable than simply knowing that DBI is installed.> Similarly:> perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERSION\n"' And here's an even better one, assuming a relatively modern DBI: perl -MDBI -e "DBI->installed_versions" That tells you the versions of DBI, Perl, OS, and all DBDs installed. -- Jeff
		Add comment


Rajsekar R 1 June 2006 13:55:04 [ permanent link ]
	Hi, I am getting this error . please let me know.. what needs to be done further perl -MDBI -e 'print "$DBI::VERSION\n"' Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .). BEGIN failed--compilation aborted. Regds, R.Rajasekar ________________________________ From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com] Sent: Wed 31/05/2006 21:31 To: R, Rajsekar Cc: dbi-users@perl.org Subject: Re: perl- dbi On 5/31/06, R, Rajsekar <Rajasekar.R@ps.net> wrote:> how do i ensure that DBI is installed in my machine..> will it be automatically installed when perl is installed...> i am getiing error when i start using use DBI;> and i need to connet to ORACLE DATABASE. You've received a few workable answers - but there's a better one. perl -MDBI -e 'print "$DBI::VERSION\n"' This tells you which version of DBI you have installed - which can be even more valuable than simply knowing that DBI is installed. Similarly: perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERSION\n"' Similarly for any other (civilized) module - whether in the DBI/DBD collection or not. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
		Add comment


Jonathan Leffler 1 June 2006 18:55:55 [ permanent link ]
	On 6/1/06, R, Rajsekar <Rajasekar.R@ps.net> wrote:> I am getting this error . please let me know.. what needs to be done further> perl -MDBI -e 'print "$DBI::VERSION\n"'> Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .).> BEGIN failed--compilation aborted. Download, compile and install DBI. And the driver for the DBMS you plan to use. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
		Add comment


Jonathan Leffler 1 June 2006 18:57:59 [ permanent link ]
	On 6/1/06, Jonathan Leffler <jonathan.leffler@gmail.com> wrote:> On 6/1/06, R, Rajsekar <Rajasekar.R@ps.net> wrote:> > I am getting this error . please let me know.. what needs to be done further> > perl -MDBI -e 'print "$DBI::VERSION\n"'> > Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .).> > BEGIN failed--compilation aborted.> Download, compile and install DBI. And the driver for the DBMS you plan to use. And, since you're using a seriously down-version of Perl, you need to get yourself a sufficiently old version of DBI - one that will work with Perl 5.5.3; the current version requires 5.6.1. You'd be best off getting Perl 5.8.8 and redoing all the modules. It'll be harder in the short term, but you might not need to do it again for another 3 years. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
		Add comment


Will Rutherdale 5 June 2006 23:25:36 [ permanent link ]
	If one wanted to get up to date for a while on a Perl-DBI-Informix combo, would this be a good set of versions: Perl 5.8.8 DBI 1.50 DBD::Informix 2005.02 We're not changing Informix itself at this point. Just wanted to recap versions for Perl and libraries based on what's been mentioned in this list and what I've seen on CPAN. The OS is Sun. -Will -----Original Message-----> From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com] > Sent: Thursday 01 June 2006 10:58> To: R, Rajsekar> Cc: dbi-users@perl.org> Subject: Re: perl- dbi> And, since you're using a seriously down-version of Perl, you need to> get yourself a sufficiently old version of DBI - one that will work> with Perl 5.5.3; the current version requires 5.6.1.> You'd be best off getting Perl 5.8.8 and redoing all the modules.> It'll be harder in the short term, but you might not need to do it> again for another 3 years.> - - - - - Appended by Scientific Atlanta, a Cisco company - - - - - This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.
		Add comment


Jonathan Leffler 5 June 2006 23:29:19 [ permanent link ]
	On 6/5/06, Rutherdale, Will <Will.Rutherdale@sciatl.com> wrote:> If one wanted to get up to date for a while on a Perl-DBI-Informix> combo, would this be a good set of versions:> Perl 5.8.8> DBI 1.50> DBD::Informix 2005.02> We're not changing Informix itself at this point. Just wanted to recap> versions for Perl and libraries based on what's been mentioned in this> list and what I've seen on CPAN. The OS is Sun. Those are all the most recent versions, though Tim is preparing a DBI 1.51 release. That's what I have on my Solaris machine at the office. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
		Add comment


Gene Golub 18 July 2008 06:19:33 [ permanent link ]
	Hi Tim I read your post on http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/index.htm. Thank you for the great information. I was using korn shell for years. few things I do not see there is: 1. how do you process procedures 2. what if I have multiple select or exec statements? Can dump output to file and process it in awk or egrep manner? thank you, Gene.
		Add comment


Douglas Wilson 18 July 2008 20:30:17 [ permanent link ]
	On Thu, Jul 17, 2008 at 7:19 PM, gene golub <gene_golub@hotmail.com> wrote: 1. how do you process procedures Often the same or nearly the same way you process other SQL statements. There are often examples in the DBD::* (whatever DBD you are using) documentation. 2. what if I have multiple select or exec statements? Can dump output to file and process it in awk or egrep manner? You're not very clear here. Yes you can execute multiple statements...with multiple calls to execute(). You can pretty easily output results to a file, there are probably even modules to make it even easier. HTH, Douglas Wilson
		Add comment

QAIX > Perl web-programming > perl dbi 18 July 2008 20:30:17

	see also: DIV visiblility Notification… initdb failure with PostgreSQL 7.3.2 /… [ROOT] Urgent message		пройди тесты: What is Your Temperament?		see also: Presentation Konichi-wa )))))))))))))))))))))

Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:

If you would like to report an abuse of our service, such as a spam message, please .




Get comments by e-mail Add to favourites

Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

perl dbi

Add new comment