You should be able to get this from dbish, too.
-Original Message-
From: Jonathan I. Nori [mailto:[EMAIL PROTECTED]
Sent: July 21, 2003 14:39
To:
Subject: which DBI modules are installed?
Hi!
My ISP is running low on staff for a couple weeks here because of summer
vacations. Is there
that your code is
similar to the snippet you included. Is that the code verbatim? If not,
could you post a snippet from the actual code.
Cheers!
Gordon Dewis
Production Officer / Agent de production
Geography Division / Division de la géographie
Statistics Canada / Statistique Canada
(613)951-4591
Interesting that two people said the exact opposite with respect to
performance. As we all know, there are many factors that can influence the
performance of a query. If you (Carlos) have to do more multiple full table
scans for a distinct, it may be time to tune your db and/or create some
Why not use the following SELECT statement:
select col1 from jenny where col10 and col1 is not null
That should do the trick nicely. :)
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
-Original Message-
From: Liu, Jenny [mailto:[EMAIL
What character set is your Oracle session using? Sounds like Oracle is
stripping characters out. What does a trace reveal?
-Original Message-
From: Vorce, Tim (T.) [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 09, 2002 09:26
To: dbi users perl.org
Subject: bytes in dbi
});
}
Hope this helps!
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
-Original Message-
From: Hytham Shehab [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 3:37 PM
To: dbi
Subject: Re: it *should* be sorted, but it is not
here is a code snippet
I can understand option #1 being unavailable.
Why can't you install DBD::Proxy and DBD::Oracle on the Oracle server
itself? Then you only need to install DBD::Proxy on your 32 bit PA-RISC
machine.
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
of luck, I think.
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
-Original Message-
From: PETAZZONI,THOMAS (Non-HP-Germany,ex1)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 9:59 AM
To: '[EMAIL PROTECTED]'
Subject: RE: :Oracle
Hi,
Why can't you
Is AutoCommit set to 0 (zero) in your connect?
If it is set to 0, are you doing a commit() before the script exits? If you
don't, then a rollback will be performed upon exit.
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
-Original Message-
From
This method will work, though you may want to consider this alternative if
you have a lot of rows. Create a flat file of from your Sybase table and
use sqlload to load the records into your Oracle table. Use direct path
loading for better performance.
If you go with the method below, use
I don't have an example for Sybase, but I have done this sort of thing with
a couple of local and remote Oracles as well as multiple local Oracles.
Basically, you connect to each one as you would expect and assign a
different handle to each connection. From there on, it doesn't matter
whether
I haven't used DBI::Excel, but I have used Spreadsheet::WriteExcel in a
similar scenario.
-Original Message-
From: Simon Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 11:41 AM
To: [EMAIL PROTECTED]; dbi-users
Subject: Re: Can I use Win32?
Best way is to connect
It sounds like your DB2 environment variables are not being passed from the
webserver to the CGI. You'll need to modify your Apache config to
explicitly pass the variables DB2 requires. I don't recall specifically
which ones they are.
-Original Message-
From: James Gardner
Can you connect to it with the sqlplus client?
-Original Message-
From: Juan Jose Natera Abreu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 11:36
To: [EMAIL PROTECTED]
Subject: Re: Problems connecting to Oracle (ORA-01034: ORACLE not
availabl e)
Hi,
On Tuesday 21 August
Can you provide some code?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 10:02
To: [EMAIL PROTECTED]
Subject: auto commit
Hello All,
When setting AutoCommit = 0, with transactions, does anything else need to
be
set to disable
You don't mention which database, which might make a difference.
The finish() after the UPDATE won't do what you think it will. It should
only be used after a SELECT query. The cheetah book talks about it on p.
117.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 12:49
To: [EMAIL PROTECTED]
Subject: Re: auto commit
On Tue, 14 Aug 2001 12:26:39 -0400, [EMAIL PROTECTED] wrote:
You don't mention which database, which might make a difference.
I've seen this when the environment variables are not defined. If you're
trying to run this as a CGI, you'll have to explicitly export the
appropriate DB2 environment variables. I'd be more specific, but I don't
have access to the DB2 environment I've experienced this in at the moment.
If the actions in the second while do not rely on the all the records having
being processed in the first while then you should just combine the two. If
you can't combine the two, you could push all the results into an array and
then walk through the array.
-Original Message-
From:
Not really a DBI issue, but
You need to store the URL in the database and retrieve it in the select that
also returns the name of the player. Your CGI will have to build the HTML
around the name when your producing the list of results.
-Original Message-
From: Simon K. Chan
Can you provide an example?
-Original Message-
From: Michelle Gerfort [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 09:17
To: [EMAIL PROTECTED]
Subject: Slow execution
Hi there
I use an ordinary
$sth-execute();
but it seems to take ages to search, creating or updating a
You could create a sequence and assign each record a value and then generate
a random list of sequence numbers. However, that would mean multiple
selects to ensure they would come out in random order.
(Unless you specify an order, records are not necessarily guaranteed to come
out in the same
This keeps drifting farther and farther off-topic, but
If the information from the headers were transfered to a small footer
appended to each message, you would be moving the 500 bytes rather than
increasing the overall message size. And the information would be
accessible to everyone and
try:
select up_time from uptime where
startdate in (select GREATEST(startdate)
from uptime where
hostname = 'twister')
-Original Message-
From: Xiaoxia Dong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March
24 matches
Mail list logo