Re: Perl DBI / SQL Question

2005-09-16 Thread Scott R. Godin
Vance M. Allen wrote: Sorry if the cross-posting wasn't appropriate, but I need help with this and am not sure if it's more appropriate to post under CGI or DBI since it involves both...I want to be sure that I can get help from the best source. My question is probably a simple answer, but I

Re: RFC : AJAX + DBI = DBIx::LiveGrid

2005-09-15 Thread Scott T. Hildreth
/jeff/programs/DBIx-LiveGrid-0.01.tar.gz I'd value all comments and criticisms, namespace suggestions, etc. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: FW: Failed DBD Oracle 1.16 make on Perl 5.8.6, DBI 1.48, Oracle 9.2.0.6, Solaris 8.

2005-08-19 Thread Scott T. Hildreth
://www.cpanforum.com/threads/698 -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DB2 connection question

2005-07-19 Thread Dan Scott
On 7/19/05, Keith Jackson [EMAIL PROTECTED] wrote: I have a project that I need to connect to a DB2 database on an AS400 from a perl application on a Linux box. I've been reading as much as I can but have a few questions for those with experience in a similar task. My options appear to be

Problems installing DBD::mysql

2005-07-14 Thread Scott T. Hildreth
connect from the command line. Any Ideas? Thanks. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: [Fwd: Problems installing DBD::mysql]

2005-07-14 Thread Scott T. Hildreth
, for portbld-freebsd5.3 (i386) ** Will the current DBD::mysql not work with mysql 4.0 ? On Thu, 2005-07-14 at 19:01 +0200, Patrick Galbraith wrote: Scott, First of all, could you please give me some information such as client lib version (where did you obtain it from?), the version

Re: dbd Oracle 10g AIX - install nightmare..... :

2005-07-11 Thread Scott T. Hildreth
object files are not allowed in 32-bit mode. make: 1254-004 The error code from the last command is 8. Stop. --- end - i did try to change the lib to lib32. no effect : Please ANY help this this nightmare. Andrew -- Scott T. Hildreth [EMAIL PROTECTED]

Re: dbi module and can't find lib question

2005-06-30 Thread Scott T. Hildreth
around this? Sorry water mark part of my signature, this site must block messages with images -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DBI module question

2005-06-29 Thread Scott T. Hildreth
Why do you keep sending the sunwatermark to the list? I don't see any text just the watermark. On Wed, 2005-06-29 at 14:42 -0700, Morrison Davis wrote: -- Scott T. Hildreth [EMAIL PROTECTED]

Re: Problem running Perl DBD-DB2-0.78 on AIX 5.3 using the DB2 UDB v8.2 (on AIX 5.3) client libraries

2005-06-22 Thread Dan Scott
Chris: This sounds very much like the problem noted under Hints at http://www-306.ibm.com/software/data/db2/perl/: Having trouble running perl with DB2 UDB Version 8 64-bit for AIX 5.2? Check out this technote.

Re: DBD::Proxy and LOBs

2005-06-15 Thread Scott T. Hildreth
On Wed, 2005-06-15 at 10:38 +0200, Wojciech Pietron wrote: Hello Scott, thank you for your help. But are there any workarounds to this problems? Is DBD::Proxy under development? It looks like its code hasn't been changed for dozens of months. And now that I am starting a new project I have

Re: DBD::Proxy and LOBs

2005-06-14 Thread Scott T. Hildreth
using DBI directly. How can I solve it? Thank you in advance, Wojciech Pietron -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DBD::Proxy Setting DBH attributes

2005-06-03 Thread Scott T. Hildreth
I don't think it is specific to Oracle, look at the Known Issues in the DBD::Proxy perldoc. On Fri, 2005-06-03 at 20:10 +0200, Wojciech Pietron wrote: * Scott T. Hildreth [EMAIL PROTECTED] [2005-06-03 15:38]: On Fri, 2005-06-03 at 14:46 +0200, Wojciech Pietron wrote: Hello, From

Re: [dbi] DSN's

2005-06-02 Thread Dan Scott
For the DSN-less connections, see http://www.connectionstrings.com -- great resource. Dan On 6/2/05, Martin J. Evans [EMAIL PROTECTED] wrote: Sharon, The string after ODBC: is usually a DSN name as in: DBI-connect(dbi:ODBC:mydsn,...) or DBI-connect(dbi:ODBC:DSN=mydsn) where mydsn

Re: SQL Problems : No suitable driver

2005-05-26 Thread Dan Scott
This is not the mailing list you're looking for. This mailing list is specifically about using the Perl DBI with the associated database drivers (for example, the DBD::DB2 driver, as documented at http://ibm.com/db2/perl/). If you want help calling Java applications from a shell script, you would

Re: DBD::Oracle implementation

2005-05-04 Thread Scott T. Hildreth
? You are correct. Turn your attention to the RowCacheSize attribute. Tim. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DBD::Oracle implementation

2005-05-03 Thread Scott T. Hildreth
Not yet. On Tue, 2005-05-03 at 15:10 -0400, Steve Sapovits wrote: A question from a DBA here: Does DBD::Oracle use Oracle's array interface to interface to Oracle? -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DBD::Oracle implementation

2005-05-03 Thread Scott T. Hildreth
I'm sure it will be someday, I know that execute_array is in DBI. I believe DBD::Pg uses array inserts. As far as I know, DBD::Oracle does not use the Array Processing yet. On Tue, 2005-05-03 at 15:35 -0400, Steve Sapovits wrote: Scott T. Hildreth wrote: Not yet. Thanks for the quick

Describe table

2005-04-18 Thread Mike Scott
anyone help me out? I just want the info describing the table that I can see in sqlplus. Mike Scott QA Software Developer BBC News Interactive White City London UK +44 20875 27288 http://www.bbc.co.uk/ This e-mail (and any attachments) is confidential and may contain personal views which

Re: Anyone getting blank messages from the list?

2005-03-23 Thread Scott T. Hildreth
Yup. On Wed, 2005-03-23 at 11:10 -0800, Jeff Zucker wrote: For the past couple of days, I have been getting blank messages from Kim Nielsen [EMAIL PROTECTED] every time I post to dbi-users. Anyone else? -- Scott T. Hildreth [EMAIL PROTECTED]

Re: Re[2]: Oracle client and DBD::Oracle

2005-03-21 Thread Scott T. Hildreth
or OCI or some other package like that. Which package varies with Oracle version and platform. Suse Linux 9 Pro and Oracle 9ir2 Any tip? -- Scott T. Hildreth [EMAIL PROTECTED]

NULL field matching problem...

2005-03-16 Thread NIPP, SCOTT V \(SBCSI\)
) { $update = 1; } else { $update = 0; # print Comparing $file_val to $db_val. \n; # Testing line last; } Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: NULL field matching problem...

2005-03-16 Thread NIPP, SCOTT V \(SBCSI\)
; # Testing line $sth-bind_param(1, undef); $sth-bind_param($_+2, $data[$_]) foreach 0..20; $sth-execute() or print Data insert failed.; Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Ronald J Kimball [mailto

RE: NULL field matching problem...

2005-03-16 Thread NIPP, SCOTT V \(SBCSI\)
That sounds good, but I am a little confused on exactly how to achieve that. I'll start poking around, but... Thanks for the pointer at least. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: CAMPBELL, BRIAN

RE: NULLs in Text::CSV_XS and DBD::CSV

2005-03-16 Thread NIPP, SCOTT V \(SBCSI\)
I was typing this up and noticed I had typo'd an extra '$' on the comparison line. Maybe now all will be good. Thanks again. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Jeff Zucker [mailto:[EMAIL PROTECTED

Re: DBI.ppd for 5.8.6

2005-03-15 Thread Dan Scott
There is an archive of older ActiveState Perl releases at http://downloads.activestate.com/ActivePerl that includes 5.8.4. Dan On Mon, 14 Mar 2005 09:01:24 -0500, Marina Greenstein [EMAIL PROTECTED] wrote: Jeff, Any chance you will update repository with 5.8.6 binaries ? Or please let

Insert help...

2005-03-15 Thread NIPP, SCOTT V \(SBCSI\)
).))}, # This is where I run into issues. undef,@old,NOW());# I am not sure how to structure this syntax and not having luck finding the answer. } } } Thanks in advance for any help. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http

RE: Insert help...

2005-03-15 Thread NIPP, SCOTT V \(SBCSI\)
snipped ... Please help as I am almost there. Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 1:34 PM To: NIPP, SCOTT V

RE: Large SQL statements...

2005-03-14 Thread NIPP, SCOTT V \(SBCSI\)
create a second table to hold the changes in providing us with a tracking mechanism for changes. I am working on this now, but wanted to throw this out there seeing as how I am probably going to get stuck shortly. Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED

Re: retrieve many values

2005-02-22 Thread Scott T. Hildreth
2.9004 any more ideas ? -- Scott T. Hildreth [EMAIL PROTECTED]

Re: retrieve many values

2005-02-22 Thread Scott T. Hildreth
}); or my $sth = $dbh-prepare(QUERY); $sth-{mysql_use_result} = 1; On Tue, 2005-02-22 at 08:36 -0600, Scott T. Hildreth wrote: Mysql will return all rows by default, you need to turn that off. I can't remember what the attribute is, read the DBD::mysql perldoc. On Tue, 2005-02

Re: Using Oracle's Perl tree instead of OS supplied distribution...

2005-02-21 Thread Scott T. Hildreth
with Oracle's distribution of Perl as verses the version that ships with Red Hat Enterprise Linux? Thanks in advance for insights on this. ...BC -- Scott T. Hildreth [EMAIL PROTECTED]

Re: [EMAIL PROTECTED]: elegent way to handle pluggable backend servers?]

2005-02-18 Thread Scott Smith
of fields passed-in and handle boolean values specially, for instance, in a generic way. We use these and actual queries to the data dictionary of the given database to make the SQL writer smart. Scott Smith Informatics Genome Sequencing Center Washington University School of Medicine David Dooling wrote

DBD:ORACLE ... having trouble, need help fast!

2004-12-12 Thread Bryan Scott
Been working on this for a few days haven't had any luck: I have read all of the help files searched the internet I still cannot find out what my problem is. I am running winxp pro (sp2), vis studio.net, oracle 9i (9.2.0.1) ActivePerl 5.8., jdk1.5.0 I also ran vcvars32.bat in vis

Re: DBIx::DBH - Perl extension for simplifying database connections

2004-12-07 Thread Dan Scott
On Thu, 02 Dec 2004 08:53:38 +0100, Cosimo Streppone [EMAIL PROTECTED] wrote: Tim Bunce wrote: I know what it does, I'm trying to find real examples that demonstrate why people think it's needed. Nick has provided a good one. Any others? Something like DBIx::DBH is in use in our

Re: ANNOUNCE: DBI 1.46

2004-11-16 Thread Scott T. Hildreth
With that announcement, lets start a fund drive to DBI Development. I just contributed at, http://dbi.perl.org/donate/ ...so if you have the means to do so, please contribute. Remember it is tax deductible, if you live in the US. STH On Tue, 2004-11-16 at

Re: DBD::DB2, Apache and mod_perl

2004-11-08 Thread Dan Scott
On Mon, 8 Nov 2004 15:17:34 +0100, Miroslav Lau [EMAIL PROTECTED] wrote: Hi all! I'm using DBD::DB2 to access remote DB2 database on an AS400 machine. I've managed it to work from command line. But when trying to connect to remote database from a mod_perl application the $DBI::errstr is

Re: Named bind params with DBD::Proxy

2004-10-22 Thread Scott T. Hildreth
I was going bring this up myself. I had this problem the other day. To get it working I changed the param names to :p1, :p2, ...etc and used $sth-bind_param(1, 'foo'). For the return param I had to use the a :p? as well, i.e. my $sth = $dbh-prepare(q{ BEGIN

Re: Stored Procedures Parameters

2004-10-21 Thread Scott T. Hildreth
perldoc DBD::Oracle will show you how to do this. On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote: Hi, I'm calling a stored procedure called Pg_Move_Files.Pr_Return_Cycle_File. After the stored procedure executes, it returns an out parameter called out_v_RECV_FILE_NM. I have a perl

Re: Stored Procedures Parameters

2004-10-21 Thread Scott T. Hildreth
Sorry, I am assuming you are using Oracle, are you? Look for bind_paraminout(). On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote: perldoc DBD::Oracle will show you how to do this. On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote: Hi, I'm calling a stored procedure called

Re: Stored Procedures Parameters

2004-10-21 Thread Scott T. Hildreth
...bind_param_inout(), typo. On Thu, 2004-10-21 at 08:36, Scott T. Hildreth wrote: Sorry, I am assuming you are using Oracle, are you? Look for bind_paraminout(). On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote: perldoc DBD::Oracle will show you how to do this. On Wed, 2004

RE: DBI version for Perl 5.005_03

2004-10-14 Thread Scott T. Hildreth
On Thu, 2004-10-14 at 10:16, Das, Manojit wrote: Thanks Scott, I was able to install DBI-1.37 DBD::Oracle-1.14 with Perl-5005.03 Is it possible to upgrade the perl? But one thing I am not sure if the installation is 100% perfect. why do you think that? Regards

Re: alternative to DBD::Oracle that does not use OCI?

2004-10-13 Thread Scott T. Hildreth
You could install DBD::Oracle DBI on the server which has the Oracle install and use DBD::Proxy to connect. Or look into using DBD::JDBC. On Tue, 2004-10-12 at 16:36, Joseph Bruni wrote: Hello all, Although DBI is great, is there some other sort of DBD module that can connect to an

Re: :ODBC with DB2

2004-10-08 Thread Dan Scott
Ben: DB2 automatically takes the user ID you logged in with and uses that as your default schema. You can issue the SET SCHEMA statement to change your default schema if you want it to be different from your DSN user ID. For example SET SCHEMA rick would automatically prepend 'rick.' to all of

Re: DBD::DB2 and Apache::DBI problem

2004-09-24 Thread Dan Scott
ricardo Guerra Flores wrote: Hi all... i'm having some problems trying to run a script that uses DBD::DB2 inside mod_perl and the Apache::DBI module, the program runs right when i execute it as a stand alone perl program. I've already set the ENV for db2home, db2instance, etc. in startup.pl This

Re: [VPM] [RFC] naming a module for SQL routines

2004-09-18 Thread Peter Scott
that don't want to talk SQL. Hence, calling it a SyntaxModel is somewhat archaic. Given this, perhaps DBIx::Mechanize would be more appropriate. YMMV. -- Peter Scott Pacific Systems Design Technologies http://www.perldebugged.com/ *** New! *** http://www.perlmedic.com/

MySQL INSERT problem...

2004-09-16 Thread NIPP, SCOTT V \(SBCSI\)
(),NOW())}, undef, $key1, $uid, $gid, $gcos, $home, $shell) or print Error updating database: , $dbh-errstr, \n; ---code snipped below--- This first INSERT is the problem one. The second INSERT works fine. Thanks in advance for any suggestions. Scott Nipp

MySQL data matching error...

2004-09-16 Thread NIPP, SCOTT V \(SBCSI\)
, but the database is entering the value into the table as a '0' as mentioned above. Does this problem sound familiar to anyone? Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: MySQL data matching error...

2004-09-16 Thread NIPP, SCOTT V \(SBCSI\)
for any feedback. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: S P [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 2:27 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: Re: MySQL data matching

RE: SQL question: Find next unused number...

2004-09-15 Thread NIPP, SCOTT V \(SBCSI\)
this out. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Steve Baldwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 4:02 PM To: 'Reidy, Ron'; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: SQL

SQL question: Find next unused number...

2004-09-14 Thread NIPP, SCOTT V \(SBCSI\)
I have a table that has a list of users with numeric user IDs. The user IDs are not sequential. There are large gaps in the list of numeric IDs. I want to pick the next unused number beginning at 3000. How do I do this? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E

RE: Large SQL statements...

2004-09-08 Thread NIPP, SCOTT V \(SBCSI\)
Just a curiosity at this point... Is there a way to do this using the quick quotes method? Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Wieland Pusch [mailto:[EMAIL PROTECTED] Sent: Wednesday, September

Database update module???

2004-09-08 Thread NIPP, SCOTT V \(SBCSI\)
to compare the incoming data to the existing data and then update accordingly. This seems like it would be an extremely common thing to do though. I was wondering if someone might know of a module to do this? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web

RE: Parsing question...

2004-09-07 Thread NIPP, SCOTT V \(SBCSI\)
Actually, yes. There is a VERY good reason that I am not using this module... I had no idea that it existed. Now that I know, I'll take a peak and see if this will indeed do the trick for me. Thanks a lot for pointing me in the direction of the easy solution. Scott Nipp Phone

RE: Parsing question...

2004-09-07 Thread NIPP, SCOTT V \(SBCSI\)
The suggestion of using Text::CSV_XS was the winner. This is a very simple module to use. Thanks for the feedback though. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Ravi Kongara [mailto:[EMAIL

Re: DBD::SQLite: Migration to SQLite 3.0

2004-09-01 Thread Scott T. Hildreth
I would, especially if you are starting from scratch. DBD::SQLite-1.04 is using SQLite 3.0, which has more features as stated below. On Tue, 2004-08-31 at 23:49, Owen wrote: On Sat, 17 Jul 2004 10:51:55 +0100, Matt Sergeant wrote: Anyone who has read my journal will know that I now have

Re: [DBI] DBD::SQLite

2004-08-23 Thread Scott T. Hildreth
(value)); if (!SvOK(value)) { sqlite_trace(5, binding null); On Mon, 2004-08-23 at 05:03, Dave Cash wrote: On Fri, 20 Aug 2004, Scott T. Hildreth wrote: Anybody else having problems compiling DBD-SQLite-1.03? Yes, I'm having this problem too. I'm using Perl 5.8.0

DBD::SQLite

2004-08-21 Thread Scott T. Hildreth
Anybody else having problems compiling DBD-SQLite-1.03? On Fri, 2004-08-20 at 11:22, Scott T. Hildreth wrote: Hello Matt, I've been trying to compile DBD-SQLite-1.03 and I get the error, dbdimp.c:24:4: warning: #warning No vararg macros - using trace without line numbers dbdimp.c

Re: DBD::SQLite

2004-08-21 Thread Scott T. Hildreth
Just a follow up. I think I have identified the problems and one solution and sent them to Matt. Although, I see my first email hasn't hit the list yet, usually takes 6 hours or so..not sure why..So this one will follow about 3 hours behind. =8^) On Fri, 2004-08-20 at 13:37, Scott T. Hildreth

DBD driver compile on HP...

2004-08-20 Thread NIPP, SCOTT V \(SBCSI\)
/site_perl/5.6.1/PA-RISC1.1-thread-multi /opt/perl/lib/site_perl/5.6.1 /opt/perl/lib/site_perl . Thanks for the help. Sorry for asking the same question yet again. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: DBD driver compile on HP...

2004-08-20 Thread NIPP, SCOTT V \(SBCSI\)
No parameters, no modifications as of yet. Just a lot of reading and researching. Basically... perl Makefile.PL make ERRORS... Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com http://ldsa.sbcld.sbc.com/ -Original

RE: web development tool

2004-08-10 Thread Scott T. Hildreth
http://www.perlmonks.org would be another good place to post this question. On Mon, 2004-08-09 at 11:42, Scott T. Hildreth wrote: I would check out HTML::Mason or Maypole which can use Template::Toolkit or Html::Mason. Maypole is like Java Struts a MVC(?). Anyway it seems very easy to setup

RE: web development tool

2004-08-10 Thread Scott T. Hildreth
I would check out HTML::Mason or Maypole which can use Template::Toolkit or Html::Mason. Maypole is like Java Struts a MVC(?). Anyway it seems very easy to setup giving web interfaces to db tables. I have not used it, worth checking out though. There are articles on perl.com. On Mon,

Re: ORA-12154

2004-08-03 Thread Scott T. Hildreth
This should be on the dbi-users list. Are you sure all of the environment variables are set? Can you show the code? The ORA-12154 is TNS error, 12154, 0, TNS:could not resolve service name // *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. //

Re: ORA-12154

2004-08-03 Thread Scott T. Hildreth
I would try setting the $ENV{ORACLE_HOME}, $ENV{LD_LIBRARY_PATH}, ..etc in the top of the script, i.e. BEGIN { $ENV{ORACLE_HOME} = q[/some/path/to/oracle]; $ENV{LD_LIBRARY_PATH} = qq[$ENV{ORACLE_HOME}/lib]; } On Tue, 2004-08-03 at 16:04, Robert wrote: I am also attaching the

DBD::Proxy Setting DBH attributes.

2004-07-22 Thread Scott T. Hildreth
I am asking a question, that I'm pretty sure I know the answer to, but just in case I am missing something, The following example code works, use DBI; my $dbh = DBI-connect('dbi:Oracle:sid', 'user', 'password', {}); $dbh-{FetchHashKeyName} = 'NAME_lc'; my $res = $dbh-selectall_hashref(q{

[Fwd: DBD::Proxy Setting DBH attributes.]

2004-07-22 Thread Scott T. Hildreth
Tried sending this yesterday, and it never showed up on the list. Trying again... -Forwarded Message- From: Scott T. Hildreth [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: DBD::Proxy Setting DBH attributes. Date: Tue, 20 Jul 2004 16:39:21 -0500 I am asking

Re: Possible DBI logos

2004-07-10 Thread Scott T. Hildreth
dibsea.jpg is cool. On Sat, 2004-07-10 at 11:55, Dean Arnold wrote: Took the liberty of rendering a few of my own (now that cooltext is back up). http://www.presicient.com/dbilogos Thats all the time I have to play with this, but if anyone feels a need to burn up their day, cooltext

Re: DBD::Oracle missing symbol OCILobWriteAppend in file oci.def

2004-07-09 Thread Scott T. Hildreth
I should say, that I am running oracle under linux emulation on FreeBSD. I have 5.6.1 Linux Perl running. Like I said before the DBD::Oracle 1.12 compiles fine. Here are where the header files are, /usr/compat/linux/usr/include/bits/posix1_lim.h /usr/compat/linux/usr/include/bits/posix2_lim.h

Re: DBD::Oracle missing symbol OCILobWriteAppend in file oci.def

2004-07-08 Thread Scott T. Hildreth
I captured the output from 'perl Makefile.PL' for 1.12 1.15. I did a diff of the two, I cannot see much difference (unless I'm just not s seeing it). On Thu, 2004-07-08 at 14:36, Scott T. Hildreth wrote: I can't even get 1.15 to compile w/ 8.0.5, cc -c -I/usr/oracle/rdbms/demo -I/usr

Re: DBD::Oracle missing symbol OCILobWriteAppend in file oci.def

2004-07-08 Thread Scott T. Hildreth
I can't even get 1.15 to compile w/ 8.0.5, cc -c -I/usr/oracle/rdbms/demo -I/usr/oracle/rdbms/public -I/usr/oracle/plsql/public -I/usr/oracle/network/public -I/usr/oracle/rdbms/demo -I/usr/oracle/precomp/public -I/usr/oracle/rdbms/demo -I/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI

Re: Changing driver from OCI8 to OCI7 driver for DBI

2004-06-29 Thread Scott T. Hildreth
Was your DBD::Oracle compiled against 8i libraries? If so you can connect to the 9i by using sqlnet, i.e. my $dbh = DBI-connect('dbi:Oracle:${9i_Sid}'. $user, $passwd, {}); Or recompile DBD::Oracle using the 9i libraries. On Tue, 2004-06-29 at 03:02, Nayana hanji wrote: Hi, When in

Re: do() with bind_values

2004-05-12 Thread Scott T. Hildreth
no, the @bind_values is a list to bound for that statement. It could 1 or many (i.e. if you have where id = ? and date = ? ). If you have a list of values that need to be inserted into different rows, then iterate through the array and execute the 'do'. A word of caution, if the list is going

Re: do() with bind_values

2004-05-12 Thread Scott T. Hildreth
On Wed, 2004-05-12 at 10:48, JupiterHost.Net wrote: Thanks for all the replies! Its much clearer now :) Just to clear up the qw() issue, I included quotes so that the data would be quote()ed for the query, not sure if that was necessary or not since do() didn't do quote()... IE I was

Re: using binary data in variable in an INSERT/UPDATE statement

2004-05-11 Thread Scott T. Hildreth
..forgot to cc list. On Mon, 2004-05-10 at 14:33, Scott T. Hildreth wrote: I guess it would depend on which database you are using. I would try it with a bind column and let the DBD driver handle the quoting if need be, $dbh-do(q{ update mystuff set binaryfld=? Where id=1

Re: using binary data in variable in an INSERT/UPDATE statement

2004-05-11 Thread Scott T. Hildreth
. On Mon, 2004-05-10 at 14:33, Scott T. Hildreth wrote: I guess it would depend on which database you are using. I would try it with a bind column and let the DBD driver handle the quoting if need be, $dbh-do(q{ update mystuff set binaryfld=? Where id=1 }, undef, $binary_data

RE: dbh connection information

2004-04-30 Thread Scott T. Hildreth
How about using a convenience method, $nm = $dbh-selectrow_array(q[select global_name from global_name]); print \nThe instance is $nm\n if $nm; On Fri, 2004-04-30 at 05:47, Srikanth Madani wrote: TMTOWTDI and all that :-) - but please do correct me if this code is inappropriate in some way:

RE: performance problem with dbd oracle

2004-04-16 Thread Scott T. Hildreth
On Fri, 2004-04-16 at 09:24, Reidy, Ron wrote: Tim, What performance problems are you having exactly? Did you run a 10046 trace? Are you passing the {ora_check_sql = 0} in your prepare() call? Also, I would suggest you look into SQL*Loader. Nothing you ever write in Perl will give

Using Perl to Source variables

2004-04-08 Thread Scott Dial
state. Can anyone give me a hint? Thanks, Scott

Basic symlink question...

2004-03-09 Thread NIPP, SCOTT V (SBCSI)
appreciated. symlink($loc[($push -1)]/bin,/tlgld/bin) I am wondering if there is a problem with the variable expansion or something. Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: Basic symlink question...

2004-03-09 Thread NIPP, SCOTT V (SBCSI)
Thanks for the PerlMonks suggestion. I found a solution out there. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Ronald Kimball [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 12:51 PM To: NIPP

Re: DBI::Shell still failing to install under Fedora Core 1

2004-02-21 Thread Scott R. Godin
Scott R. Godin wrote: t/coredubious Test returned status 0 (wstat 139, 0x8b) Scalar found where operator expected at (eval 153) line 1, near 'int' $__val (Missing operator before $__val?) after all the subtests completed successfully t/funcskipped

Re: DBI::Shell still failing to install under Fedora Core 1

2004-02-21 Thread Scott R. Godin
Jeff Zucker wrote: t/coredubious Not one response since Feb 9th? what's going on here? You mean the Feb. 9th that happend less than two weeks ago? Did you submit a patch? If not, what is going on is probably that the module's author a) has a life and/or b) is busy. :-) *chuckle*

RE: Problems Installing DBD::Oracle 1.15 on FreeBSD 5.1 with Ora

2004-02-17 Thread Scott T. Hildreth
. [EMAIL PROTECTED] http://www.1000trails.com -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 17-Feb-2004 Time: 17:39:14 --

RE: (Fwd) Oracle DBD question...

2004-02-15 Thread Scott T. Hildreth
. http://taxes.yahoo.com/filing.html - End forwarded message - -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 15-Feb-2004 Time: 07:51:07 --

DBI::Shell still failing to install under Fedora Core 1

2004-02-09 Thread Scott R. Godin
cpan test DBI::Shell Running test for module DBI::Shell Running make for T/TL/TLOWERY/DBI-Shell-11.93.tar.gz Fetching with LWP: http://cpan.develooper.com/authors/id/T/TL/TLOWERY/DBI-Shell-11.93.tar.gz Fetching with LWP: http://cpan.develooper.com/authors/id/T/TL/TLOWERY/CHECKSUMS Checksum for

Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-30 Thread Scott T. Hildreth
build log is attached, looks like libclntsh is linked in. On Fri, 2004-01-30 at 04:22, Tim Bunce wrote: On Thu, Jan 29, 2004 at 02:07:49PM -0600, Scott T. Hildreth wrote: I'm trying to build on OSF, Perl 5.6.1, and Oracle 8.1.7. 1.14 builds(make test), but 1.15 prints this error on first

Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-29 Thread Scott T. Hildreth
I'm trying to build on OSF, Perl 5.6.1, and Oracle 8.1.7. 1.14 builds(make test), but 1.15 prints this error on first test, t/base...Failed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:

Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-29 Thread Scott T. Hildreth
| 0008 searching oracle lib/libocijdbc8_g.so ... OCILobWriteAppend| 0004396962439648 | T | 0008 My LD_LIBRARY_PATH is set(same setting as when I compiled 1.14). Here is output of 'perl Makefile.PL -s OCILob On Thu, 2004-01-29 at 14:07, Scott T. Hildreth wrote

Strange matching problem...

2004-01-22 Thread NIPP, SCOTT V (SBCSI)
on improvements or better methods for doing some of this stuff are most welcome too. Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: Strange matching problem...

2004-01-22 Thread NIPP, SCOTT V (SBCSI)
fix this, hopefully I can come back with some more useful information. Thanks again. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 12:22 PM

RE: Strange matching problem...

2004-01-22 Thread NIPP, SCOTT V (SBCSI)
; Thanks again for the help. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 12:46 PM To: [EMAIL PROTECTED]; NIPP, SCOTT V (SBCSI) Subject: RE

RE: Strange matching problem...

2004-01-22 Thread NIPP, SCOTT V (SBCSI)
Thanks to everyone for the feedback. I have modified the script to fix the NOW function. Thanks again. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: Thursday

RE: Strange matching problem...

2004-01-22 Thread NIPP, SCOTT V (SBCSI)
through data, then using the do method is no worse. I am going to create a copy using the prepare...execute method exclusively, and time that against the existing version. This will give me very real world comparison. Thanks for the feedback again. Scott Nipp Phone: (214) 858-1289 E

Need some MySQL query help...

2004-01-20 Thread NIPP, SCOTT V (SBCSI)
; } else { print Error. \n; } } } } } Thanks in advance for any help. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

RE: Need some MySQL query help...

2004-01-20 Thread NIPP, SCOTT V (SBCSI)
*** syntax error at ./passwd2db.pl line 34, near Adding $key1 to password database . \n; Execution of ./passwd2db.pl aborted due to compilation errors. In the mean time, I'll start reading up on using placeholders too. Thanks again. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web

RE: Need some MySQL query help...

2004-01-20 Thread NIPP, SCOTT V (SBCSI)
for when this change was archived off. I know that this is actually redundant, however, I think it will make some of the other tools easier to write later. Thanks again for the help. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original

DBD Oracle compile error...

2003-12-05 Thread NIPP, SCOTT V (SBCSI)
: Can't find library or mismatched ABI for -lclntsh I am building this again HP-UX 11i, running Perl 5.6.1 in 64 bit mode with DBI 1.37. Any help would be most appreciated. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com

Re: DBD module

2003-11-15 Thread Scott R. Godin
Michael A Chase wrote: On Thu, 6 Nov 2003 14:07:46 -0500 [EMAIL PROTECTED] wrote: How do I determine what version of the DBD module is installed? There are several DBD::xyz modules. DBI has a method for finding them: perl -MDBI -e print join qq(\n), DBI-available_drivers You can

Re: DBD module

2003-11-15 Thread Scott R. Godin
Tim Bunce wrote: On Thu, Nov 06, 2003 at 02:07:46PM -0500, [EMAIL PROTECTED] wrote: How do I determine what version of the DBD module is installed? With DBI 1.38 you can now do perl -MDBI -e 'DBI-installed_versions' and it'll tell you. Tim. Sweet! Thanks a lot, Tim, this is nice.

<    1   2   3   4   >