RE: Perl 5.6 to 5.8 caveats for DBI

2005-01-09 Thread Michael Ragsdale
> I just upgraded to Perl 5.8.6 and the latest DBI binaries I > found at that site are for 5.8.4. Will they still work or should I > uninstall 5.8.6 and install 5.8.4 from ActiveState's archive, then install > the modules? Or, even better, is there another repository that has DBI's > compiled

RE: Perl 5.6 to 5.8 caveats for DBI

2005-01-07 Thread Michael Ragsdale
At 12:23 PM 1/7/2005, Capacio, Paula J wrote: >Are there any caveats that I should look out for >regarding ActiveState Perl 5.8 and the latest DBI modules? Get your DBI and DBD modules from: http://ftp.esoftmatic.com/DBI/ Thanks. Now another question I just upgraded to Perl 5.8.6 and the late

Perl 5.6 to 5.8 caveats for DBI

2005-01-07 Thread Michael Ragsdale
I'm running the following: Win2k ActiveState Perl 5.6.1 DBI 1.28 DBD-Oracle 1.06 DBD-mysql 2.04 In order to utilize Win32-Printer, I need to upgrade to Perl 5.8. I've Googled and found nothing that really screams out to me as to why I would have any problems in doing so (and the DBI FAQ looks to

Re: Perldocs website?

2004-06-04 Thread Michael Ragsdale
At 10:19 AM 6/4/2004, Hardy Merrill wrote: Thanks Jeff - didn't know about that, but the Active State documentation pages are very nice! One question - does the documentation for CPAN modules that I install get inserted into the Active State documentation? For example, I have DBI installed but I c

Re: Perldocs website?

2004-06-03 Thread Michael Ragsdale
At 11:17 AM 6/3/2004, Hardy Merrill wrote: Anyone know where the perldocs website went? I just went to google and nothing seems to come up. I can't find much on www.perl.org. TIA. Hardy Merrill Do you mean http://perldoc.com/ ?

Re: insert into two table and check table perl DBI

2004-03-31 Thread Michael Ragsdale
hai everyone, i have write scripts perl on the top and if i input data 12345678,Hendra Kusnandar,123456 data will insert into table user, and if i input wrong format data will insert into log. this scripts is work but if i insert again 12345678,Hendra Kusnandar,123456 scripts will error and the me

Re: fetch( ) without execute( ) Error...

2003-09-03 Thread Michael Ragsdale
At 12:43 PM 9/3/2003, NIPP, SCOTT V (SBCSI) wrote: I keep coming up with this error, but I AM performing an execute prior to the fetch. I have seen some other threads on this, and have upgraded the DBD:Mysql to the latest version on CPAN. Any ideas? Here is a small portion of the code: i

Re: Oracletool - KARMA

2003-09-03 Thread Michael Ragsdale
At 10:45 AM 9/3/2003, Nguyen, David M wrote: There is used to be a tool "KARMA" to monitor oracle database. If someone knows a link I can go to download it, please tell me. Thanks, David http://search.cpan.org/author/SHULL/karma100/

RE: Database layout and query questions...

2003-06-18 Thread Michael Ragsdale
>>Thanks again for all the good feedback. If anyone can recommend >>a good book that could help me out on this I would be most >>appreciative. I have some MySQL reference books, but nothing that really >>goes into database design. I am planning on taking some database courses at a local I did

Re: mySql Delete Problem

2003-03-29 Thread Michael Ragsdale
At 01:04 PM 3/29/03 +0100, Basti Hösch wrote: Hi there, I've got a very strange problem when I'm trying to delete records from a mySql-Table. This table has no special features, as the first field an auto-increment integer as primary key (named id), then three varchar fields with different sizes.

DBD login failed

2003-01-07 Thread Michael Ragsdale
I cannot get a script to run from a browser. I've added the ORACLE_HOME environment variable, but it doesn't seem to help. With it or without it, the message is the same. The error message is: "Can't connect ORA-12640: Authentication adapter initialization failed (DBD: login failed)."

Re: MySQL and Data manipulation

2002-12-06 Thread Michael Ragsdale
At 09:55 AM 12/6/2002, Chris Rogers wrote: I have a question about the configuration of mysql. Let's say I have a field that is defined as a decimal(10,3). To my understanding that field will hold values up to 999.999. My problem is that if I do an insert or using that field with a value th

Re: Table Names

2002-11-26 Thread Michael Ragsdale
Sorry if I was unclear. I was answering the original question of obtaining a list of all the table names. -Mike At 12:48 PM 11/26/2002, Jeff Seger wrote: OK, but that's not using the SHOW TABLES command. Maybe I was unclear about that. On Tue, 2002-11-26 at 12:10, Michael Ragsdale

Re: Table Names

2002-11-26 Thread Michael Ragsdale
Yes you can. From the fine cheetah book, under metadata... my @tables = $dbh->tables(); foreach my $table ( @tables ) { print "Table: $table\n"; } -Mike At 11:49 AM 11/26/2002, Jeff Seger wrote: I may be wrong...I seem to be making a habit of it lately...but I don't think you can. SHO

RE: LongReadLen use

2002-11-15 Thread Michael Ragsdale
o use LongReadLen in this situation, this is not why you are getting errors. Post more code:-) Ilya -Original Message- From: Michael Ragsdale To: [EMAIL PROTECTED] Sent: 11/15/02 2:32 PM Subject: LongReadLen use I have a query that is pulling a LONG field from an Oracle DB. I received

LongReadLen use

2002-11-15 Thread Michael Ragsdale
I have a query that is pulling a LONG field from an Oracle DB. I received the following error:illegal use of LONG datatype . I found information on LongReadLen in the cheetah book, but I'm still a bit confused as to the syntax or exactly how to implement the attribute. After searching

RE: UPDATE Statement Problem...

2002-04-02 Thread Michael Ragsdale
At 12:01 PM 4/2/2002, NIPP, SCOTT V (SBCSI) wrote: > New problem now. I appear have resolved my earlier problems. The >final issue appears to have been that the SQL statement was interpreting the >WHERE clause as having multiple arguments. Quoting the where clause seems >to have resolve

RE: UPDATE Statement Problem...

2002-04-02 Thread Michael Ragsdale
At 10:50 AM 4/2/2002, NIPP, SCOTT V (SBCSI) wrote: > I added a COMMIT immediately after the UPDATE, and still have the >same problem. Below is exactly what I added, with the lines immediately >before and after. > > $dbh->do(q{UPDATE systems SET = $set WHERE Name = $name LIMIT 1}

Re: What is Betrive?

2002-01-09 Thread Michael Ragsdale
At 02:51 PM 01/09/2002, you wrote: >Has anyone heard of Betrive? > >I have had a look on Google, but there's not much on it. It's spelled Btrieve. Btrieve is now Pervasive SQL, if I recall correctly. Try http://www.pervasive.com -Mike

Re: Paradox

2001-10-11 Thread Michael Ragsdale
Use DBD::ODBC. -Mike At 07:04 PM 10/11/01 -0700, Adam Gomes wrote: >Does anyone know of any perl DBD for Paradox yet? I haven't been able to >find one anywhere.

RE: :Oracle, Oracle Client on Red Hat 7.1 - sob story

2001-10-05 Thread Michael Ragsdale
Oracle 8.1.7 will indeed install cleanly on RH 7.1. You can make your glibc libraries compatible. I'm not sure if you need all of these, but I just checked my installation directory and it appears that I installed the following RPMs: compat-binutils-5.2-2.9.1.0.23.1.src.rpm compat-egcs-5.2-1

Re: Oracle prepare failed?

2001-09-18 Thread Michael Ragsdale
> > > > my $sth = $dbh->prepare(qq(SELECT fuser.us_initl, . . . > > > > Thanks > > > > - Original Message - > > From: "Michael Ragsdale" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Monday, September 1

RE: Oracle prepare failed?

2001-09-17 Thread Michael Ragsdale
ble_name >3. there is no select privilege granted to the dbi user on one of the tables > > > > > > Dong Wang > > Grand Central Networks > > [EMAIL PROTECTED] > > >-Original Message- >From: Michael Ragsdale [mailto:[EMAIL PROTECTED]] >Sent: M

Oracle prepare failed?

2001-09-17 Thread Michael Ragsdale
I have a query that works just fine in Oracle SQL*Plus, but I receive the following error when run through DBI. Line 35 states: my $sth = $dbh->prepare(qq(SELECT fuser.us_initl, I'm running: Redhat 7.1, Perl 5.6.0, DBI 1.14, DBD::Oracle 1.06 Here is t

Re: '?' in SQL-comments fails

2001-09-11 Thread Michael Ragsdale
ser where user = ?"); It is not in commented code, it is quoted text. Try placing your comment outside of your prepare statement. ******** Michael RagsdaleVoice: (865)974-3957 Programmer/Systems Admin

Re: Table aliasing in a SELECT statement

2001-08-07 Thread Michael Ragsdale
ve a typo on your last select field. Perhaps it should be a.field6 and not alfield6? ** * Michael Ragsdale E-mail: [EMAIL PROTECTED] * * Programmer/Systems Admin Voice: 865-974-3957 * * The University of Tennessee, Knoxville Fax: 865-974-8474 * **

RE: I want to unsuscribe

2001-06-06 Thread Michael Ragsdale
header: List-Post: <mailto:[EMAIL PROTECTED]> List-Subscribe: <mailto:[EMAIL PROTECTED]> List-Unsubscribe: <mailto:[EMAIL PROTECTED]> List-Help: <mailto:[EMAIL PROTECTED]> ******** Michael Ragsdale

Re: Installing DBD:Oracle

2001-05-31 Thread Michael Ragsdale
1.06 , This is a known bug. Downgrade to DBI 1.14 and DBD-Oracle should install just fine. ****** * Michael Ragsdale E-mail: [EMAIL PROTECTED] * * Programmer/Systems Admin Voice: 865-974-3957 * *

DBD::Oracle install

2001-05-24 Thread Michael Ragsdale
erl.3pm [root@jupiter DBD-Oracle-1.06]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/base..ok t/general...

DBD::Oracle install

2001-05-21 Thread Michael Ragsdale
stallation binaries from Oracle for the Linux box, but they no longer support 7.x. and I've heard that 8.x is not compatible with 7.x. Any other suggestions on getting DBD::Oracle installed? ****** * Michael Ragsdale

Re: Auto increment - return value

2001-05-09 Thread Michael Ragsdale
> -- The Eighth Networking Truth from RFC 1925 > >_ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ** * Michael Ragsdale E-mail: [EMAIL PROTECTED] * * Programmer/Systems Admin Voice: 865-974-3957 * * The University of Tennessee, Knoxville Fax: 865-974-8474 * **