On Tue, Nov 30, 2004 at 10:40:34PM +, Nicholas Clark wrote:
On Tue, Nov 30, 2004 at 10:32:12PM +, Tim Bunce wrote:
On Tue, Nov 30, 2004 at 09:38:47PM +, Nicholas Clark wrote:
On Tue, Nov 30, 2004 at 08:53:51PM +, Tim Bunce wrote:
The one that I've hit - specifying port
I know what it does, I'm trying to find real examples that demonstrate
why people think it's needed. Nick has provided a good one. Any others?
Tim.
On Tue, Nov 30, 2004 at 06:37:01PM -0800, Terrence Brannon wrote:
I don't get it. Can someone give me some small but real examples
of the
Tim Bunce wrote:
On Tue, Nov 30, 2004 at 10:40:34PM +, Nicholas Clark wrote:
I guess I don't find it natural thinking about parameters as a single string.
Do you generally pass URLs around as a string or broken up into a hash?
Tim.
quote
Hi,
I've got a problem with a simple fetch which just takes hours (literaly) to
complete.
It's a simple select statement which, in the current case, returns about 300
rows within seconds.
But the loop is finished a couple of hours later then the last result is
printed.
Here's a code snippet:
Sorry for the top post - old version of Groupwise at work :-(
You aren't error checking your dbi statements - do you have RaiseError
set to on (1)? If you don't, check each dbi statement like this:
my $Statement = $Database-prepare($SQL)
or die(Prepare died: $DBI::errstr);
I agree - set RasieError. But even more, it is impossible to tell what is
going on in the database without a 10046 trace.
After connecting, issue alter session set events '10046 trace name context
forever, level 8'. This will create a trace file in the directory defined by
Are you sure the query only takes a few seconds and not that it only
takes a few seconds to return the rows that makes your selection
criteria. Not sure how big your database is but for anything other than
trivial data volumes I would say that performance will be very poor.
(obviously that is just
I am having diffuculty getting past the nmake (make) step for installing the
DBD::Oracle perl module on Windows.
The perl Makefile.PL step completes, but with warnings of missing libraries
(see below).
It appears I am missing key .lib's, but I can't find them anywhere, execpt that
they seem
instead of having to haul around the code to figure this out, why not create a
handy documentary web service somewhere where you fill out the blanks and
get an appropriate connection string? Loading a module every time you start
the program just to create something that is a permanent
On Tue, Nov 30, 2004 at 11:02:31PM -0600, David Nicol wrote:
instead of having to haul around the code to figure this out, why not create a
handy documentary web service somewhere where you fill out the blanks and
get an appropriate connection string? Loading a module every time you start
the
Tim Bunce wrote on 30 November 2004 23:32
On Tue, Nov 30, 2004 at 09:38:47PM +, Nicholas Clark wrote:
On Tue, Nov 30, 2004 at 08:53:51PM +, Tim Bunce wrote:
I don't get it. Can someone give me some small but real examples
of the problem that's being solved here?
The one
Orton, Yves stupidly wrote on 01 December 2004 12:54
Tim Bunce wrote on 30 November 2004 23:32
On Tue, Nov 30, 2004 at 09:38:47PM +, Nicholas Clark wrote:
On Tue, Nov 30, 2004 at 08:53:51PM +, Tim Bunce wrote:
I don't get it. Can someone give me some small but real examples
On Wed, Dec 01, 2004 at 02:02:57AM -0800, Terrence Brannon wrote:
Tim Bunce wrote:
On Tue, Nov 30, 2004 at 10:40:34PM +, Nicholas Clark wrote:
I guess I don't find it natural thinking about parameters as a single
string.
Do you generally pass URLs around as a string or broken up into a
Thx for all the answers.
Well, you're right. I check for error against DB handle, not against
statement.
But that's just a typo. The statement itself works.
The problem is within the loop:
while ( @row = $Statement-fetchrow_array ) {
warn @row\n;
The published link at [EMAIL PROTECTED] is not working.
I thought someone should mention it.
-
Gordon Corzine
Email: [EMAIL PROTECTED]
Salem State College
Greeting, all,
I have a script which converts query output into Excel spread sheet which is
working fine, I am a UNIX scripting guy and I am having difficulty making some
simple changes to the script, hope I will get some help.
I want to send a email from the script only if it fetches any
Hello Robert:
You could use:
MIME::QuotedPrint;
MIME::Base64;
Mail::Sendmail
There are some examples on the internet showing you
how to attach using sendmail.
regards,
David
--- Robert [EMAIL PROTECTED] wrote:
Greeting, all,
I have a script which converts query output into
Excel
On Wed, Dec 01, 2004 at 10:09:55AM -0500, Ricardo SIGNES wrote:
* Tim Bunce [EMAIL PROTECTED] [2004-12-01T04:48:40]
I know what it does, I'm trying to find real examples that demonstrate
why people think it's needed. Nick has provided a good one. Any others?
I have a very similar set of
At 10:39 AM 12/1/2004, you wrote:
On Wed, Dec 01, 2004 at 09:56:01AM -0500, John Siracusa wrote:
On Wed, 1 Dec 2004 09:46:24 +, Tim Bunce [EMAIL PROTECTED] wrote:
Do you generally pass URLs around as a string or broken up into a hash?
If they had different formats for different consumers,
On Dec 1, 2004, at 10:39 AM, Tim Bunce wrote:
On Wed, Dec 01, 2004 at 09:56:01AM -0500, John Siracusa wrote:
On Wed, 1 Dec 2004 09:46:24 +, Tim Bunce [EMAIL PROTECTED]
wrote:
Do you generally pass URLs around as a string or broken up into a
hash?
If they had different formats for different
On Thu, Dec 02, 2004 at 08:34:20AM +1100, Ron Savage wrote:
On Wed, 1 Dec 2004 18:39:00 +, Tim Bunce wrote:
H Tim
need a better understanding of the underlying issues. More real-
world examples would help.
Here's a real world example of how I do things, although I am in no way
On Wed, Dec 01, 2004 at 01:45:50PM -0500, John Siracusa wrote:
On Wed, 1 Dec 2004 18:39:00 +, Tim Bunce [EMAIL PROTECTED] wrote:
FWIW, the reason I'm digging here is because I agree there may be
some value in the DBI supporting something along these lines, but
I need a better
On Wed, 2004-12-01 at 12:18 -0500, Jesse Vincent wrote:
The bug I'm describing isn't something
I've managed to duplicate in-house. Everyone who's hitting it is
running perl 5.8.3 or newer (Some are running 5.8.5). They're all
running against Oracle 9.2.0.x.
So, you are allowing them to make
On Wed, 2004-12-01 at 19:01 -0500, Jesse Vincent wrote:
On Wed, Dec 01, 2004 at 06:59:18PM -0500, Lincoln A. Baxter wrote:
On Wed, 2004-12-01 at 12:18 -0500, Jesse Vincent wrote:
The bug I'm describing isn't something
I've managed to duplicate in-house.
Have you tried?
Everyone
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This seems to be a solution in search of a problem. With the
exception of perhaps port, host, and database, the dsn
arguments are pretty DBMS-specific, meaning that they cannot
really be mapped from one DBD to another, nor can any common
rules be
Try this.
Add these lines to end of script.
if ( $rowCount 0 ) {
system(uuencode excel_dump_1.xls excel_dump_1.xls
|mailx -s 'blah blah..' [EMAIL PROTECTED]);
}
or Good thing is use perl module Mail::Sender
--- Robert [EMAIL PROTECTED] wrote:
Greeting, all,
I have a script which
Hello,
I have a script that is connecting to two different databases , one is local
and the other remote.
The local Informix DBI connection works a treat but I am having trouble
getting the remote mysql connection to work.
I keep get error: Client does not support authentication protocol
27 matches
Mail list logo