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
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
indice
gests 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
(61
Why not use the following SELECT statement:
select col1 from jenny where col1<>0 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:
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
Currently,
How about...
$sql="select * from table where column=?";
$sth=$dbh->prepare($sql);
$sth->execute(qq/What you're looking for/);
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
-Original Message-
From: Vorce, Tim (T.) [mailto:[E
\n",$loc[$j]->{id},$loc[$j]->{name});
}
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* b
're out 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: :
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
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-
It should just be: "use DBI;"
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 25, 2002 10:55 AM
To: [EMAIL PROTECTED]
Subject: Problem: installation DBI in AIX 4.3.3
Hello I'm trying to install DBI (version 1.28) in a AIX 4.3.3. platform
and fa
Hmmm... Sounds like your Perl and their Perl are not the same Perls.
Do a 'which perl' and ask the DBAs to do the same and compare the results.
If they're different, that's likely the culprit.
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-
A semi-colon would work better, though. ;)
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
-Original Message-
From: PARLEY,JON (HP-MountainView,ex1) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 5:15 PM
To: 'Dan Finch'; [EMAIL
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 {AutoC
as a string rather than a number because you've surrounded it with
quotes. Remove the quotes from the value for col4 and let us know if that
works.
Hope this helps...
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
-Original Message-
From: Koen Gogne
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 the
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 to
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 [mailto:[EMAI
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 20
-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.
M
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]]
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 Auto
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: Eric,
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.
-Ori
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 [mailto:
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 post
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
A solution might be to prepare an update statement for each column that can
be updated and then execute only those required via a bunch of if's. It
does have some performance/efficiency issues, but it might be better than
the memory leak.
Just a thought... :)
-Original Message-
From: Da
If you're using Oracle, try something like this:
-8<-
:
:
$sth=$dbh->prepare("select *
from users
where convert(first_name,'US7ASCII')=convert(?,'US7ASCII')");
$sth->execute('josé');
:
:
-8<-
That should select both "josé" and "jose"
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 15
31 matches
Mail list logo