Re: Installing Perl DBD, DBI::mysql Modules

2009-02-27 Thread Francisco Valladolid
ow can I install Perl DBD, DBI::mysql > Modules > > I have an Intel Mac OS X (10.5.6) Leopard with Perl v5.8.8 built for > darwin-thread-multi-2level > -- Francisco Valladolid H. -- http://bsdguy.net - Jesus Christ follower. -- To unsubscribe, e-mail: beginners-unsubscr...@

Installing Perl DBD, DBI::mysql Modules

2009-02-27 Thread juliaaaa . 1
Hi there, I would like to know how can I install Perl DBD, DBI::mysql Modules I have an Intel Mac OS X (10.5.6) Leopard with Perl v5.8.8 built for darwin-thread-multi-2level

Re: Perpare statements v. Interpolated SQL in DBI/MySQL: Does prepare really help?

2005-06-18 Thread Peter Scott
On Fri, 17 Jun 2005 18:15:13 -0600, Siegfried Heintze wrote: > Does MySQL/DBI really parse SQL statements in advance? I've been using > mostly interpolated SQL statements in my screen scraping bot that is > implemented with multiple threads and HTML::Parser. As you might now, > HTML::Parser calls y

Perpare statements v. Interpolated SQL in DBI/MySQL: Does prepare really help?

2005-06-17 Thread Siegfried Heintze
Does MySQL/DBI really parse SQL statements in advance? I've been using mostly interpolated SQL statements in my screen scraping bot that is implemented with multiple threads and HTML::Parser. As you might now, HTML::Parser calls your code and you have to figure out how to save statement in between

RE: DBI MYSQL

2003-11-13 Thread Dan Muey
ave it narrowed down eh? Cool HAGO, DMuey > Thanks for everybody's help !!! > > // Larry > > > -Original Message- > From: Dan Muey [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 12, 2003 3:59 PM > To: Tore Aursand; [EMAIL PROTECTED] > Subject: R

RE: DBI MYSQL

2003-11-13 Thread Larry Sandwick
2003 3:59 PM To: Tore Aursand; [EMAIL PROTECTED] Subject: RE: DBI MYSQL >> $dsn = "DBI:mysql:webmaster,blackhole"; This comma still throws me. Try DBI:mysql:webmaster:blackhole Also if you do this from the command line what happens after you put in the password you h

RE: DBI MYSQL

2003-11-12 Thread Dan Muey
>> $dsn = "DBI:mysql:webmaster,blackhole"; This comma still throws me. Try DBI:mysql:webmaster:blackhole Also if you do this from the command line what happens after you put in the password you have in your script? $ mysql -u yourusernamehere -p -h blackhole webmaster > What Tore said is t

Re: DBI MYSQL

2003-11-12 Thread Tore Aursand
On Wed, 12 Nov 2003 13:48:26 -0500, Larry Sandwick wrote: > #! /usr/bin/perl Always: use strict; use warnings; > use DBD::mysql; No need to. DBI will take care of this (when you declary the database type to be 'mysql'). > $dsn = "DBI:mysql:webmaster,blackhole"; my $dsn = "DBI:mysql:dat

RE: DBI MYSQL

2003-11-12 Thread Dan Muey
> > DBI connect('webmaster,blackhole','webmaster',...) failed: Access > > denied for user: '[EMAIL PROTECTED]' (Using password: YES) at > > ./data_loader.pl line 8 > > Try with a semi-column instead of the comma: > $dsn = "DBI:mysql:database=webmaster;host=blackhole"; While you're at it try: D

RE: DBI MYSQL

2003-11-12 Thread Dan Muey
> Le mer 12/11/2003 à 19:48, Larry Sandwick a écrit : > > > [EMAIL PROTECTED] mysql]$ ./data_loader.pl > > > > DBI connect('webmaster,blackhole','webmaster',...) failed: Access > > denied for user: '[EMAIL PROTECTED]' (Using password: YES) at > > ./data_loader.pl line 8 > > Does the comma stan

Re: DBI MYSQL

2003-11-12 Thread Yannick Warnier
Le mer 12/11/2003 à 19:48, Larry Sandwick a écrit : > [EMAIL PROTECTED] mysql]$ ./data_loader.pl > > DBI connect('webmaster,blackhole','webmaster',...) failed: Access denied > for user: '[EMAIL PROTECTED]' (Using password: YES) at > ./data_loader.pl line 8 Try with a semi-column instead of the c

Re: DBI MYSQL

2003-11-12 Thread Yannick Warnier
Le mer 12/11/2003 à 19:48, Larry Sandwick a écrit : > [EMAIL PROTECTED] mysql]$ ./data_loader.pl > > DBI connect('webmaster,blackhole','webmaster',...) failed: Access denied > for user: '[EMAIL PROTECTED]' (Using password: YES) at > ./data_loader.pl line 8 Does the comma standing between webmast

DBI MYSQL

2003-11-12 Thread Larry Sandwick
Update not happening ! I have a script that is running on computer A which is trying to update the database on computer B. The script tries to connect to computer B and fails with the following error. [EMAIL PROTECTED] mysql]$ ./data_loader.pl DBI connect('webmaster,blackhole','webmast

RE: dbi mysql question

2002-12-31 Thread Dan Muey
Answer my own question. Yes it is possible, no problem. My problem was an obscure infinite loop. So nevermind! Thanks Dan -Original Message- From: Dan Muey Sent: Tuesday, December 31, 2002 1:43 PM To: [EMAIL PROTECTED] Subject: dbi mysql question Does any one happen to know if it&#

dbi mysql question

2002-12-31 Thread Dan Muey
Does any one happen to know if it's possible to do a query within a query : For instance : This is for demonstartion purposes and is not executable code : prepare $sth ->$dbh... execute $sth ->$dbh $sth ->$dbh fetchrowarray { $sth2 ->$dbh prepare $sth 2->$dbh execute $sth 2->$dbh fe

Re: DBI mySQL and Sybase confusion

2002-05-20 Thread bernabe diaz
You need to download DBB module client for sybase or mysql. download the instruction , go to cspan and download fromthere good luck BD JASON CANNEY wrote: >I admit my newness first off. I am trying to connect to two databases. One is local >which is a mySQL database, and the other is a remo

DBI mySQL and Sybase confusion

2002-05-20 Thread JASON CANNEY
I admit my newness first off. I am trying to connect to two databases. One is local which is a mySQL database, and the other is a remote (same subnet) Sybase database. Does anyone have an idiot's guide - version of how I install the Sybase and mySql drivers as the solution to the error messa

RE: Need Perl/CGI/DBI/mysql Examples

2001-06-17 Thread Steve Howard
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 3:43 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Need Perl/CGI/DBI/mysql Examples Helo, I am relatively new to the whole perl/cgi thing. (my high school pascal class makes my ears bleed, and I needed something to ma

RE: Need Perl/CGI/DBI/mysql Examples

2001-06-17 Thread Steve Howard
is helps, Steve Howard -Original Message- From: Elaine -HFB- Ashton [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 4:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Need Perl/CGI/DBI/mysql Examples [EMAIL PROTECTED] [[EMAIL PROTECTED]] qu

Re: Need Perl/CGI/DBI/mysql Examples

2001-06-17 Thread Elaine -HFB- Ashton
[EMAIL PROTECTED] [[EMAIL PROTECTED]] quoth: *> *>I swear I wont be stealing anyones code for my own, all I want is just a *>"road map" for my own educational purposes. If anyone wouldn`t mind *>sharing or could point me in the right direction, it would be *immensely* *>appreciated! I was in the

Need Perl/CGI/DBI/mysql Examples

2001-06-17 Thread [EMAIL PROTECTED]
Helo, I am relatively new to the whole perl/cgi thing. (my high school pascal class makes my ears bleed, and I needed something to make my time worthwhile :) ) I don`t know about everyone, but the best way that I learn is by example. I am prone to falling asleep when reading as I bore easily (RT