Maybe there is another Scott that was going to set up FAQ-O-Matic,
I don't know anything about that, I was just going to send a
"Redbrick-ODBC" Faq.
On 09-Apr-2002 Sterin, Ilya wrote:
> Ah,
Any
DBD for Oracle 9i
Scott
Newman
SBC Internet
Services, Network Operations Tools Development 1701 Alma
Dr. Room 1S-141, Plano, TX 75075
phone:
214-495-2521
pager: 888-270-9719mobile:
214-478-9316
fax: 214-495-2253
easier to read and manage first. The above code is NOT capable of
being reused in obvious ways (suppose $query contained quote marks or shell
metacharacters).
--
Peter Scott
Pacific Systems Design Technologies
http://www.perldebugged.com
--Original Message-
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:47 AM
To: 'Michael Ragsdale'; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
OK. Sorry for my being stupid. Everyon
my own. Unfortunately, I am quite
limited on time, as I am sure everyone is. Thank you all very much for the
help. Please bear with me, and I will do my best to refrain from being
thick headed. :)
-Original Message-
From: Michael Ragsdale [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April
the
database?!?! Below is the "working" UPDATE line:
$dbh->do(qq{UPDATE systems SET $set WHERE 'Name = $name'});
Not sure what is wrong now though. :(
-Original Message-
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, Apr
if $set;
$set .= $key . "=\'$$key\'";
}
}
Thanks again.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:40 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: UPDATE Statement Problem...
THe problem with the update
Following another suggestion, I tried using the 'qq' quoting method
and received the following error.
DBD::mysql::db do failed: Unknown column 'harry' in 'where clause' at
sys_db_update1.pl line 41, line 81.
-Original Message-
From: NIPP,
sage-----
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:20 AM
To: 'Michael Ragsdale'; 'Tielman J de Villiers'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
Wow!!! This is one awesome mailing list. I r
). Once I get that
part figured out and going, I think I can home in on the problem rather
quickly. Then I will just have to port this portion of code from my laptop
to my Unix platform.
Thanks again for all of the helpful suggestions. Almost everything
you guys have responded with so far
;); #Just added!!!
} else {
-Original Message-
From: Tielman J de Villiers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 9:39 AM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
Check how you connect -- if Autocommit is not o
uot;, $dbh->errstr, "\n";
}
}
This database stores system information. I have written Perl
scripts to collect all of this information from the systems, format the
output, and FTP it over to the database server. I have no problem INSERTing
new systems into the database,
#x27;m missing to move my Perl project
>> development on to
>> my laptop. I did some quick checking in other places, but
>> came up empty. I
>> see an 8i client for OS 9, but I have a hard time believing
>> that OS X isn't
>> out there somewhere.
>&
There are a number of cpan tools that will do that - you just basically need
anything that will do julian or other time format conversion. I have seen
others use Time::Calc and I tend to prefer Time::Manip.
Scott
--- Charitha <[EMAIL PROTECTED]> wrote:
>
>
> Hello all,
>
10/01/98 C Front-end, 7.2.1
hth,
dave scott
iowa state university
When you get to the point where you really understand your
computer, it's probably obsolete.
On Fri, Feb 08, 2002 at 12:25:45PM -0500, Richard A. Nakroshis wrote:
yes is does, but you can get it at,
ftp://pause.perl.org/pub/PAUSE/authors/id/TIMB/
> Scott,
>
> I saw your message and Pause message too, but wasn't able to find it on
> cpan.org. Does it take
Got the Pause message, thanks Tim.
STH
On 08-Feb-02 Scott T. Hildreth wrote:
>
> Tim,
>
> Will you be posting the this talk any time soon?
>
>
> On 27-Dec-01 Tim Bunce wrote:
>> I'm putting together a "Using Perl with Or
e original transaction, and not create a new
>> connection, as with SQLJ etc. Fantastic stuff!!!
>>
>> I really _do_ have to get out more! 8-)
>>
>> Rgds,
>> AndyD
>>
>> =
>> Make Someone Happy. Buy a Copy of:
>> => http://www.oreilly.com/catalog/oracleopen/
>> -BEGIN GEEK CODE BLOCK-
>> GO/SS/TW d- s+:+ a C++$ U++$ P$ L++$ !E W+ N+ K- W O-
>> M+ V-- PS+ PE++ Y+ PGP t+@ 5 X- R* tv- b+++ DI++ D G e++
>> h r+++ y
>> --END GEEK CODE BLOCK--
>>
>> __
>> Do You Yahoo!?
>> Buy the perfect holiday gifts at Yahoo! Shopping.
>> http://shopping.yahoo.com
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 08-Feb-02
Time: 09:20:40
--
dash-dash style comments. But to answer your question, currently
the preparser will treat '--' as comment and it will return what
ever the driver indicates is acceptable.
STH
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 25-Jan-02
Time: 12:59:39
--
blocks (="pseudo-
>> child-processes" ?). Perhaps opinions about ActivePerl and Storable are
>> triggered by this and probably other broken ActivePerl releases. The current
>> release (631) does not exhibit this problem.
>
> Are you saying that DBD::ProxyServer works with release 631?
>
> Tim.
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 21-Jan-02
Time: 08:16:00
--
ble, but it just doesn't seem to work!
I'm using Activestate Perl 5.6.1 build 626 on Win2k with the latest
MSSQLReporter (1.00) from Activestate's PPM repository against a MS-SQL 7.0
database.
Thanks in advance for any help,
Scott Phelps
[EMAIL PROTECTED]
Webkorner Interne
es
> including DBD::AnyData and DBD::CSV
>
>> you need to escape a
>> single quote with a backslash, not with another single quote, as you
> would
>> for most other DBDs.
>
> Which is why it is better to use the $dbh->quote method or placeholders
> - they
> are more portable!
>
> --
> Simon Oliver
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 11-Jan-02
Time: 09:42:05
--
base via Perl. Hate to think I'd need to go around installing Oracle on
> ever person's box that needs to do this...
>
> Help?!?
>
> Brian LaMere
> Diversa
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 07-Dec-01
Time: 12:56:15
--
in the 9i libraries
> with DBD ?
>
> I an NOT talking about using an existing DBI/DBD setup using 8.x.x oracle
> libraries to connect to an oracle 9i database.
>
> Keith
>
>
>
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 07-Dec-01
Time: 08:59:08
--
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
>
e is recieving these.
------
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 04-Dec-01
Time: 13:45:17
--
27;user/passwd@sid', '', {});
/\
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 jus
'm currently using DBI 1.20 and the DBD:ORACLE 1.12 and I keep getting the
> lines :
> Message 12514 not found; product=RDBMS;facility=ORA (DBD ERROR:
> OCIServerAttach)
>
>
> Thanks
> Ron
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 04-Dec-01
Time: 08:59:33
--
PPM that is available at
> ActiveState? Rewriting is an option ( not a very attractive one mind you )
> but I don't really want to go 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
--
right direction, I would very
> much appreciate it.
>
> Regards,
>
> Patrick 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 tes
ader at nntp://nntp.perl.org
:)
--
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. :-)
...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
Versions do matter, I believe CLOB was fixed in DBD::Oracle 1.09.
I had emailed Becka yesterday to try the new versions.
> my $result_ins = $insert_cr ->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";
> }
>
Report
Server';
print header(),
start_html({-'style'=>{-'code'=>$style}, -title=>$pagetitle});
and later...
print caption("Sorry, I was unable to process your request. Please try
again.. "), "\n";
Much neater eh?
:-)
if you want to ha
try one of the $dbh-select(all|row)_arrayref, this does a prepare & execute
for you. Do a 'perldoc DBI' to read about them.
a SELECT query.
=:o
> In the case of DBD::Sybase $h->rows() will return the correct number
> of rows only *after* all the rows have 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/
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_colum
dmin refuses to run any 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] (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
his too, and it has *seriosly* damaged any credibility I
might have gained with the admin I'm 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/
> 1;
# although this might...
safe_error("no match in database for ID $id")
if $rows < 1;
my %db;
$sth->bind_columns( \( @db{ @{ $sth->{NAME} } } ));# magic
while ($sth->fetch)
{
#... and no worries about which order the columns
th->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| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
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 remov
ff99',
-vlink=>'yellow'});
print start_form,
div({-align=>'center'},
h3("Map Search"),
p("Enter the name of a map title or file to search for:"),
textfield(-name=>'searchfor',
-default=>'',
-size=>30,
-maxlength=>68,
-override=>1),
br,
submit(-name=>'Submit', -value=>'Submit'),
),
end_form, hr;
if ( $search_obj eq '' )
{
# skip the database query
print end_html;
goto FINISH;
}
my $query = "SELECT Type, ID, FileName, Title, Size, ReviewFile,
ROUND(Rating, 2)
FROM $map_db
WHERE FileName LIKE '%$search_obj%' OR Title LIKE
'%$search_obj%'
ORDER BY Rating DESC, Type, FileName";
print start_div({-align=>"center"}),
start_table({-border=>"0", -cellpadding=>"0", -cellspacing=>"2",
-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 PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
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
't already.
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 min
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. Go
ngth:698276 bytes
Concurrency Level: 10
Time taken for tests: 115.382 seconds
Complete requests: 100
Failed requests:0
Keep-Alive requests:0
Total transferred: 71242100 bytes
HTML transferred: 71215208 bytes
Requests per second:0.87
Transfer rate: 617.45 kb/s received
Connnection Times (ms)
min avg max
Connect:1 122 3017
Processing: 9771 11087 11502
Total: 9772 11209 14519
I'm willing to post my script here to see if any of you individuals can
tell me what, if anything, I did wrong with MY script that could have
caused MySQL to die with "too many connections" or whether this is a
problem with DBI and DBD::MySQL in its present form.
I await your response. (with heavy sighs and a great deal of frustration)
--
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 int
e.
Can anyone clue me in?
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
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&q
hrow ) {
td([
'$columns[0]', '$columns[1]', '$columns[2]', '$columns[3]',
'$columns[4]', '$columns[5]', '$columns[6]', '$columns[7]',
'$columns[8]', '$columns[9]', '$columns[10]','$columns[11]',
'$columns[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.
most up-to-date from CPAN v0.23). What I can't get it to do
is recognize a multi-line field, ie:
field1_text, field2_text, "field3_line1^M
field3_line2^M
field3_line3",field4_text,...
I even tried stripping out the doze (^M). However, I'm not so
concerned about that part, just in case someone has some insight on that.
TIA
Scott
ences, Usually resulting in their never recieving replies to their
missive.
Far better to post to the list from a new message and add the mailing
list address to your addressbook instead.
just my $.02
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |
or wasting time,
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} = 'd
BD::Pg on Linux (and more recently, W2K) for over 2 years.
- Scott
Scott Scecina
In Mind, Inc.
;$ENV{DBI_AUTOPROXY};dsn=dbi:$driver:$dsn";
$dsn =~ s/dbi:proxy://i;
$driver = 'Proxy';
DBI->trace_msg(" DBI_AUTOPROXY: dbi:$driver:$dsn\n");
}
STH
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 11-Oct-01
Time: 16:59:27
--
skipped.
> Failed 13/14 test scripts, 7.14% okay. 273/276 subtests failed, 1.09% okay.
> *** Error code 2
>
> Stop in /usr/local/www/install/Msql-Mysql-modules-1.2215/mysql.
> *** Error code 1
>
> Stop in /usr/local/www/install/Msql-Mysql-modules-1.2215.
> mysql3# make install
> Installing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.so
> Installing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.bs
> Files found in blib/arch --> Installing files in blib/lib into architecture
> dependend library tree!
> Installing /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/DBD/mysql.pm
> Installing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Bundle/DBD/mysql.pm
> Installing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql/Statement.pm
> Installing /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm
> Installing /usr/local/man/man1/dbimon.1
> Installing /usr/local/lib/perl5/5.00503/man/man3/DBD::mysql.3
> Installing /usr/local/lib/perl5/5.00503/man/man3/Bundle::DBD::mysql.3
> Installing /usr/local/lib/perl5/5.00503/man/man3/Mysql.3
> Installing /usr/bin/dbimon
> Writing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/Msql-Mysql-modules/.p
> acklist
> Appending installation info to /usr/libdata/perl/5.00503/mach/perllocal.pod
>
> Have a nice day ...
>
> Sincerely,
>
> Mike Cherichetti, CTO
> Advanced Resource Computing Services
> Phone (256)828-8921
> ___
>
> Internet Advertising Delivery 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,
&
t typically gets installed? It's kind of hard to weed 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
--
ck through all the scripts and change the input and
output record separators unless I absolutely 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
this morning off-perl question.
Thanks you very much,
Scott Purcell
e if for example a prepare call fails it returns undef 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: Anthon
-fall :(
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
>
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
ce.
Anthony Scott
om updates, insert and of course
> selects from my DB.
> Your help would be appreciated!
> Thanks ...
> Regards Riyaad.
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 14-Sep-01
Time: 08:29:30
--
est will fix those.
> (I should have made it explicitly 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
--
"Can't write to /dev/null: $!";
> defined(my $pid = fork) or die "Can't fork: $!";
>exit if $pid;
>setsidor die "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
--
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
> cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options:
> Built under linux
> Compiled at Aug 7 2000 10:59:51
> @INC:
> /usr/lib/perl5/5.6.0/i386-linux
> /usr/lib/perl5/5.6.0
> /usr/lib/perl5/site_perl/5.6.0/i386-linux
> /usr/lib/perl5/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
Time: 11:47:17
--
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:
(inform
;});
>> $sth->bind_param_inout(":id",\$addr_id,32,DBI::SQL_INTEGER);
>> $sth->bind_param(":address",$address);
>>
>> which gives me the following error message at the first
>> bind_param_inout
>>
>> Modification of non-creatable a
}
*dest++ = *src++;
continue;
}
..I think this is where the problem is, the \\ escapes the '.
On 14-Aug-01 Scott T. Hildreth wrote:
>
> Actually the preparsing is done by the DBD's. Look at the
> dbd_preparse() function in dbdimp.c file under DBD::PG dist.
>
> On 15-Aug-
onfigs{'tablename'} where dirid like
> $argument_undescore_something and lang=?");
> $sth->execute($passed_lang,$passed_dirid);
> while($row=$sth->fetchrow_arrayref)
>
>
> }
>
> i've included $dbh->trace(7) - here is what it writes:
>
>
> dbd_st_preparse: statement = >select * from dirs_items1 where dirid like
> ?||'\\_\%' escape '\\' and lang=?<
> dbd_preparse scanned 1 distinct placeholders
>
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 14-Aug-01
Time: 12:36:12
--
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] wrote:
> print FILE @rows . '\t;
why didn't you try
print FILE join("\t", @rows), "\n";
?
of course the dump method mentioned in the prev post is a good idea too
;-)
--
Scott R. Godin
running DBI 1.18, DBD::Oracle version 1.07 and 8.1.7.
Any help is appreciated.
Anthony Scott
}else{#there was no match
>> }
>> }
>>
>> The above system WORKS, and works pretty well for tables of <1000 records.
>> But when I'm dealing with 10,000 or 50,000 records, this search becomes and
>> incredible drain.
>>
>> Is there a way to perform this operation without running 25,000 SELECTs when
>> @compare_array has that many ID's?
>>
>> Thank you,
>> Richard Still
>> Oakbox.com
>
> --
> Chip Turner [EMAIL PROTECTED]
> RHN Web Engineer
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 18-Jul-01
Time: 18:10:12
--
ice would be much appreciated.
> Thanks,
> Bill.
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 11-Jul-01
Time: 09:11:36
--
-7087
> Cell: 610-574-7706
> Pager: 877-239-4003
>
>> -Original Message-
>> From: Scott T. Hildreth [SMTP:[EMAIL PROTECTED]]
>> Sent:Monday, July 02, 2001 2:44 PM
>> To: Scott T. Hildreth
>> Cc: [EMAIL PROTECTED]
>> Subject:
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
I fixed it by setting the 'SHELL=/usr/local/bin/zsh' so
the LD_LIBRARY_PATH is getting set before Perl is executed.
I'm not sure why the behavior changed, but it works :-)
On 02-Jul-01 Scott T. Hildreth wrote:
>
> I wonder if anyone has run into this problem. I upgrade o
RY_PATH} = '/oracle/8.0.5/lib';
which worked until the updates. Does anyone know if this a problem with
Perl5.6.1 or DBI-1.18?
Thanks,
STH
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 02-Jul-01
Time: 12:14:12
--
rd does not exist - adding office $officenumber\n";
$sth2->execute($officenumber, $officename) or
error_report("Error inserting new office record:
$DBI::errstr");
}
}
$rcnt++;
}
$sth1->finish;
$sth2->finish;
$rcnt=$rcnt-1;
print
:)
Thanks,
STH
On 15-Jun-01 MikeBlezien 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
> possibl
n, Ilya wrote:
> Well depending on why it is failing. You error message does not provide any
> help. Try using $DBI::errstr in it and also use trace() at level 2 (see
> docs). You can then submit both to us if you can't figure out yourself.
>
> Ilya
>
> -Original
,
but it did quit in another sub with,
main::update_newcust(qwl_newcust.pl:430):
430:if ($@) {
100 levels deep in subroutine calls!
Anybody know what I am missing here???
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 15-Jun-01
Time: 13:33:13
--
'-Wl,-E -shared -lperl -lm '
>
>
> Characteristics of this binary (from libperl):
> Built under freebsd
> Compiled at Apr 21 2001 08:25:58
> @INC:
> /usr/libdata/perl/5.00503/mach
> /usr/libdata/perl/5.00503
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
> /usr/local/lib/perl5/site_perl/5.005
> .
>
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 14-Jun-01
Time: 10:33:01
--
, but ya never know till you try :)
>
> Just trying to narrow down the problem.
> or match '12345 %'?
> What if the value stored is '12345'
>
> -Original Message-
> From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 12, 2
| Rick Osterberg [EMAIL PROTECTED]|
>> | Database Applications Specialist FAS Computer Services |
>> +--+
>>
>
> +--+
>| Rick Osterberg [EMAIL PROTECTED]|
>| Database Applications Specialist FAS Computer Services |
> +--+
>
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 12-Jun-01
Time: 16:43:41
--
like would work, but it will match '123456' as well as '12345 '.
On 12-Jun-01 Scott T. Hildreth wrote:
>
> DBD::Oracle trims the trailing spaces by default.
> try this select * from bar where bar = rpad(?, 8).
>
> or
>
> use DBI;
> use DBD::Oracle
Let me re-phrase it
I'm currectly running Oracle 8.1.5 with the following env.
Unix Platform
DBD-Oracle-1.03
DBI-1.13
perl 5.00503
Do I need to upgrade the DBI/DBD software to support 8.1.7?
Anthony Scott
"Sterin, Ilya" wrote:
>
> Well it definitely wouldn't
Do I need to upgrade the DBI software for Oracle 8.1.7 support?
I'm current running DBI-1.13.
Anthony Scott
Thanks for your help.
Tim
- 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
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 -
Fr
so it was able to support what
you're
>doing. DBI can't solve the problem. You can probably accomplish what you
need
>to while still using Access, if you break up your operation into smaller
>queries, or only update one table at a time.
>
>HTH.
>
>Wes
- Original
All,
New to Access I'm finding:-
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)
And thinking "how do I tell it that it's an updateable query?"
The same sort of thing worked fine with Oracle...
Any help appreciate
he connect 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 PROTECTE
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 trou
line 288.
make: *** [test_dynamic] Error 255
[root@coral /denis]#
I have tried installation approx 15 times, but all the times same
error..
Could any one 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
301 - 400 of 429 matches
Mail list logo
