Re: Thanks All on How to get last insert id using DBI

2001-06-07 Thread Dexter
I tried the $->{insertid} It does look alfully weird Ha, Ha Imeant $sth->{insert_id} I know when using PHP , simply uses the insert_id() function . thanks Dexter *** I suppose not, it looks pretty weird. You might have better luck with:

How to get last insert id using DBI

2001-06-07 Thread Dexter
How do I get the last insert using DBi. I tried the $->{insertid} but that doesnt work. Thanks Dexter

Re: Anyone else experiencing problems with the dbi-* mailing lists?

2001-06-07 Thread Dexter
Hi Ed,You're right compared to a a couple weeks ago . I got a ton of emails and its substantially fallen off. I see a good number unsubscribing. Dexter - Original Message - From: "Edward J. Sabol" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, Ju

Re: Mysq.cnf says the correct dir for mysql.sock but dbi is looking at /temp/mysql.sock

2001-06-01 Thread Dexter
Thanks Again All, But does someone know if there is a config file for th DBImodule or foe DBD.pm/ Dexter - Original Message - From: "Greg Meckes" <[EMAIL PROTECTED]> To: "Dexter" <[EMAIL PROTECTED]>; "David Block" <[EMAIL PROTECTED]> C

Mysq.cnf says the correct dir for mysql.sock but dbi is looking at /temp/mysql.sock

2001-06-01 Thread Dexter
in the DBi mod spec. /temp/mysql.sock. Thanks Dexter Original Message - From: "David Block" <[EMAIL PROTECTED]> To: "Dexter" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 11:30 AM Subject: Re: Can't connect to local

Where is /temp/mysql.sock specified in the DBI mods ?

2001-06-01 Thread Dexter
I have mysql.sock in another dir other than/temp . A link (redirect) to it failed. Where is it specified in the dbi module , this default socket dir. This is on red hat Linux Thanks Dexter Coelho [EMAIL PROTECTED]

Simple question Perlsters-converting to unix time

2001-05-12 Thread Dexter Coelho
Perlsters, I remember seeing a a function timelocal that took a date ,month,day,year and converted it to a unix seconds time , the reverse to localtime. Am i correct on this? Thanks Dexter

Help! Can't cant re-install Mysql

2001-04-02 Thread Dexter Coelho
stall easily but when it finds previous install , it exits. There must a file it looks for , a config file that I probably can delete. Dexter

Need to reinstall mySQl

2001-03-31 Thread Dexter Coehlo
admin privs. I used a linux cobalt distribution , On re install it says its already installed . What hould be deleted for the re install to work? Thanks Dexter

Re: Can PHP use Perl

2001-03-28 Thread Dexter Coehlo
One other question to educate myself, mod_perl and Fast CGI. Is there much change in regualr Perl syntax or is it the same , just a different technology? I remeber considering mod_Perl to sustain db connection. Dexter On Wed, 28 Mar 2001, Curt Russell Crandall wrote: > First of all,

Re: Can PHP use Perl

2001-03-28 Thread Dexter Coehlo
The reason for using Perl I thought was because I thougt PHP was like ASP which was a technology with some tags to put another language code like perl into but I learned it is a language in itself. Dexter On Wed, 28 Mar 2001, Curt Russell Crandall wrote: > First of all, I'm not an e

Can PHP use Perl

2001-03-28 Thread Dexter Coehlo
tags. Thanks for helping Dexter

Problem with Perl forking process

2001-03-27 Thread Dexter Coelho
forking. It appears there's a forking process happening. Thanks Dexter sub adminsendall { $pid= fork(); if($pid==0) { my $dbh = $drh->connect( $multidbname,$dbusername,$dbpassword ) or die "Unable to connect to Product Category database"; $sth = $dbh->prepare("

RE: Perl Forking process- some code

2001-03-27 Thread Dexter Coelho
Here's the sub..Its pretty simple. Its supposed to do emails and show the "Sent emails " page right away but it seems the page is being displayed a substantial time later after it seems the emails are sent but it appers ther's a forking process happening. Thanks Dexter

Fellow dbi users simple fork prob.

2001-03-27 Thread Dexter Coehlo
nue should the parent which displays the "Emails sent " screen discontinue and i believe that what should happen. Thanks Dexter

Thanks All RE: A little Mysql question

2001-03-17 Thread Dexter Coehlo
Thank You all fellow Perlsters for your feedback. Dexter Coelho On Sat, 17 Mar 2001, Steve Howard wrote: > The question is perhaps a little more complex than you intended it to be. > There are a number of different types of joins, and two different types of > syntaxes. The exampl

MySQl-selecting from mult. tables

2001-03-16 Thread Dexter Coehlo
Hi fellow Persters, An easy quest. How to select a field from multiple tables(the syntax for MySQl) I tried select from table1,table1, where useremail="$email" Thanks Dexter

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

Any Java list ? fellow Perlsters Thanks

2001-02-21 Thread Dexter Coelho
Hi fellow Perlsters, I also want to join a Java list. Can you reccomend some goods ones and where to go? Dexter