RE: MySQL question
> > How do you do that, using DBI without mysql.pm ? I don't actually, it's just that it all came as one big happy setup on my server so I didn't have to install a bunch of different things . In fact I think on every server I've set up it is installed with perl or the os or something as I've never had to install it myself. It was just magically there evry time. I do use mysql.pm I just do Use DBI; $dh->connect(...:mysql:); Sorry if I was confusing, didn't mean to be. :) Dan > > Best regards, > > Stephan > > Am Freitag, 7. Februar 2003 18:12 schrieb Dan Muey: > > Those are three different modules. You'll only need one and > if any of > > the others are needed for it to work it will tel you on install. > > > > I use DBI, it's pretty cool. > > > > > -Original Message- > > > From: Barone, Philip [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, February 07, 2003 11:09 AM > > > To: [EMAIL PROTECTED] > > > Subject: MySQL question > > > > > > > > > Can someone tell me the necessary modules needed to > access a MySQl > > > database using DBD/DBI? > > > > > > Looking in CPAN my guess is from what I find there is: > > > > > > DBI-1.32.tar.gz > > > DBD-mysql-2.1020.tar.gz > > > Msql-Mysql-modules-1.2219.tar.gz > > > > > > > > > Are these the modules I need? Is this the correct order? > > > > > > Thanks. > > -- > Stephan Harren > Manager Site Operations > MFN-IS > --- > Phone +49 69 90554 153 > Fax +49 69 90554 111 > Cell +49 173 7011126 > >
Re: MySQL question
How do you do that, using DBI without mysql.pm ? Best regards, Stephan Am Freitag, 7. Februar 2003 18:12 schrieb Dan Muey: > Those are three different modules. You'll only need one and if any of the > others are needed for it to work it will tel you on install. > > I use DBI, it's pretty cool. > > > -Original Message- > > From: Barone, Philip [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 07, 2003 11:09 AM > > To: [EMAIL PROTECTED] > > Subject: MySQL question > > > > > > Can someone tell me the necessary modules needed to access a > > MySQl database using DBD/DBI? > > > > Looking in CPAN my guess is from what I find there is: > > > > DBI-1.32.tar.gz > > DBD-mysql-2.1020.tar.gz > > Msql-Mysql-modules-1.2219.tar.gz > > > > > > Are these the modules I need? Is this the correct order? > > > > Thanks. -- Stephan Harren Manager Site Operations MFN-IS --- Phone +49 69 90554 153 Fax +49 69 90554 111 Cell +49 173 7011126
RE: MySQL question
Thanks guys for the quick response, I will use the first 2 and look for the more recent DBD-mysql-2.1024 that Will suggested. > -Original Message- > From: Gary Stainburn [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 07, 2003 12:16 PM > To: Barone, Philip; [EMAIL PROTECTED] > Subject: Re: MySQL question > > > On Friday 07 Feb 2003 5:09 pm, Barone, Philip wrote: > > Can someone tell me the necessary modules needed to access > a MySQl database > > using DBD/DBI? > > > > Looking in CPAN my guess is from what I find there is: > > > > DBI-1.32.tar.gz > > DBD-mysql-2.1020.tar.gz > > Msql-Mysql-modules-1.2219.tar.gz > > You will need the first two, installed in that order. I > don't know what the > third one does - it may be usefill it may not, but the first > two should do > everything you need. > > > > > > > Are these the modules I need? Is this the correct order? > > > > Thanks. > > -- > Gary Stainburn > > This email does not contain private or confidential material as it > may be snooped on by interested government parties for unknown > and undisclosed purposes - Regulation of Investigatory Powers > Act, 2000 >
RE: MySQL question
just install DBI and DBD::mysql You should be good to go from there. >>> "Dan Muey" <[EMAIL PROTECTED]> 02/07/03 10:12AM >>> Those are three different modules. You'll only need one and if any of the others are needed for it to work it will tel you on install. I use DBI, it's pretty cool. > -Original Message- > From: Barone, Philip [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 07, 2003 11:09 AM > To: [EMAIL PROTECTED] > Subject: MySQL question > > > Can someone tell me the necessary modules needed to access a > MySQl database using DBD/DBI? > > Looking in CPAN my guess is from what I find there is: > > DBI-1.32.tar.gz > DBD-mysql-2.1020.tar.gz > Msql-Mysql-modules-1.2219.tar.gz > > > Are these the modules I need? Is this the correct order? > > Thanks. > > > > > > >
Re: MySQL question
On Friday 07 Feb 2003 5:09 pm, Barone, Philip wrote: > Can someone tell me the necessary modules needed to access a MySQl database > using DBD/DBI? > > Looking in CPAN my guess is from what I find there is: > > DBI-1.32.tar.gz > DBD-mysql-2.1020.tar.gz > Msql-Mysql-modules-1.2219.tar.gz You will need the first two, installed in that order. I don't know what the third one does - it may be usefill it may not, but the first two should do everything you need. > > > Are these the modules I need? Is this the correct order? > > Thanks. -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
RE: MySQL question
Those are three different modules. You'll only need one and if any of the others are needed for it to work it will tel you on install. I use DBI, it's pretty cool. > -Original Message- > From: Barone, Philip [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 07, 2003 11:09 AM > To: [EMAIL PROTECTED] > Subject: MySQL question > > > Can someone tell me the necessary modules needed to access a > MySQl database using DBD/DBI? > > Looking in CPAN my guess is from what I find there is: > > DBI-1.32.tar.gz > DBD-mysql-2.1020.tar.gz > Msql-Mysql-modules-1.2219.tar.gz > > > Are these the modules I need? Is this the correct order? > > Thanks. > > > > > > >
Re: MySQL question
them will do it, alone with Perl :)... naturally. MikeBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Original Message - From: "Barone, Philip" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 11:09 AM Subject: MySQL question > Can someone tell me the necessary modules needed to access a MySQl database > using DBD/DBI? > > Looking in CPAN my guess is from what I find there is: > > DBI-1.32.tar.gz > DBD-mysql-2.1020.tar.gz > Msql-Mysql-modules-1.2219.tar.gz > > > Are these the modules I need? Is this the correct order? > > Thanks. > > > > > >
Re: MySQL Question
Hi. - Original Message - From: "Mark Riehl" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 15, 2002 11:23 AM Subject: MySQL Question > All - Running ActiveState under Win2k. I've got a Tk script that acts as a > front end for SQL queries, and I'm using dump_results. (snip) > my $csv; > my $SH = IO::Scalar->new(\$csv); > my $rows = $sth->dump_results(80, "\n", ",", $SH); > $SH->close; > > I get the following in the console: > > $sql_statement = SELECT * FROM network > Database handle destroyed without explicit disconnect at > C:/Perl/site/lib/Tk.pm > line 217. > Tk::Error: Not a GLOB reference at C:/Perl/site/lib/DBI.pm line 614. This line tells you what is happened. You should set GLOB reference (not IO object). How about this?(cf. perldoc IO::Scalar) my $csv; my $SH = tie *OUT, 'IO::Scalar', \$csv; #my $SH = IO::Scalar->new(\$csv); my $rows = $sth->dump_results(80, "\n", ",", \*OUT); $SH->close; print $csv; == Kawai, Takanori(Hippo2000) Mail: [EMAIL PROTECTED] [EMAIL PROTECTED] http://member.nifty.ne.jp/hippo2000 ==
Re: MySQL Question
At 21:23 -0500 1/14/02, Mark Riehl wrote: >All - Running ActiveState under Win2k. I've got a Tk script that acts as a >front end for SQL queries, and I'm using dump_results. > >print "\$sql_statement = $sql_statement\n"; >my $sth = $dbh->prepare($sql_statement); > ># the sql result is store in $sth >$sth->execute() >or die "Can't execute SQL statement : $dbh->errstr"; > >my $csv; >my $SH = IO::Scalar->new(\$csv); >my $rows = $sth->dump_results(80, "\n", ",", $SH); >$SH->close; > >I get the following in the console: > >$sql_statement = SELECT * FROM network >Database handle destroyed without explicit disconnect at >C:/Perl/site/lib/Tk.pm >line 217. >Tk::Error: Not a GLOB reference at C:/Perl/site/lib/DBI.pm line 614. >[\&main::run_query] >Tk callback for .button >Tk::__ANON__ at C:/Perl/site/lib/Tk.pm line 217 >Tk::Button::butUp at C:/Perl/site/lib/Tk/Button.pm line 111 >(command bound to event) >I establish the connection and successfully make the query - I can see the >results when I have the trace on, but I can't seem to track down the >problem. Works fine locally, problem using it remotely. Account, password, >and permissions are correct, no firewalls. >Any suggestions? $dbh->disconnect(); at the end of your script. You never close the connection. > >Thanks, >Mark > >- >Mark Riehl >Agile Communications, Inc. >Email: [EMAIL PROTECTED] >Office: (732) 528-9305 >Fax: (732) 528-9308 >Cell: (732) 996-7630
