om: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Thursday, May 09, 2013 12:10 PM
Cc: dbi-users@perl.org (dbi-users@perl.org)
Subject: Re: (Fwd) Perl DBI question
On May 9, 2013, at 10:47 AM, "Vancura, Mark D (Mark)"
wrote:
> Bruce,
> Thanks, the explanation makes sense, so I need
On May 9, 2013, at 10:47 AM, "Vancura, Mark D (Mark)"
wrote:
> Bruce,
> Thanks, the explanation makes sense, so I need to figure out how to follow
> through
> on this documented suggestion from: 6.1.6. Security Issues with LOAD DATA
> LOCAL
>
> *If you use LOAD DATA LOCAL in Perl scripts or
s where to look this up?
Thanks again for your help with this!
Mark Vancura
-Original Message-
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Thursday, May 09, 2013 11:26 AM
To: dbi-users@perl.org (dbi-users@perl.org)
Subject: Re: (Fwd) Perl DBI question
On May 9, 201
On May 9, 2013, at 9:37 AM, tim.bu...@pobox.com wrote:
>
> However, then I want to put data into it, with a command like the following:
>
>
>
> load data local infile 'TEMP_LOAD_DATA_26021' into table ports ;
>
>
>
> And I get:
>
> DBD::mysql::db do failed: The used command is not
- Forwarded message from "Vancura, Mark D (Mark)"
-
Date: Thu, 9 May 2013 11:05:37 -0400
From: "Vancura, Mark D (Mark)"
To: "tim.bu...@pobox.com"
Subject: Perl DBI question
Tim,
I am newly trying to make Perl and DBI work with mysql, with s
On 06/02/2010 04:17 PM, newbie01 perl wrote:
> Hi Peter,
>
> Yes, that is correct ... am referring to these commands ...
>
> If I already have the .sql file that has all the formatting in them, is it
> okay to just run @x.sql from the Perl DBI script ...
>
> BTW, you mentioned some "template too
Hi Peter,
Yes, that is correct ... am referring to these commands ...
If I already have the .sql file that has all the formatting in them, is it
okay to just run @x.sql from the Perl DBI script ...
BTW, you mentioned some "template toolkit", never heard of those ... can you
elaborate on them or
On 2010-05-30 17:33:39 +1200, newbie01 perl wrote:
> Am trying out DBI for Oracle and just want to know if for example, I need to
> include column formatting stuff etc., is it best to just put them into a
> .sql file and then execute the .sql file instead of placing them in the Perl
> DBI script?
On Sun, May 30, 2010 at 01:33, newbie01 perl wrote:
> Hi,
>
> Am trying out DBI for Oracle and just want to know if for example, I need to
> include column formatting stuff etc., is it best to just put them into a
> .sql file and then execute the .sql file instead of placing them in the Perl
> DBI
On Sun, May 30, 2010 at 1:33 AM, newbie01 perl wrote:
> Hi,
>
> Am trying out DBI for Oracle and just want to know if for example, I need
> to
> include column formatting stuff etc., is it best to just put them into a
> .sql file and then execute the .sql file instead of placing them in the
> Perl
Hi,
Am trying out DBI for Oracle and just want to know if for example, I need to
include column formatting stuff etc., is it best to just put them into a
.sql file and then execute the .sql file instead of placing them in the Perl
DBI script?
Also, is there anyway to sort of "hide" the password s
_sv: referenced symbol not found
Killed
[EMAIL PROTECTED]:[/home/glrecdev/icrs]>
Please advise
Thanks and Regards
Srinivas Katti
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/29/2008 06:05 PM
To
Srinivas KATTI/ia/[EMAIL PROTECTED]
cc
dbi-users@perl.org, [EMAIL PROTECTED]
Subject
Re: Pe
On Tue, Jul 29, 2008 at 06:10:30PM +0530, Amit Saxena wrote:
> On Tue, Jul 29, 2008 at 6:05 PM, Tim Bunce <[EMAIL PROTECTED]> wrote:
> > On Mon, Jul 28, 2008 at 08:36:23PM +0530, Srinivas KATTI wrote:
> > > I am working on perl assignment which is first perl code in our
> > > environment, i have co
Thanks a lot Tim, i am checking with Unix admin to do that and let's see
once done
Thanks again
Regards
Srinivas K
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/29/2008 06:05 PM
To
Srinivas KATTI/ia/[EMAIL PROTECTED]
cc
dbi-users@perl.org, [EMAIL PROTECTED]
Subject
Re: Perl+DBI que
TECTED]
cc
dbi-users@perl.org
Subject
Re: Perl+DBI question [C1]
On Mon, Jul 28, 2008 at 8:06 AM, Srinivas KATTI <[EMAIL PROTECTED]>
wrote:
I am working on perl assignment which is first perl code in our
environment, i have come across following problem, pls if you could
provide your ex
On Tue, Jul 29, 2008 at 6:05 PM, Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Mon, Jul 28, 2008 at 08:36:23PM +0530, Srinivas KATTI wrote:
> > Hi
> >
> > I am working on perl assignment which is first perl code in our
> > environment, i have come across following problem, pls if you could
> > provide
On Mon, Jul 28, 2008 at 08:36:23PM +0530, Srinivas KATTI wrote:
> Hi
>
> I am working on perl assignment which is first perl code in our
> environment, i have come across following problem, pls if you could
> provide your expert consultansy it will be great help to me
>
> I am trying to use DB
On 2008-07-28 20:36:23 +0530, Srinivas KATTI wrote:
> I am working on perl assignment which is first perl code in our
> environment, i have come across following problem, pls if you could
> provide your expert consultansy it will be great help to me
>
> I am trying to use DBI in my program (simp
On Mon, Jul 28, 2008 at 8:06 AM, Srinivas KATTI <[EMAIL PROTECTED]>wrote:
> I am working on perl assignment which is first perl code in our
> environment, i have come across following problem, pls if you could
> provide your expert consultansy it will be great help to me
>
> I am trying to use DBI
Hi
I am working on perl assignment which is first perl code in our
environment, i have come across following problem, pls if you could
provide your expert consultansy it will be great help to me
I am trying to use DBI in my program (simple program), below is the piece
of code
***
On 2008-06-20 10:08:11 -0500, Curtis Leach wrote:
> Thanks for all the responses.
>
> Looks like I may have to go with a CSV type solution.
That's probably the safest route, as long as you make sure that you
don't lose data when exporting to CSV (check for character sets, binary
data, etc.)
> T
urtis Leach
Cc: dbi-users@perl.org
Subject: RE: Generic DBI question about backups
Maybe I'm missing something here, but isn't this simply a matter of
using DBD::CSV? You could open two dbi handles, one to your existing
Oracle db and the other to a csv db. Read from the one, write to t
Or at least keep a complete oracle export on hand in case your final
plans fall through and you need to
play hero by recreating the old database.
Jeffrey Seger wrote:
Is this a business critical database? If so, I would go back to the
business and make an argument that the current database not
cessary, but as usual there's more than one way to do it.
-Will
> -Original Message-
> From: Curtis Leach [mailto:[EMAIL PROTECTED]
> Sent: Thursday 19 June 2008 14:54
> To: [EMAIL PROTECTED]
> Cc: dbi-users@perl.org
> Subject: RE: Generic DBI question about back
Hi Curtis
> export to CSV and use DBD::CSV?
Or, as a last resort, use Perl :-)
http://search.cpan.org/~rsavage/DBIx-Admin-BackupRestore-1.10/
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
L PROTECTED]
> Sent: Thursday 19 June 2008 17:11
> To: Curtis Leach
> Cc: dbi-users@perl.org
> Subject: Re: Generic DBI question about backups
>
> Is this a business critical database? If so, I would go back to the
> business and make an argument that the current database not
> b
Is this a business critical database? If so, I would go back to the
business and make an argument that the current database not be allowed to go
away till the new database is in place, migrated and tested. Regardless of
the tool you use to migrate it, you will run the risk of data loss if the
old
le databases.
>
> Curtis
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2008 1:33 PM
> To: Curtis Leach
> Cc: dbi-users@perl.org
> Subject: Re: Generic DBI question about backups
>
> I guess I'd be
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> My big problem is that the new database hasn't been selected yet & the
> our only Oracle database will be gone by the time one is selected.
> Which was the reason for the need of a database independent solution. I
> won't be able to load it b
Curtis Leach wrote:
My big problem is that the new database hasn't been selected yet & the
our only Oracle database will be gone by the time one is selected.
Which was the reason for the need of a database independent solution. I
won't be able to load it back into Oracle again for a 2nd attempt.
o load it back into Oracle again for a 2nd attempt.
Curtis
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2008 1:33 PM
To: Curtis Leach
Cc: dbi-users@perl.org
Subject: Re: Generic DBI question about backups
I guess I'd be more conce
tempt.
Curtis
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2008 1:33 PM
To: Curtis Leach
Cc: dbi-users@perl.org
Subject: Re: Generic DBI question about backups
I guess I'd be more concerned initially with ensuring the datatype
mappings are identic
I guess I'd be more concerned initially with ensuring the datatype
mappings are identical or in the 'to-be' database, the ingress is valid.
Has that been considered yet?
On Thu, 19 Jun 2008, Curtis Leach wrote:
Does anyone know of a module that would backup an Oracle database in a
database in
Does anyone know of a module that would backup an Oracle database in a
database independent way?
We are decommissioning our only Oracle database & we would like to be
able to preserve it's contents so that it can be reloaded into another
database at a later date. Such as Windows SQL Server or Inf
On 4/5/06 14:07, "Jonathan Mangin" <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Dr.Ruud" <[EMAIL PROTECTED]>
> To:
> Sent: Wednesday, April 05, 2006 11:53 AM
> Subject: Re: Not exactly a dbi question
>
>
>>
- Original Message -
From: "Dr.Ruud" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, April 05, 2006 11:53 AM
Subject: Re: Not exactly a dbi question
> Paul DuBois schreef:
>
> > UPDATE tbl_name SET col_name = 0 WHERE col_name = 0;
> >
> > If you&
Paul DuBois schreef:
> UPDATE tbl_name SET col_name = 0 WHERE col_name = 0;
>
> If you've selected the rows-changed count, $sth->rows() will always
> return 0, because the statement doesn't actually change any col_name
> value from its current value.
That would be an odd optimization. The update
i-users@perl.org
>> Subject: Re: Not exactly a dbi question
>>
>> On 4/5/06 9:46, "Garrett, Philip (MAN-Corporate)"
>> <[EMAIL PROTECTED]> wrote:
>>
>>>
>>>
>>>> -Original Message-
>>>> From: P
>-Original Message-
>From: Paul DuBois [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, April 05, 2006 10:56 AM
>To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
>Subject: Re: Not exactly a dbi question
>
>On 4/5/06 9:46, "Garrett, Philip (MAN-Corporate)&q
On 4/5/06 9:46, "Garrett, Philip (MAN-Corporate)"
<[EMAIL PROTECTED]> wrote:
>
>
>> -Original Message-
>> From: Paul DuBois [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, April 05, 2006 10:41 AM
>> To: Garrett, Philip (MAN-Corporate); dbi-us
>-Original Message-
>From: Paul DuBois [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, April 05, 2006 10:41 AM
>To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
>Subject: Re: Not exactly a dbi question
>[snip]
>>>>
>>>> Sorry, I've
gt;>> Sent: Tuesday, April 04, 2006 4:20 PM
>>>> To: Jonathan Mangin; Garrett, Philip (MAN-Corporate);
>>> dbi-users@perl.org
>>>> Subject: Re: Not exactly a dbi question
>>>>
>>>> On 4/4/06 15:06, "Jonathan Mangin" <[EMAIL PROTEC
>-Original Message-
>From: Paul DuBois [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, April 05, 2006 2:55 AM
>To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
>Subject: Re: Not exactly a dbi question
>
>On 4/4/06 15:31, "Garrett, Philip (MAN-Corporate)&q
On 4/5/06 7:35, "Jonathan Mangin" <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Paul DuBois" <[EMAIL PROTECTED]>
> To: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]>;
>
> Sent: Wednesday, April 05,
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]>;
Sent: Wednesday, April 05, 2006 2:55 AM
Subject: Re: Not exactly a dbi question
> On 4/4/06 15:31, "Garrett, Philip (MAN
> dbi-users@perl.org
>> Subject: Re: Not exactly a dbi question
>>
>> On 4/4/06 15:06, "Jonathan Mangin" <[EMAIL PROTECTED]> wrote:
>>
>>> Autocommit is on. Perhaps you're misunderstanding. An update is not
>>> supposed to happen if the
Ah. Not broke, but poorly-tuned.
Thanks Paul, and Philip for all your help.
--Jon
- Original Message -
From: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 04, 2006 4:31 PM
Subject: RE: Not exactly a dbi question
> -Original
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 04, 2006 4:20 PM
> To: Jonathan Mangin; Garrett, Philip (MAN-Corporate);
dbi-users@perl.org
> Subject: Re: Not exactly a dbi question
>
> On 4/4/06 15:06, "Jonathan Mangin&
On 4/4/06 15:06, "Jonathan Mangin" <[EMAIL PROTECTED]> wrote:
> Autocommit is on. Perhaps you're misunderstanding.
> An update is not supposed to happen if the column to be
> updated is equal to the data being stuffed into it.
> I want $row to reflect that but $row is always 1
> even when an upda
- Original Message -
From: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 04, 2006 3:52 PM
Subject: RE: Not exactly a dbi question
>
> > > -Original Message-
> > > From: Jonathan Mangin [mailto:[EMAIL PROT
>
> > > -Original Message-
> > > From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, April 04, 2006 3:14 PM
> > > To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
> > > Subject: Re: Not exactly a dbi question
>
- Original Message -
From: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 04, 2006 3:23 PM
Subject: RE: Not exactly a dbi question
> -Original Message-
> From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
> Sent: Tuesda
> -Original Message-
> From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 04, 2006 3:14 PM
> To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
> Subject: Re: Not exactly a dbi question
>
>
> The execute() method returns the number
The execute() method returns the number of rows affected for DML
(insert/update/delete) statements, e.g.
my $rows = $sth->execute($sql) || die "can't update: " .
$sth->errstr;
print "Updated $rows rows.\n";
The "|| die" stuff still works even when 0 rows are affected because in
that case
On Tue, 4 Apr 2006, Garrett, Philip (MAN-Corporate) wrote:
> > -Original Message-
> > From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
> >
> > Hi all,
> >
> > I hope someone here can help me.
> >
> The execute() method returns the number of rows affected for DML
> (insert/update/delete
> -Original Message-
> From: Garrett, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 04, 2006 10:52 AM
> To: dbi-users@perl.org
> Subject: RE: Not exactly a dbi question
>
> > -Original Message-
> > From: Jonathan Mangin [mai
> -Original Message-
> From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 04, 2006 10:37 AM
> To: dbi-users@perl.org
> Subject: Not exactly a dbi question
>
> Hi all,
>
> I hope someone here can help me.
>
> The DBD::mysql docs see
Hi all,
I hope someone here can help me.
The DBD::mysql docs seem to say that mysql_affected_rows
is still a viable attribute. I have:
$sql = "update user
set type = ?,
last_name = ?,
state_id = ?,
org_id = ?,
> From: Sam Tregar <[EMAIL PROTECTED]>
> Date: 2005/06/29 Wed PM 02:08:18 CDT
> You migt poke around the POE community.
For those (like me) who saw that and thought "Power Over Ethernet?!?!?" and
wondered what connection could possibly exist between that and DBI, you might
want to check out t
On Tue, 28 Jun 2005 [EMAIL PROTECTED] wrote:
> Does dbi provide asynchronous calls?
No, it doesn't.
> If not, what perl module is there that supports asynchronous sql
> query calls to the database - meaning, I don't have to wait for the
> call to return. I am using mysql.
I don't know of any.
Does dbi provide asynchronous calls? If not, what perl module is there
that supports asynchronous sql query calls to the database - meaning, I
don't have to wait for the call to return. I am using mysql.
Thanks,
Rajeev
Original Message
Subject: Re: Please help: DBI Question
From:"kbass" <[EMAIL PROTECTED]>
Date:Sun, November 23, 2003 1:32
To: "Colin Wetherb
My comments are below.
kbass [EMAIL PROTECTED] wrote:
>
> - Original Message -
> From: "kbass" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 20, 2003 3:53 PM
> Subject: Please help: DBI Question
>
>
> > I
- Original Message -
From: "kbass" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 20, 2003 3:53 PM
Subject: Please help: DBI Question
> I am receiving a variable from HTML called 'STerr' and reading it into my
> CGI prog
- Original Message -
From: "kbass" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 20, 2003 4:09 PM
Subject: Re: Please help: DBI Question
>
> - Original Message -
> From: "kbass" <[EMAIL PROTECTED]>
> To:
- Original Message -
From: "kbass" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 20, 2003 3:53 PM
Subject: Please help: DBI Question
> I am receiving a variable from HTML called 'STerr' and reading it into my
> CGI prog
kbass said:
> I am receiving a variable from HTML called 'STerr' and reading it into my
> CGI program. The variable is accepted into the program and filters down
> into a SQL statement. My problem is that I get no results from within my
> CGI program but when I place this same SQL statement within
I am receiving a variable from HTML called 'STerr' and reading it into my
CGI program. The variable is accepted into the program and filters down into
a SQL statement. My problem is that I get no results from within my CGI
program but when I place this same SQL statement within Postgres, I receive
Kåre Olai Lindbach [EMAIL PROTECTED] wrote:
> On Wed, 18 Jun 2003 06:51:39 -0400, you (Paul Boutros
> <[EMAIL PROTECTED]>) wrote:
>
> >Quoting "Kovalcik, Mike A [ITS]" <[EMAIL PROTECTED]>:
>
> >> I'm trying to setup some scripts that will allow me to use Perl DBI to
> >> INSERT into my table. Ho
On Wed, 18 Jun 2003 06:51:39 -0400, you (Paul Boutros
<[EMAIL PROTECTED]>) wrote:
>Quoting "Kovalcik, Mike A [ITS]" <[EMAIL PROTECTED]>:
>> I'm trying to setup some scripts that will allow me to use Perl DBI to
>> INSERT into my table. However, I have not had any success at all. I'm
>> using pe
Two things come to mind:
1. $dbh->do() doesn't return a statement handle, I think. It just returns the
count of rows affected. What happens if you put a $dbh->commit after the do()?
2. It could also be a quoting issue. Try using place-holders instead, with
something like:
my $sql = '
INSERT I
Hi,
I'm trying to setup some scripts that will allow me to use Perl DBI to
INSERT into my table. However, I have not had any success at all. I'm
using perl CGI as well so I've granted ALL permissions on my table to
the apache user and I still can't INSERT. I can, however, UPDATE and
SELECT on t
- Forwarded message from gmei <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
From: "gmei" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: perl DBI question: fetchrow_array
Date: Fri, 7 Mar 2003 13:39:14 -0500
In-Reply-To: <[EMAIL PROTECT
every area, that it's almost not serious not to utilize them.
Go mod_perl, get Geoff's and Randy's book, Mod_perl cookbook, and do
persistant connection pooling.
Ilya
-Original Message-
From: G S [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 10:43 AM
To: [
On Wednesday, December 18, 2002, at 07:42 AM, G S wrote:
Is it possible for a perl script to use a database connection that was
previously opened in another perl script, or must each perl script
open it's own database connection?
In general, the answer is No. It does depend on the DBD::Xyz
On Wed, 18 Dec 2002 07:42:53 -0800 G S <[EMAIL PROTECTED]> wrote:
> Is it possible for a perl script to use a database connection that was
> previously opened in another perl script, or must each perl script open it's
> own database connection?
Possible, depending on the RDBMS, but very tricky
Is it possible for a perl script to use a database connection that was
previously opened in another perl script, or must each perl script open it's
own database connection?
_
Protect your PC - get McAfee.com VirusScan Online
ht
On Tue, 18 Jun 2002, Tim Harsch wrote:
> Date: Tue, 18 Jun 2002 15:38:49 -0700
> From: Tim Harsch <[EMAIL PROTECTED]>
> To: "'William R. Mussatto'" <[EMAIL PROTECTED]>,
> "'Kotha, Nagaraju'" <[EMAIL PROTECTED]>
> Cc:
From: Joe Raube [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 4:26 PM
> To: Tim Harsch
> Cc: [EMAIL PROTECTED]
> Subject: RE: Apache::DBI question
>
>
> > | > I may be missing something, but with normal cgi, the program
> > | > goes away
> > | >
> | > I may be missing something, but with normal cgi, the program
> | > goes away
> | > when its done so the connection will go away as well. What
> | > would hold
> | > your persistent connection?
Apache holds the connection! That's the point of Apache::DBI...
If the same db connection reques
D]]
> Sent: Tuesday, June 18, 2002 4:17 PM
> To: Tim Harsch; 'William R. Mussatto'
> Cc: [EMAIL PROTECTED]
> Subject: Re: Apache::DBI question
>
>
> What about a CGI acting as a socket server? Wouldn't that open up a
> persistent connection?
>
> Brian
gt;; "'Kotha, Nagaraju'"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 18, 2002 3:38 PM
Subject: RE: Apache::DBI question
| Yeah but what about if you combine it with Fast::CGI (which I've never
| done). But in theory wouldn't the CGI stay
--Original Message-
> From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 11:17 AM
> To: Kotha, Nagaraju
> Cc: [EMAIL PROTECTED]
> Subject: Re: Apache::DBI question
>
>
> I may be missing something, but with normal cgi, the program
> goes aw
lt;[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Apache::DBI question
>
> Hi,
>
> Does any one have experience with Apache::DBI with Perl (not mod_perl)?
>
> How good these are with persistence connections?
> Is there any issues for the large web sites?
>
On Tue, Apr 02, 2002 at 02:58:03PM -0600, Koie Smith wrote:
>
> i'm wanting to create a cgi file that verify's customer number/password..
>
> i think i have it partially correct..
>
> SELECT custnum FROM support WHERE custnum=$enteredcustnum;
> SELECT password FROM support WHERE password=$enter
The query looks correct, just need to make $enteredcustnum, etc... equals
the actual entered values. You have to look at the CGI documentation for
that.
Ilya
-Original Message-
From: Koie Smith
To: [EMAIL PROTECTED]
Sent: 4/2/02 1:58 PM
Subject: another dbi question
ok,
i'm wa
ok,
i'm wanting to create a cgi file that verify's customer number/password..
i think i have it partially correct..
SELECT custnum FROM support WHERE custnum=$enteredcustnum;
SELECT password FROM support WHERE password=$enteredpw;
I think i have that part, but i dont know how to make them com
On 10 Sep 2001, at 14:39, Paul Maine Jr. wrote:
> I am writing a Perl/DBI application. I need to initially issue a
> select statement and then determine if any records are returned. Could
> someone provide me with an example of how to determine if no records
> are returned from a select statement
"Paul Maine Jr." wrote:
> I am writing a Perl/DBI application. I need to initially issue a select
> statement and then determine if any records are returned. Could someone
> provide me with an example of how to determine if no records are returned
> from a select statement.
>
> Thank You
how abo
age-
From: Paul Maine Jr.
To: DBI Users Perl. Org (E-mail)
Sent: 9/10/01 1:39 PM
Subject: Perl DBI Question
I am writing a Perl/DBI application. I need to initially issue a select
statement and then determine if any records are returned. Could someone
provide me with an example of how to determine
> From: Paul Maine Jr. [mailto:[EMAIL PROTECTED]]
>
> I am writing a Perl/DBI application. I need to initially
> issue a select
> statement and then determine if any records are returned.
> Could someone
> provide me with an example of how to determine if no records
> are returned
> from a se
I am writing a Perl/DBI application. I need to initially issue a select
statement and then determine if any records are returned. Could someone
provide me with an example of how to determine if no records are returned
from a select statement.
Thank You
r SQL*Plus, but hard to see what its really doing, and let the
server fetch data, let the client format it IMHO).
> -Original Message-
> From: Stan Brown [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 09, 2001 12:32 PM
> To: [EMAIL PROTECTED]
> Subject: Oracle specifc DBI
I have a query thta does exactly what I need it to do. It was created by
someone far more experienced that I (read I don't understand it)
It includes some column formating comands (an Oracle feature) which +apera_
to be critical to it's working corectly. If I am not mistaken these are
only efect
Froggatt, S. wrote:
> Thanks for the info Simon.
>
> However
>
> 1.How do I find which version I am pointing at
> 2.Where do I find DBI for the version of perl I am running. Excuse my
> ignorance but when I download DBI-1.14 I thought that was for all
version.
>
> Best Regards
> Steve
Your system has two versions of perl installed and DBD::mysql is not
installed for the version your shebang is pointing at.
Either install DBD::mysql to the version of perl you want to use or
change the shebang.
You could of course alter @INC to include the required directories but
this is un
When I try to run a script I get an error that is listed below. This script
works on another server. I have DBI 1-14 loaded BUT the mysql.pm file that
the error is moaning about only appears to be in the following directories.
Any help would be appriciated.
/root/.cpan/build/Msql-Mysql-modules-
ECTED]
Subject: not a dbi question
This is NOT a DBI question, rather it is a perl question. Maybe somebody
can help me.
I use the find -type d -print >aa.txt
then open aa.txt
$dir =
when use this to check to see if it is directory, it always return
undef.
return undef unless -d $dir;
i print
eat fish for an age.
- Original Message -
From: "Xiaoxia Dong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 19, 2001 1:45 PM
Subject: not a dbi question
> This is NOT a DBI question, rather it is a perl question. Maybe somebody
> can help me.
>
&
This is NOT a DBI question, rather it is a perl question. Maybe somebody
can help me.
I use the find -type d -print >aa.txt
then open aa.txt
$dir =
when use this to check to see if it is directory, it always return
undef.
return undef unless -d $dir;
i print out $dir, which
100 matches
Mail list logo