Re: Perl/MySQL question...

2003-07-15 Thread William R. Mussatto
> I am not sure if this is a Perl/DBI question specifically or not, > but here goes... I seem to remember reading somewhere that you could > return the value of an "auto-increment" field during an INSERT operation > on a MySQL database. Is this just wishful thinking on my part or does > thi

Re: Perl/MySQL question...

2003-07-15 Thread Andy Hassall
NIPP, SCOTT V (SBCSI) wrote: > I am not sure if this is a Perl/DBI question specifically or not, > but here goes... I seem to remember reading somewhere that you could > return the value of an "auto-increment" field during an INSERT > operation on a MySQL database. Is this just wishful thinking o

Perl/MySQL question...

2003-07-15 Thread NIPP, SCOTT V (SBCSI)
I am not sure if this is a Perl/DBI question specifically or not, but here goes... I seem to remember reading somewhere that you could return the value of an "auto-increment" field during an INSERT operation on a MySQL database. Is this just wishful thinking on my part or does this sound

RE: MySQL question

2003-02-07 Thread Dan Muey
inal 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 modul

Re: MySQL question

2003-02-07 Thread Stephan Harren
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

RE: MySQL question

2003-02-07 Thread Barone, Philip
IL 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:

RE: MySQL question

2003-02-07 Thread Ian Harisay
n 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

Re: MySQL question

2003-02-07 Thread Gary Stainburn
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 n

RE: MySQL question

2003-02-07 Thread Dan Muey
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.t

Re: MySQL question

2003-02-07 Thread Mike Blezien
] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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

MySQL question

2003-02-07 Thread Barone, Philip
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

2002-01-14 Thread KAWAI,Takanori
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 qu

Re: MySQL Question

2002-01-14 Thread Paul DuBois
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 $s

MySQL Question

2002-01-14 Thread Mark Riehl
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 SQ

Thanks All RE: A little Mysql question

2001-03-17 Thread Dexter Coehlo
and very > limited. You would be well advised to learn the ANSI syntax for joins, and > use it. It will make your programs more portable, your queries less > ambiguous, and when you grow accustomed to the syntax, it will make complex > queries MUCH MUCH easier to read, and (if necessary) to d

RE: A little Mysql question

2001-03-17 Thread Steve Howard
Original Message- From: Dexter Coehlo [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 3:29 PM To: [EMAIL PROTECTED] Subject: A little Mysql question Hi folks, whats the syntax to select from 2 tables using MySQl. I tried select from regusers,unregusers where email="name" Dexter

Re: A little Mysql question

2001-03-16 Thread Brett W. McCoy
On Thu, 15 Mar 2001, Dexter Coehlo wrote: > whats the syntax to select from 2 tables using MySQl. > > I tried select from regusers,unregusers where email="name" This is basic stnadard SQL and not MySQL specific. If both tbales have a field called 'email', you are going to get ambiguities, so y

A little Mysql question

2001-03-16 Thread Dexter Coehlo
Hi folks, whats the syntax to select from 2 tables using MySQl. I tried select from regusers,unregusers where email="name" Dexter