DBI::Shell producing errors during test on RedHat 9

2003-11-10 Thread Scott R. Godin
cpan install DBI::Shell Running install for module DBI::Shell Running make for T/TL/TLOWERY/DBI-Shell-11.93.tar.gz Is already unwrapped into directory /root/.cpan/build/DBI-Shell-11.93 CPAN.pm: Going to build T/TL/TLOWERY/DBI-Shell-11.93.tar.gz Checking if your kit is complete... Looks good

Re: column_info, mysql, and SET/ENUM values

2003-10-17 Thread Scott R. Godin
Tim Bunce wrote: $ perl col_info.pl Undefined subroutine DBD::mysql::db::SQL_VARCHAR called at /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/mysql.pm line 337. which I don't quite understand. I tried adding :sql_types to the DBI declaration, but no go. It's a minor bug in

Fetch without Execute...

2003-10-14 Thread NIPP, SCOTT V (SBCSI)
this is a start. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: Fetch without Execute...

2003-10-14 Thread NIPP, SCOTT V (SBCSI)
Thanks for the feedback. Your guess about 'key' being a MySQL reserved word was correct. Now to take a stab at the next error, and do a little reading on placeholders. Thanks again. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

MySQL UPDATE Question...

2003-10-14 Thread NIPP, SCOTT V (SBCSI)
don't even need to worry about moving this data around. Once again, any suggestions would be most appreciated. Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

column_info, mysql, and SET/ENUM values

2003-10-13 Thread Scott R. Godin
A while back in February, Tim and Ron were discussing DBD::mysql and column_info.. This is the only thing I could find that *may* relate to my question, so I'm asking here for further clarification. It's not clear in the docs (at least not to me) whether I can have column_info return the

Re: MYSQL where clause case sensitive?

2003-10-13 Thread Scott R. Godin
[EMAIL PROTECTED] wrote: is MYSQL where clause case sensitive? it looks like it is not redhat 9 mysql 3.23.56 name='Bob' same as name='bob' For case-sensitivity, use the BINARY cast operator: select * from $table WHERE name = BINARY 'Bob'; will only match if it's an exact case

Re: DBD:ODBC hangs when inserting/updating lots of rows

2003-10-07 Thread Scott Dial
in .03 seconds. The delays were intermittent but looked like it was hung. Just a thought for you to try. -Scott On Tue, 7 Oct 2003 [EMAIL PROTECTED] wrote: Hi, wie got a very strange problem here on insertion/update of rows into an MS-ACCESS 97 DB which gives us a lot of headache

ORACLE::OCI still in Beta?

2003-09-23 Thread Scott Dial
be incorporated into the DBD::Oracle driver? Many thanks, Scott

Re: Odd behavior from DBD::CSV

2003-09-04 Thread Scott R. Godin
Unknown Sender wrote: W li?cie z wto, 26-08-2003, godz. 18:33, Jeff Zucker pisze: Well, I thought so, and that's why AnyData works that way. But CSV worked with the \015\012 default when I inherited it and there are too many scripts out there based on that behaviour for me to contemplate

fetch( ) without execute( ) Error...

2003-09-03 Thread NIPP, SCOTT V (SBCSI)
. Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

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

2003-09-03 Thread NIPP, SCOTT V (SBCSI)
-fetchrow_hashref ('NAME_lc')) { undef $set2; This now includes the other execute. Thanks again. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 11:54 AM To: NIPP, SCOTT V (SBCSI) Cc: [EMAIL PROTECTED] Subject: Re: fetch

Help with some DBI errors...

2003-09-03 Thread NIPP, SCOTT V (SBCSI)
information for someone to help figure out what I am doing wrong here. Thanks in advance for the help. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

MySQL keys problem...

2003-08-14 Thread NIPP, SCOTT V (SBCSI)
execute failed: Duplicate entry '0' for key 1 at ./space_data.pl line 62. Note: The first line of the included code is line 39. Thanks. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

Perl/MySQL script...

2003-07-29 Thread NIPP, SCOTT V (SBCSI)
to screw around with installing or copying MySQL libraries on 80+ servers. Does anyone have any suggestions on how to address this issue? Thanks in advance for the feedback. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: Perl/MySQL script...

2003-07-29 Thread NIPP, SCOTT V (SBCSI)
. Thanks. -Original Message- From: William Goedicke [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 3:10 PM To: NIPP, SCOTT V (SBCSI) Cc: [EMAIL PROTECTED] Subject: Re: Perl/MySQL script... Dear Scott et al - SCOTT == SCOTT V NIPP NIPP writes: SCOTT I am developing a series

DBD MySQL Installation Help...

2003-07-15 Thread NIPP, SCOTT V (SBCSI)
get the DBD driver to install on systems without MySQL installed? Thanks in advance for the help. If I missed this in the docs, I apologize in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

Perl/MySQL question...

2003-07-15 Thread NIPP, SCOTT V (SBCSI)
kind of output from the reference table insert, I can avoid a second query to retrieve this number. Make sense? Thanks in advance for the help, and sorry again if this is off topic for this group. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: Programming the Perl DBI - 2nd edition coming?

2003-07-14 Thread Neibarger Scott H
Jungian Synchronicity? It's not just a funny thing, it's downright _weird_ sometimes. I don't get it. -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 2:47 PM To: Hardy Merrill; [EMAIL PROTECTED] Subject: Re: Programming the Perl DBI - 2nd edition

RE: Database layout and query questions...

2003-06-18 Thread NIPP, SCOTT V (SBCSI)
:35:20 -0500, NIPP, SCOTT V (SBCSI) wrote: Hi Scott 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

RE: Database layout and query questions...

2003-06-18 Thread NIPP, SCOTT V (SBCSI)
. Well, that's about all I can think of at the moment. I am sure that I will have plenty more questions as this progresses. Thanks again for the feedback. -Original Message- From: andy law (RI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 3:33 AM To: NIPP, SCOTT V (SBCSI

RE: qustion about oop and dbi

2003-06-18 Thread Neibarger Scott H
I would recommend Object Oriented Perl by Damian Conway. That's probably the best book you can read; it's full of real-world examples and witty commentary. -Original Message- From: Jan Theofel [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:44 PM To: [EMAIL PROTECTED] Subject:

RE: Database layout and query questions...

2003-06-17 Thread NIPP, SCOTT V (SBCSI)
in the mean time. -Original Message- From: David N Murray [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:21 PM To: NIPP, SCOTT V (SBCSI) Cc: '[EMAIL PROTECTED]' Subject: Re: Database layout and query questions... Some questions, that might help you answer yours: What's the advantage

RE: make DBI-1.35 Fails on HP-UX 11i and Perl 5.8.0

2003-04-06 Thread Scott R. Godin
Mkb wrote: #include socket int main() { exit(0); }; gcc -o t.o -c t.c gives t.c:1:18: socket: No such file or directory. Not being a C programmer, I'm not sure how I'd get the compiler to include this header. Any ideas? The socket.h files are located here: /usr/conf/sys/socket.h

RE: make DBI-1.35 Fails on HP-UX 11i and Perl 5.8.0

2003-04-05 Thread Scott R. Godin
[EMAIL PROTECTED] wrote: This looks like your GCC can not parse /usr/include/socket.h Can you test that? cat t.c EOF #include socket int main() { exit(0); } EOF gcc -o t.o -c t.c posting this just for comparison purposes... my copy of redhat 8 here doesn't have socket.h in

Re: MySQL Select question.

2003-03-31 Thread Scott R. Godin
Ron Stephan wrote: The way I understand it, it will select all 100,000 and then try and display them all. Between the server and the browser something is bound to break or get stupefying slow. Am I wrong? Most of the time people are going to have filter criteria in the display - maybe it

Re: problems with version of dbi or dbd-odbc?

2003-03-31 Thread E. Scott Stricker
I've seen similar problems with the newer versions of the dbi and odbc software on my WIN2K box running MS SQL Server. Have not seen any reported workarounds or fixes yet. E. Scott Stricker - NGIT @ Smartlink - Original Message - From: Adam Peterson [EMAIL PROTECTED] To: [EMAIL PROTECTED

Re: DBD-ODBC Strange Behavior?

2003-03-27 Thread E. Scott Stricker
of versions of the ODBC package. It used to work. If you know where I can get older versions, please let me know. Thanks E. Scott Stricker - NGIT @ Smartlink - Original Message - From: Adam Peterson [EMAIL PROTECTED] To: E. Scott Stricker [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent

Non-blocking DBD::Oracle connections?

2003-03-26 Thread Peter Scott
? Or just the usual $SIG{ALRM}/eval approach? -- Peter Scott http://www.perldebugged.com

Re: DBD-ODBC Strange Behavior?

2003-03-26 Thread E. Scott Stricker
with older software. E. Scott Stricker - NGIT @ Smartlink - Original Message - From: Adam Peterson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 4:59 PM Subject: DBD-ODBC Strange Behavior? hello, i'm running my script on a win2000 box called eggpayorteam. i have

Re: how to install DBI

2003-03-25 Thread Scott R. Godin
Ron Savage wrote: On Sun, 23 Mar 2003 16:37:43 -0500, Scott R. Godin wrote: Ron Savage wrote: Hi Scott Yes, unfortunately there's no default $ENV{TEMP} on unix.. I've been considering using File::Temp, File::MkTemp, or IO::File instead, but just haven't gotten around to futzing

New errors access MS SQL Server Database on (CREATE DATABASE and Batch SQL Statement)

2003-03-25 Thread E. Scott Stricker
execute statement\n$sqlstmt_s\n$DBI::errstr; # LINE 827 $sth_s-finish; E. Scott Stricker - NGIT @ Smartlink

Re: how to install DBI

2003-03-24 Thread Scott R. Godin
Ron Savage wrote: On Sat, 08 Mar 2003 22:28:09 -0500, Scott R. Godin wrote: Hi Scott I've written a very nice module-reporting script that helps me to stay on top of installed modules and easily see when they require updates from CPAN for bugfixes. http://www.webdragon.net/mr/ Great

Re: Error installing DBD::mysql

2003-03-14 Thread Scott R. Godin
Snowber Khan wrote: [EMAIL PROTECTED] bugzilla]# perl -MCPAN -e 'force install DBD::mysql' CPAN: Storable loaded ok Going to read /root/.cpan/Metadata Database was generated on Wed, 12 Mar 2003 15:42:32 GMT Running install for module DBD::mysql Running make for

Re: ls: *.jpg: No such file or directory

2003-03-12 Thread Scott R. Godin
Mel Awaisi wrote: Hi My error is as the subject says, i have a script that i am trying in it to locate where a directory with images are. the part in the script that the error i think is arising from is my $dir = '/home/me/images/'; my @jpegs = `ls *.jpg`; foreach (@jpegs) {

newbie can't see what he's doing wrong.

2003-03-12 Thread Jay G. Scott
psql thingy and cut and paste the query, it works. What am I missing? (I've never gotten this to work.) j. -- Jay Scott 512-835-3553[EMAIL PROTECTED] Head of Sun Support, Sr. Operating Systems Specialist Applied Research Labs, Computer Science Div

Re: newbie can't see what he's doing

2003-03-12 Thread Jay G. Scott
I tried it without the semicolon already, same thing happens. (But I did try it again anyway.) j. -- Jay Scott 512-835-3553[EMAIL PROTECTED] Head of Sun Support, Sr. Operating Systems Specialist Applied Research Labs, Computer Science Div. S224

turns out, it's '

2003-03-12 Thread Jay G. Scott
-- Jay Scott 512-835-3553[EMAIL PROTECTED] Head of Sun Support, Sr. Operating Systems Specialist Applied Research Labs, Computer Science Div. S224 University of Texas at Austin

turns out, it's because the newbid is hysterical.

2003-03-12 Thread Jay G. Scott
. sorry about that. well, at least the trace got me out of the fog. j. -- Jay Scott 512-835-3553[EMAIL PROTECTED] Head of Sun Support, Sr. Operating Systems Specialist Applied Research Labs, Computer Science Div. S224 University of Texas at Austin

Re: how to install DBI

2003-03-09 Thread Scott R. Godin
Mel Awaisi wrote: Hi i am using Red Hat Linux 8 as a server for a project i am working on. i have installed MySQL automatically with the install of the OS. and then i installed Apache Server. i would like to install DBI in order for me to be able to use a script that i have in perl to

Re: DBD::CSV

2003-03-04 Thread Scott R. Godin
Jeff Zucker wrote: Tim Bunce wrote: On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote: use SQL::Statement; print $SQL::Statement::VERSION; Or run this command perl -MSQL::Statement= Hmm, what am I missing? That doesn't work for me with SQL::Statement. It also

RE: Using perl 5.8.0?

2003-02-26 Thread Neibarger Scott H
Programming with Perl; it's been a wonderful resource for me on this current project. If you've not purchased it, support Dr. Stein and buy his book! Scott H. Neibarger SRA International, Inc. IRS ESM project 512-460-8717

blob error need help

2003-02-17 Thread Scott Purcell
built for Oracle 7) at ./g etblob line 23. ### Thanks, Scott # #! perl -w use DBI; # binding parameters to statements. # binding, placeholders, etc. pseudonames my $ref = { PrintError = 0, RaiseError = 1, AutoCommit = 0}; my

RE: blob error need help

2003-02-17 Thread Scott Purcell
I am using ActiveState Perl Version v5.6.1 for MSWin32-x86 on my 2000 box. The dbd was downloaded from active state also. When I vi the Oracle.pm it says Version = 1.06 I am running the Oracle 8i tools on my PC. Where should I go from here? Thanks Scott -Original Message- From: David

RE: blob error need help

2003-02-17 Thread Scott Purcell
select, so it keeps installing 1.06. Any more ideas? Thanks, Scott -Original Message- From: Sumitro Chowdhury [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:32 PM To: Scott Purcell Cc: [EMAIL PROTECTED] Subject: Re: blob error need help while (my $doc = $sth

RE: blob error need help

2003-02-17 Thread Scott Purcell
:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:45 PM To: Scott Purcell; [EMAIL PROTECTED] Subject: RE: blob error need help From: Scott Purcell [EMAIL PROTECTED] I do not know how to rebuild DBD::Oracle against Oracle 8i libraries on my 2000 box. I do not think it is possible. I used

Re: Installation problems on OS X 10.2.3

2003-02-15 Thread Scott R. Godin
Curt Russell Crandall wrote: In case anyone cares. It appears the threaded version of Perl 5.8.0 on OSX is incompatible with DBI. This really bites since you need the threaded version for Apache 2.0.43 and mod_perl 1.99_07. So, on OSX, you are probably better off using FastCGI or, I

RE: 'use DBI' failure

2003-02-08 Thread Scott T. Hildreth
--compilation aborted at - line 1. What am I missing? Thanks, Alex -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 08-Feb-2003 Time: 08:47:23 --

RE: DBI and DBD not found

2003-02-05 Thread Scott T. Hildreth
-- -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 04-Feb-2003 Time: 21:27:00 --

[dbi] DBD-Oracle error message

2003-01-28 Thread Neibarger Scott H
database handles in any way? thanks, Scott H. Neibarger SRA International, Inc. IRS ESM project 512-460-8717

RE: DBD on HPUX

2002-12-12 Thread NIPP, SCOTT V (SBCSI)
This may or may not be obvious... Did you add the -lcl and -lpthreads as the first in the list of libraries? I have learned from experience they absolutely have to be the first two in the list in that order. Also, maybe obvious, you were compiling Perl with the -lcl and -lpthreads,

Missing prereq in 1.32?

2002-12-03 Thread Scott Alexander
, so it won't ever actually run the code that needs Time::HiRes. Might be worth it to just comment out the use or that whole section maybe. 5.6.1 in rh7.3 on i686 hardware. Scott

Re: DBD::CSV and multiple table queries

2002-10-26 Thread Scott McGee
and the speed of it too! Scott

DBD::CSV and multiple table queries

2002-10-25 Thread Scott McGee
() ) { print row: row\n; } ### Disconnect from the database $dbh-disconnect; exit; -- end included file query2 -- If anyone can help, I would greatly appreciate it. Scott

Re: DBD::CSV and multiple table queries

2002-10-25 Thread Scott McGee
the same script successfully by just changing the SELECT statement so I am positive that the problem is in the modules being used somewhere. Scott

Re: DBD::Oracle and FreeBSD

2002-10-24 Thread Scott T. Hildreth
-- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 23-Oct-2002 Time: 13:20:01 --

Re: Two Oracle parse calls for each execute

2002-10-16 Thread Scott
On Wed, October 16 11:51 +0100, Tim Bunce wrote: Try: my $sth = $dbh-prepare(SELECT 1 FROM dual, { ora_check_sql = 0 }); Thanks, that did the trick. Thanks also for the detailed explanation and links. I believe the parse at execute time is fundamentally an Oracle bug (and/or isn't a full

Identifying .mk files, building

2002-10-16 Thread Scott Smith
but make didn't work and there were some strange things in the makefile. Please reply personally. Scott Smith NYS Task Force on Reapportionment _ Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com

RE: fetchall_arrayref(): large amounts of data

2002-10-15 Thread Scott T. Hildreth
(several million times)? Thanks, Phil -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 14-Oct-2002 Time: 20:27:57 --

Two Oracle parse calls for each execute

2002-10-15 Thread Scott
When I use DBD::Oracle 1.12 with DBI 1.30 (I also saw this on 1.06/1.15) I see two parse_calls for every execute on all selects. Update/insert/delete just have 1 parse/execute. I have a simple test script. #!/usr/local/bin/perl -w use strict; use DBI; my $dbh = DBI-connect(dbi:Oracle:db,

RE: Database to Excel script...

2002-10-03 Thread NIPP, SCOTT V (SBCSI)
with this... I pretty much copied this code from one of the examples, but I am definitely having a problem. Thanks again. -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 11:12 PM To: NIPP, SCOTT V (SBCSI); ''Jeff Zucker' '; 'dbi-users

RE: Database to Excel script...

2002-10-02 Thread NIPP, SCOTT V (SBCSI)
OK... I am stuck once again. I am to pull the data from the database and export it directly to an Excel file. Now, I am trying to figure out the formatting... The first problem I am running into is reformatting dates from the output of MySQL to the desired Excel format. Here is a same

Database to Excel script...

2002-10-01 Thread NIPP, SCOTT V (SBCSI)
file. Does anyone out there have something like this that I could cannibalize? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: Database to Excel script...

2002-10-01 Thread NIPP, SCOTT V (SBCSI)
if possible. This is also a great learning opportunity and I think that I will have more requests in the future for generating Excel reports of this nature. -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:11 AM To: NIPP, SCOTT V (SBCSI

RE: Connecting to Oracle through Perl.

2002-09-18 Thread NIPP, SCOTT V (SBCSI)
I am pretty sure this is supposed to reside in /etc. I know that on our HP-UX boxes the tnsnames.ora is in /etc and we use Perl for some database access. -Original Message- From: Sridhar Saragu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:24 AM To: [EMAIL

Re: Threading and DBI in perl 5.8.0

2002-08-17 Thread Scott Alexander
I got this working finally. I originally grabbed the wrong patch for DBD::Oracle. The one that I ended up using was at: http:[EMAIL PROTECTED]/msg01291.html Thanks for the pointers on where to find what I needed Tim, and thanks to Gerald Richter for putting the patch together. Scott On Fri

Re: Threading and DBI in perl 5.8.0

2002-08-12 Thread Scott Alexander
- install_driver= DBI::dr=HASH(0x8b6cb08) And then nothing more. When I do a connection before the threading, There is a huge amount of output. I also don't see the connections establish with netstat -atn. Scott On Mon, 12 Aug 2002 08:06:44 +0100 Tim Bunce [EMAIL PROTECTED] wrote

ORA-01406 when selecting extended chars from CLOB column in UTF8 db

2002-07-08 Thread Scott Williams
?) Is there a better solution, or can someone point me in the correct direction for oci8.c? I've included a test program that duplicates this problem in case there's something I'm overlooking. Thanks. -- Scott # Connect, with LongTruncOK set to 0, LongReadLen to 50. my($sth) = $dbh-prepare( SELECT

RE: Multiple IN variables for Oracle Procedure

2002-06-14 Thread Scott T. Hildreth
are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 14-Jun-2002 Time: 10:14:21 --

RE: Multiple IN variables for Oracle Procedure

2002-06-14 Thread Scott T. Hildreth
, it will not be released after each use and fall out. This saves the time of reloading the procedure in memory. -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 10:01 AM To: Powell, Bruce Cc: 'Scott T. Hildreth'; [EMAIL PROTECTED] Subject: Re: Multiple

Need a little help...

2002-05-24 Thread NIPP, SCOTT V (SBCSI)
to maintain two different scripts. Any help would be appreciated. Thanks in advance, and sorry for posting off topic. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: MyODBC drivers?

2002-05-17 Thread Scott T. Hildreth
drivers too? Can someone please tell me whether the two are related? I am kinda new to the whole DBI thing. - Mark -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 17-May-2002 Time: 08:38:51 --

Re: problems building AnyData.pm on Red Hat 7.2/Perl 5.6.1

2002-05-07 Thread Scott R. Godin
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Jeff Zucker) wrote: Scott R. Godin wrote: The weird thing is, the same problem occurs even if I push some other test in front of the XML test. =:o (tried that last night) Scott, there are problems between XML::Twig's file locking

Re: problems building AnyData.pm on Red Hat 7.2/Perl 5.6.1

2002-05-06 Thread Scott R. Godin
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Jeff Zucker) wrote: Scott R. Godin wrote: my e-mail below isn't working, and Jeff's mailserver is rejecting mail from my comcast.net domain (my ISP) *sigh* Strange. I have some other email addresses but am traveling at the moment

Re: DBI newbie

2002-05-06 Thread Scott R. Godin
://www.mysql.com/Downloads/Manual/manual.pdf also used the excellent Pod::Pdf to convert the pod docs from DBD::mysql to the lovely output format of Pod::Pdf and didn't regret having THAT handy either :) print pack H*, 4a75737420416e6f74686572204d61635065726c204861636b65722c0d; -- Scott R. Godin

problems building AnyData.pm on Red Hat 7.2/Perl 5.6.1

2002-05-05 Thread Scott R. Godin
things up. Jeff I'd welcome some dialog with you on this, via the list. I LOVE AnyData (particularly useful on MacPerl :) and am frustrated that I can't also use it on the Linux box at the moment. print pack H*, 4a75737420416e6f74686572204d61635065726c204861636b65722c0d; -- Scott R. Godin

Off Topic Question...

2002-05-03 Thread NIPP, SCOTT V (SBCSI)
the mysql monitor. I know this should be a simple ALTER TABLE statement, or something similar but I can't figure out exactly how to do this. Thanks in advance, and sorry again for posting off topic. Scott Nipp Systems Analyst SBC Long Distance

RE: bug in make test for dbi 1.21

2002-05-02 Thread Scott T. Hildreth
/mach /usr/libdata/perl/5.00503 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 02-May-2002 Time: 12:30:41 --

RE: DBD on HPUX 11i

2002-04-18 Thread NIPP, SCOTT V (SBCSI)
I was able to install DBI, and DBD for MySQL under 11.0, and I will be doing this under 11i. I am quite suprised that you are having trouble. Please let us know of your results. -Original Message- From: Waldemar Zurowski [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002

RE: Re: FAQ-O-Matic for DBI FAQ(Please submit FAQs for a patch)

2002-04-09 Thread Scott T. Hildreth
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, yes. I'm confused

Question about Perl DBI DBD's

2002-04-05 Thread NEWMAN, SCOTT (SBIS)
Any DBDfor 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 ICQ#:135226947Current ICQ status:

Re: DBI vs. piping query to Mysql

2002-04-03 Thread Peter Scott
marks or shell metacharacters). -- Peter Scott Pacific Systems Design Technologies http://www.perldebugged.com

UPDATE Statement Problem...

2002-04-02 Thread NIPP, SCOTT V (SBCSI)
, the problem I have is UPDATEing existing systems. I know that I could simply DELETE and then INSERT the system again with all of the new information, but this seems a very inelegant way of handling this. Any help would be GREATLY appreciated. Scott Nipp Systems Analyst SBC Long Distance (214) 858-1289

RE: UPDATE Statement Problem...

2002-04-02 Thread NIPP, SCOTT V (SBCSI)
, 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 really appreciate all of the responses. Several

RE: UPDATE Statement Problem...

2002-04-02 Thread NIPP, SCOTT V (SBCSI)
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, INV line 81. -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL

RE: UPDATE Statement Problem...

2002-04-02 Thread NIPP, SCOTT V (SBCSI)
\'; } } 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 statement is that you need a column name before the value you are setting

RE: UPDATE Statement Problem...

2002-04-02 Thread NIPP, SCOTT V (SBCSI)
it into 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, April 02, 2002 10:46 AM

RE: UPDATE Statement Problem...

2002-04-02 Thread NIPP, SCOTT V (SBCSI)
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 02, 2002 11:15 AM To: NIPP, SCOTT V (SBCSI); '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED

RE: UPDATE Statement Problem...

2002-04-02 Thread NIPP, SCOTT V (SBCSI)
- 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. Everyone keeps telling me the same thing, and I must

RE: Oracle 8i client for Mac OS X

2002-02-26 Thread Scott T. Hildreth
there somewhere. --Chuck Tomasi --Corporate Systems Administrator --Plexus Corp. - Neenah WI --(920)751-3327 -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 26-Feb-02 Time: 10:36:36 --

Re: time difference

2002-02-21 Thread Scott Wood
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, Can i find

DBI install on Irix

2002-02-13 Thread Robert D Scott
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.

Re: Embedding perl in Oracle

2002-02-08 Thread Scott T. Hildreth
-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 08-Feb-02 Time: 09:20:40 --

Re: Embedding perl in Oracle

2002-02-08 Thread Scott T. Hildreth
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 Oracle talk (for the Perl Whirl '02 GeekCruise

Re: Embedding perl in Oracl

2002-02-08 Thread Scott T. Hildreth
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 a while to appear? Thanks

Re: DBI::Proxy configuration help

2002-01-21 Thread Scott T. Hildreth
. -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 21-Jan-02 Time: 08:16:00 --

DBIx::MSSQLReporter

2002-01-16 Thread Scott Phelps
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 Internet Services --- [ This E-mail scanned for viruses

RE: Has anyone COMPILED in the 9i libraries with DBD ???

2001-12-07 Thread Scott T. Hildreth
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 --

RE: connection frustrations

2001-12-07 Thread Scott T. Hildreth
that needs to do this... Help?!? Brian LaMere Diversa -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 07-Dec-01 Time: 12:56:15 --

RE: Oracle 9i

2001-12-04 Thread Scott T. Hildreth
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 --

<    1   2   3   4   >