', '', {});
/\
this would be the 9i instance.
On 04-Dec-01 Ron Peled wrote:
Hey Scott,
First of all thanks for the quick answer.
Second :Connecting via SQLPLUS connects me to the DB just fine.Looking in
the tnsnames.ora it looks just fine
these.
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 04-Dec-01
Time: 13:45:17
--
Turns out it is a Worm, BadTrans check out www.sarc.com.
On 04-Dec-01 Fox, Michael wrote:
not me - and I'm on the OCI list too
-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 6:51 AM
To: [EMAIL PROTECTED]
Subject: Anybody
that route. It's not a lot of code, but it's
rather disheartening to use an archaic method to work with new features.
Only on windoze.
Sigh...
Jared
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 29-Nov-01
Time: 08:04:58
--
Dennis
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 28-Nov-01
Time: 07:53:25
--
Thanks a million;
I haven't got all the test to run yet, but I'm connecting and
pulling data! I wasted more than 1 night on this.
thanks again
...or I could be wrong :-)
Your DBD::Oracle is built using the Oracle7 OCI API, it doesn't
know about LOBS.
Tim.
On 16-Nov-01 Scott T. Hildreth wrote:
Versions do matter, I believe CLOB was fixed in DBD::Oracle 1.09.
I had emailed Becka yesterday to try the new versions
:)
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
It is not necessary to cc: me via e-mail unless you mean to speak off-group.
I read these via nntp.perl.org, so as to get the stuff OUT of my mailbox. :-)
-execute() || print Insert into CRR table
failed!!\n;
if(!defined($result_ins)) {
print Insert into CRR table failed!!\n;
} else {
print Insert into CRR table result: $result_ins\n;
}
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 15-Nov-01
Time: 15
a caption that's differently colored than normal for
the error you can do
caption.error { background: white; color: #3366ff; font-size: large ; }
in the stylesheet and then
print caption({-class='error'}, Sorry, I was unable to process your
request. Please try again.. ), \n;
HTH
--
Scott R. Godin
try one of the $dbh-select(all|row)_arrayref, this does a prepare execute
for you. Do a 'perldoc DBI' to read about them.
)
{
#... and no worries about which order the columns get returned in
#... since you access them via the $db{ColumnName} method :)
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
up against who is a major PHP
proponent, and who refused to even think about installing mod_perl to
help the script along after he saw this. :/
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Eric Kolve) wrote:
I have traced it back to prepare_cached() (at least that is what I
notice).
Scott, try replacing your calls on startup with prepare() instead of
prepare_cached().
no, I'm using prepare(). an earlier post thread of mine
of the mod_perl and Apache::DBI
stuff compiled in, because he's a php freak and thinks mod_perl is a
resource pig. :\
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Tim Bunce) wrote:
On Fri, Nov 02, 2001 at 02:18:15PM +0100, Bart Lateur wrote:
On Fri, 02 Nov 2001 07:27:49 -0500, Scott R. Godin wrote:
my %db;
$sth-bind_columns( \( @db{ @{ $sth-{NAME} } } ));# magic
while ($sth-fetch
been fetched.
I guess I'm fortunate that DBD::'s CSV, AnyData, and mysql all work this
way.
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
-bind_columns( \($date) );
while ( $sth-fetch() )
{
my($yyymmdd, $hhmmss) = split / /, $date;
my($, $mm, $dd) = split m|/|, $mmdd; # or split /-/, etc.
print Year: $, Month: $mm, Day, $dd\n;
}
$sth-finish if $sth;
$dbh-disconnect();
does that help?
--
Scott R. Godin
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Scott R. Godin) wrote:
Well post the script and we can look. Please eliminate the parts that are
not relevant if you script is big.
it's about 255 lines of code incuding comments.. I'll remove the
comments from the file to shorten
in?
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
In article
[EMAIL PROTECTED],
[EMAIL PROTECTED] (Ilya Sterin) wrote:
As much as I shouldn't say this, but run the script without the -w to get
rid of this message, or define a __WARN__ handler.
Ilya
or use
local $^W;
within the loop
--
Scott R. Godin| e-mail
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Stephen Clouse) wrote:
Having said all that, is this really on topic for dbi-users?
indeed it is, since the script in question is banking heavily upon DBI
and DBD::mysql to do the work.
--
Scott R. Godin| e-mail : [EMAIL
,
-width=300});
create_dbi_table($query);
print end_table,
end_div,
hr,
end_html;
FINISH:
# end of code
If anyone is interested I can provide particulars on the maps table in
the MySQL database as well.
--
Scott R. Godin| e-mail : [EMAIL
.
On 24-Oct-01 Scott R. Godin wrote:
here's a missive fired off by the site admin after he benchmarked two
scripts, one written in php and one written in perl/cgi
First of all.
Dude. you're out of your mind. Im serious.
The WHOLE point about why PHP is faster than Perl is because
)
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
here's a missive fired off by the site admin after he benchmarked two
scripts, one written in php and one written in perl/cgi
First of all.
Dude. you're out of your mind. Im serious.
The WHOLE point about why PHP is faster than Perl is because the
interpreter is compiled into
Just in case anybody needs this patch. This fixes the commit in DBD::Proxy
for DBI-1.20. Tim will have in the next DBI release.
-FW: [EMAIL PROTECTED]-
Date: Fri, 12 Oct 2001 10:43:07 +0200
From: Jochen Wiedmann [EMAIL PROTECTED]
To: Scott T. Hildreth [EMAIL PROTECTED]
Subject: Re
[12]','$columns[13]','$columns[14]','$columns[15]',
'$columns[16]','$columns[17]','$columns[18]','$columns[19]',
'$columns[20]'])
}
]
)
);
--
Scott Taylor
Systems Administrator
DCT Chambers Trucking Ltd.
that part, just in case someone has some insight on that.
TIA
Scott
, W2K) for over 2 years.
- Scott
Scott Scecina
In Mind, Inc.
,
STH
On 11-Oct-01 Scott T. Hildreth wrote:
Tim,
A couple months back I posted to dbi-users asking if anyone
had the following error when using the below method for
connecting to the Database.
$ENV{DBI_AUTOPROXY} = 'dbi:Proxy:hostname=srv1;port=';
my $dbh
-trace_msg( DBI_AUTOPROXY: dbi:$driver:$dsn\n);
}
STH
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 11-Oct-01
Time: 16:59:27
--
Solutions
www.advertpro.com
___
Web Design, Hosting, Promotion
www.arc-s.com
___
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 08-Oct-01
Time: 06:52:48
--
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Jeff Zucker) wrote:
Scott R. Godin wrote:
unable to set ;csv_eol=\015, but saving the file via bbedit to DOS
instead of Macintosh, the code works?!? what the hell?
AFAIK,
1. If you are on a MAC and have all MAC-formatted files, don't
out the
old without knowing where it is.
Thanks,
Alex
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 03-Oct-01
Time: 14:42:25
--
with this morning off-perl question.
Thanks you very much,
Scott Purcell
have to, considering one
single csv_eol=\015 is supposed to solve the problem :)
DBI 1.20
DBD::CSV 0.1027
SQL::Statement 0.1020
Text::CSV_XS 0.22
MacPerl 5.6.1a4
I can post the complete script and a smidge of sample data if you wish
--
Scott R. Godin| e-mail : [EMAIL PROTECTED
if I have the following code
sub test {
$dbh =get_dbh;
test1($dbh,$somedata);
close($dbh);
}
sub test1 {
my ($dbh,$data)=@_;
#sql code
}
if the $sql code fails in subroutine test1 does it causes a open process
since I defined $dbh as local?
Anthony Scott
:(
Anthony Scott
Sterin, Ilya wrote:
Not sure what you mean. You are reusing a global handle, if you mean will
there be a memory leak, no since everything is deallocated at end of
execution. Otherwise I am not exactly sure, why you would think that a
different process is created:-?
Ilya
as a
statement handle and therefore the next call to it, will generate a perl
error stating that it can't call a method on an undefined object.
Ilya
-Original Message-
From: Anthony Scott [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 5:49 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL
Scott
be appreciated!
Thanks ...
Regards Riyaad.
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 14-Sep-01
Time: 08:29:30
--
Can't start a new session: $!;
umask 0;
}
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 30-Aug-01
Time: 08:27:49
--
require DBI 1.20.)
As suspected, upgrading to DBI 1.20 fixed it, make test worked.
I'll wait for some more feedback and put out a new release after that.
Tim.
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 30-Aug-01
Time: 08:35:58
--
Here is the error messages I get when trying to compile DBI on an SCO
OSR5.0.5 compile of Perl5.005. Does anyone know what I'm missing or how I
can get the DBI module into my Perl install? (Perl and cc info. at end of
message)
Thanks.
Scott.
Output of perl Makefile.PL:
(information
/site_perl/5.6.0
/usr/lib/perl5/site_perl
.
DBI-1.15
DBD-Oracle-1.06
Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
JServer Release 8.1.7.1.0 - Production
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 24-Aug-01
at
/usr/local/lib/perl5/site_perl/5.6.1/i86pc-solaris/DBD/Proxy.p
m line 536
Any ideas?
Many thanks in advance
Oleg
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 21-Aug-01
Time: 08:29:52
--
running DBI 1.18, DBD::Oracle version 1.07 and 8.1.7.
Any help is appreciated.
Anthony Scott
.
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 11-Jul-01
Time: 09:11:36
--
I just changed the shell because our .zshenv
has the enviorment variables setup.
On 03-Jul-01 Alexander Farber (EED) wrote:
Scott T. Hildreth wrote:
I fixed it by setting the 'SHELL=/usr/local/bin/zsh' so
the LD_LIBRARY_PATH is getting set before Perl is executed.
Why not just set
as you did,
using the same Perl interpreter.
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell: 610-574-7706
Pager: 877-239-4003
-Original Message-
From:Scott T. Hildreth
:)
Thanks,
STH
On 15-Jun-01 MikemickaloBlezien wrote:
On Fri, 15 Jun 2001 14:20:28 -0500 (CDT), Scott T. Hildreth
[EMAIL PROTECTED] wrote:
It appears that you are attempting to enter data to a column that has
possible
reached it's max size. What type
MSN Hotmail at http://www.hotmail.com.
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 14-Jun-01
Time: 10:33:01
--
]|
| Database Applications Specialist FAS Computer Services |
+--+
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 12-Jun-01
Time: 16:43:41
--
:)
Just trying to narrow down the problem.
or match '12345 %'?
What if the value stored is '12345nullnullnull'
-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 3:04 PM
To: Doug
Cc: [EMAIL PROTECTED]; Rick Osterberg
Subject: RE: Strange
your operation into smaller
queries, or only update one table at a time.
HTH.
Wes
- Original Message -
From: Trevor Webster [EMAIL PROTECTED]
To: Tim Scott [EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001 7:46 AM
Subject: Re: DBI - Access
Tim
I had a similar problem when I first
Some further fiddling found a problem with 'workdate'. I've sorted that, but
it still makes no difference. :((
The values it's passing to '$sth-execute' are:
1531499623, -1516480662, 2001-5-29 00:00:00, 3, May-2001
Help!
Tim
- Original Message -
From: Tim Scott [EMAIL PROTECTED
- Original Message -
From: Tim Scott [EMAIL PROTECTED]
To: DBI Users [EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001 9:43 AM
Subject: Re: DBI - Access
Some further fiddling found a problem with 'workdate'. I've sorted that,
but
it still makes no difference. :((
The values it's passing to '$sth
Voncent,
You'd be better to setup a tnsnames entry in your Oracle8.1.6 area to point
at your Oracle 7.3.4 database and using this as a connect string.
If you don't do this, you're using Oracle8 function calls from your Perl/DBI
build to try to talk to an Oracle7 database. This is asking for
string (or TWO_TASK) value should be used as the first argument
to DBI-connect.
HTH,
Tim
- Original Message -
From: Vincent Roquencourt [EMAIL PROTECTED]
To: Tim Scott [EMAIL PROTECTED]
Cc: Vincent Roquencourt [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 10:50 AM
Subject: Re
help me
Pl note : I have installed MySql and it is working ok. Also, i can access
MySql database using DBI:MySql module. I can also log into Oracle database
using scott/tiger@oralin, so this is also ok.
pl. pl. help me
TIA
Denis
Makefile.PL -g
make
make test
gdb `which perl` core
(gdb) where
(gdb) quit
which perl
perl -V
which perl
sqlplus $ORACLE_USERID
Thanks very much,
Tim Scott
The information transmitted in this electronic mail message may contain
confidential and or privileged materials. For full details and restrictions
It looks like there's some confusion over SQL syntax here. Is there a
database which allows you to effect an insert into a table by doing a
'select ... into ' ?
Oracle certainly doesn't and if Peter's using Oracle then what he suggests
should (and does) work fine. Having said that TIMTOWTDI :)
version of Storable, I still get this message.
--
Michael Wray
Network Administrator
FamilyConnect, Inc.
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 22-May-01
Time: 16:10:06
--
PGP SIGNATURE-
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 21-May-01
Time: 16:27:04
--
Scott
Pacific Systems Design Technologies
http://www.perldebugged.com
Hi all,
I am having great difficulty in getting DBI installed on an AIX 4.3 box.
Basically the Makefile.PL works great, Makefile works fine, but make test
returns a load of No such file or directory errors. from DynaLoader.PM.
Details below - errors in the make test section
Can anyone help
Here's a snippet of my code:
my $dbh = DBI-connect('dbi:ODBC:MYDSN', 'user', 'pass',{RaiseError = 1,
AutoCommit = 1});
$sth = $dbh-prepare
("INSERT INTO ARTICLES (ARTICLE_TYPE, TITLE, SUBJECT, AUTHOR, SOURCE,
SOURCE_URL, COPY, PULLQUOTE) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
$sth-execute
The docs say that those values are for "fetching only", and setting them
seems to have no effect on my insert.
Is there any character limit on an insert?
ScottP
-Original Message-
From: Robert Davis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 12:18 PM
To: Scott
PROTECTED]]
Sent: Thursday, April 12, 2001 1:57 PM
To: [EMAIL PROTECTED]
Subject: RE: Error when inserting large amounts of text (update)
Scott Phelps writes:
I just found the following in an archive (I believe of this list) and it
sounds like my problem exactly (not sure of byte length
ata = $sth - fetchrow_array) {
print "@thedata";
}
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 10:59 AM
To: [EMAIL PROTECTED]
Subject: Re: Running a stored procedure
Hi,
Scott Phelps wrote:
I am new to DBI and have
.yahoo.com
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 20-Mar-01
Time: 09:41:02
--
Here's what doesn't work:
my $dbh=DBI-connect('dbi:ODBC:scottp', 'user', 'pass',
{RaiseError = 1,
AutoCommit = 1}
) || errorhandler("Database connection error: $DBI::errstr");
$sth=$dbh-prepare("SELECT $content_field FROM $content_table WHERE
-Original Message-
From: NEWMAN, SCOTT (SBIS)
Sent: Tuesday, March 13, 2001 2:00 PM
To: '[EMAIL PROTECTED]'
Subject: DBI error math.h
I'm running Solaris 2.6 / Perl 5.005 / GCC 2.8.1 /DBI 1.14
I'm recieving the error below-- Any Suggestions???
# make
Thanks,
STH
--
E-Mail: Scott T. Hildreth [EMAIL PROTECTED]
Date: 06-Mar-01
Time: 11:19:49
--
Scott T. Hildreth wrote:
I have a couple of questions,
1) I got DBI::Proxy working on a Unix box connecting
to another Unix Box, running Oracle. I had to alter
Proxy.pm to get it to run. I added the following,
$dsn =~ s/dbi:Proxy://i;
..when DBD::Proxy
301 - 375 of 375 matches
Mail list logo