Re: [External] : DBD::Oracle use_drcp and connection class

On 5/3/2022 3:44 am, Andrei A. Voropaev via dbi-users wrote: Hello, after looking at the sources of DBD::Oracle I am somewhat confused. OCI offers Session pooling and Connection pooling. "DRCP" is abbreviation for "connection pooling", but DBD::Oracle offers "session pooling", which is not exa

Re: DBD::Oracle insert speed

On 10/1/21 11:22 am, Peter Meszaros wrote: Hi, I have already asked this question at perlmonks.org but I did not get proper answer. Module DBD::Oracle

Re: DBD error

On 17/7/20 10:02 pm, Bala GANESH wrote: Hi Support, "Support" ? :) I am receiving following error while installing DBD Perl module on IBM AIX 7.1 .Please help me to solve this.. bash-3.2# perl Makefile.PL **

Re: Perl script excessively executing statement

On 18/2/20 9:51 am, JohnD Blackburn wrote: The problem is not about how well the SQL runs. It runs in less than a second, and it should only be getting executed 12 times an hour. What I'm trying to do is to figure out how the SQL statement got executed 1000 times more than it should have do

Re: Perl script excessively executing statement

will come from the execute() - bogus syntax, wrong columns, DB space errors etc. Chris *From:* Christopher Jones *Sent:* Thursday, 13 February 2020 12:56 PM *To:* dbi-users@perl.org; JohnD Blackburn *Subject:* Re: Perl script excessively executing statement *CAUTION:*This email originated from

Re: Perl script excessively executing statement

On 13/2/20 11:13 am, JohnD Blackburn wrote: Is that a behavior of DBI or DBD::Oracle? Maybe your script, if you are blindly looping when it gets an error?  Overall, I don't think there is enough information to point directly at a cause.  Presumably the DBA meant that a SQL statement (of some

Re: Hunting down (possible) memory leak in DBD::Oracle

On 16/1/18 9:17 am, Fennell, Brian wrote: $ egrep -B1 -A20 -i 'invalid write' /copy/sandbox/feeds/data/search4_1/valgrind-log.txt | head -22 ==19402== ==19402== Invalid write of size 4 ==19402==at 0xBD747E6: __intel_ssse3_rep_memcpy (in /db/app/oracle/product/12.1.0/client_1/lib/libclnts

Re: I probably mentioned this the last time I installed DBD:Oracle but I couldn't find it...

On 18/10/17 8:06 am, Bruce Johnson wrote: Oracle’s latest instant client for 64-bit linux puts the demo.mk file in /usr/share/oracle/12.2/client64/demo The DBD::Oracle installer only looks in /usr/share/oracle/12.2/client64/ to find it and thus installing from cpan fails. Dunno if this is r

Oracle TAF, FCF and FAN support

ctly, such that OCI would call the TAF handler with an OCI_FO_END event after a failover. Has anyone done something like that? Thanks in advance, Christopher Everett U.S. BANCORP made the following annotations - Ele

Re: Perl DBI libraries for connecting 12c

On 10/10/17 3:42 pm, John R Pierce wrote: On 10/9/2017 6:32 PM, Lincoln A Baxter wrote: You can solve this problem by building your own perl with gcc. It's not that hard. After build, install it in a location on path (actually you pick the install location has part of configuring the build).

Re: (Fwd) Oracle.pm

On 8/3/17 3:45 am, Bruce Johnson wrote: On Mar 6, 2017, at 5:59 PM, Gowtham mailto:shiningstargau...@gmail.com>> wrote: Hi Ron, I did that. I have two scenarios here. Both the scenarios have same ($dbh,$dbname,$user,$auth,$attr) values. Scenario 1: executed code with ORACLE_HOME set to cor

Re: DBD::SQLAnywhere SEGV when Oracle handle exists

On 7/3/17 4:38 am, Douglas Wilson wrote: After some searching, I tried using the ora_connect_with_default_signals with INT and CHLD, and tried setting BEQUEATH_DETACH=yes in a local sqlnet.ora, but still same result. Stack trace? Versions? Have you worked back from the point of the crash,

Re: (Fwd) Issues with Oracle DBD in Cygwin

On 18/09/2016 12:41 AM, Tim Bunce wrote: - Forwarded message from "Neargarder, Keith" - Date: Fri, 16 Sep 2016 22:16:11 + From: "Neargarder, Keith" To: "'t...@cpan.org'" , "'byter...@cpan.org'" , "'yan...@cpan.org'" , "'mjev...@cpan.org'" Subject: Issues with Oracle DBD in Cyg

Re: ORA-12154 - (DBD: login failed)

You possibly need to bring your 10g client up to date with patches so authentication succeeds; I've seen similar things in the past. But, in general, why use 10g client if you are connecting to 12c? You may as well use the 12c client. I forget whether 8i used service names or only the old "SID

Re: ORA-12154 - (DBD: login failed)

DBD::Oracle uses Oracle's OCI not JDBC. The official OCI Support matrix is Document #207303.1 (for those with MOS access). Chris On 9/08/2016 1:07 AM, Mike Towery wrote: *Which version of JDBC drivers support which version of Oracle database?* Please refer to the table below for the Oracle d

Re: ORA-12154 - (DBD: login failed)

You can connect to 12c using 10gR2 client. Chris On 9/08/2016 12:40 AM, Mike Towery wrote: I don't think the 10G Oracle client works with Oracle 12. Have you tried the Oracle 12 client? On Mon, Aug 8, 2016 at 9:25 AM, Howard, Chris mailto:howa...@prpa.org>> wrote: ORACLE_HOME not def

RE: Building DBD::Oracle on XP w/ VC 2005

re right about the 11g bug. Thanks for the assistance. I guess I have to find someone at Oracle to pester now! :) > > cheers > John Scoles > Gerber, Christopher J wrote: >>> Odd >>> >>> Gerber, Christopher J wrote: >>> >>>>

Building DBD::Oracle on XP w/ VC 2005

First off, I am new to the list. If there is a FAQ, feel free to point me there! This morning I built DBD-Oracle-1.21 on my XP machine using Visual Studio 2005. After building, I needed to copy the redistributable files to blib/arch/auto/DBD/Oracle, and I needed to embed the manifest into Oracle

Re: DBI ODBC select statement length

an app that makes a connection to a MSSQL server using ODBC. It works great as long as the length of our select statement is 668 characters or less. As soon as it hits 669 characters, it hangs forever doing the execute. It also fails if we use $dbh->do() instead of $dbh->prepare() an

Re: DBI ODBC select statement length

ion, but have come up empty. Has anybody seen this before? Or is this something obvious and I should be hit with a rolled up news paper for not figuring it out? Thanks. -Brian -- Christopher Sarnowski [EMAIL PROTECTED] Penn Bioinformatics Core 1316 Blockley Hall MC 6021 (215) 746-7784

Re: float bug? perl 5.8, DBI and oracle 10.2.0

signed integer, perform all arithmetic operations on integers, then divide the result with the appropriate power of ten before using it. -- Christopher Sarnowski [EMAIL PROTECTED] Penn Bioinformatics Core 1316 Blockley Hall MC 6021 (215) 746-7784

Re: Perl lib version not match executable version

GIN failed--compilation aborted at /oracle/app/oracle/eq/web/cgi/ppcd/ppcd_approval_ora.pl line 33. -- Christopher Sarnowski [EMAIL PROTECTED] Penn Bioinformatics Core 1316 Blockley Hall MC 6021 (215) 746-7784

Re: bind_param oddity?

bles in "IN" lists (because this might parse to a concatenation of 'OR' clauses, for example). -- Christopher Sarnowski [EMAIL PROTECTED] Penn Bioinformatics Core 1316 Blockley Hall MC 6021 (215) 746-7784

Re: switching perl version

On Sep 8, 2006, at 11:26 AM, Reidy, Ron wrote: Did you run 10046 traces on the code? Have you profiled the code? I switched to these same versions a couple of years ago, and have had no problems. rr -Original Message- From: Oscar Gomez [mailto:[EMAIL PROTECTED] Sent: Friday, Sept

RE: Make database handle persist in CGI/DBI application?

I have run into this myself. The scope of dbh doesn't exist in your sub function. I make the my $dbh declaration to an our $dbh. This seems to do the trick for me. Chris --- Just Your Friendly Neighborhood _SPIDEY_ > -Original Message- > Fr

[Fwd: install DBD-Oracle win32]

Actually the full error is: I am running the install DBD-Oracle command on my WIN machine with the following error: Can't remove directory C:\TEMP/DBD_Oracle-1-872-1136408691: Permission denied at C:/Perl/site/lib/PPM/Repository.pm line 247 Can't figure out where the '/' is coming from. I wa

install DBD-Oracle win32

I am running the install DBD-Oracle command on my WIN machine with the following error: Can't remove directory C:TEMP/DBD_Oracle-1-872-1136408691: Permission denied at C:/Perl/site/lib/PPM/Repository.pm line 247 I was able to install other packages. Any ideas. Thanks -- --

[Catalyst] DBIx-Class list, cdbi-talk closure (fwd)

This seems like something that the wider world should know about. For those of you that missed it its been a strange few days on the CDBI mailing list. -- "There are four boxes to be used in defense of liberty: soap, ballot, jury, and ammo. Please use in that order." -Ed Howdershelt (Author

Re: Success [ was Re: :ODBC on Mac OSX Server 10.3.7]

On Jun 6, 2005, at 6:11 PM, Jeff Urlwin wrote: I'd be gratefull (and you'd be happier the next release ;) if you diagnose why Makefile.PL detects unixODBC. I think the script is looking for $ODBCHOME/*iodbc* or $ODBCHOME/lib/*iodbc*. Is there a reason that your machine doesn't detect that?

Re: Success [ was Re: :ODBC on Mac OSX Server 10.3.7]

On Jun 6, 2005, at 6:11 PM, Jeff Urlwin wrote: I'd be gratefull (and you'd be happier the next release ;) if you diagnose why Makefile.PL detects unixODBC. I think the script is looking for $ODBCHOME/*iodbc* or $ODBCHOME/lib/*iodbc*. Is there a reason that your machine doesn't detect that?

Success [ was Re: :ODBC on Mac OSX Server 10.3.7]

On Jun 6, 2005, at 10:26 AM, Jeff Urlwin wrote: [added dbi-users in case there are more people who can help there] On Jun 4, 2005, at 12:44 PM, Jeff Urlwin wrote: I grabbed the latest DBD::ODBC and DBI from CPAN to do the installs, so both are the latest versions. Did you install with iO

DBD::ODBC Installations Problems Mac OSX Server

I'm trying to install DBD::ODBC on a Mac 10.3.7 OS X Server with the pre-installed Perl 5.8.1. I've overwritten the pre-installed iodbc driver manager with a freshly downloaded copy of iodbc 3.52.2. I've installed the FreeTDS drivers specifying --with-iodbc to make sure that it linked again

RE: LongReadLen issue

Which manual did you FR this from? --- Just Your Friendly Neighborhood _SPIDEY_ > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 26, 2005 10:48 AM > To: Tantalo, Christopher G > Cc: Chuc

RE: LongReadLen issue

. --- Just Your Friendly Neighborhood _SPIDEY_ From: Chuck Fox [mailto:[EMAIL PROTECTED] Sent: Thursday, May 26, 2005 10:12 AM To: Tantalo, Christopher G; dbi-users@perl.org Subject: Re

LongReadLen issue

I am trying to set the LongReadLen value of $dbh dynamically to select a CLOB, using: $dbh->{LongReadLen} = $dbh->selectrow_array(qq{  SELECT MAX(mc.mc_long_description)    FROM dmg.maint_codes mc  }); but get this error DBD::Oracle::db selectrow_array faile

Sudhahar wants off the list

On Thu, 19 May 2005 [EMAIL PROTECTED] wrote: How to unsubscribe this mailing list? Any Help? The headers of every message from the list contain this information: List-Post: List-Help: List-Unsubscribe: List-Subscribe:

Re: insert column if not exist

On Fri, 13 May 2005, Job Miller wrote: do you guys have users out there dropping columns that once existed? or do you just want to have applications that work regardless of whether the schema is actually the same or not? Neither of those. seems like if a column is missing, and it is worth checkin

RE: Strange problems with fetchall_arrayref DBI, DBD::mysql

ARRAY(0x8342308) ARRAY(0x834202c) ] row4 at DBHelper.pm line 61 via /usr/local/sis/lib/DBHelper.pm line 132 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x8342218)~INNER) <- DESTROY= undef at DBHelper.pm line 132 -> disconnect for DBD::mysql::db (DBI::db=HASH(0x8364dd8)~0x8354578

Strange problems with fetchall_arrayref DBI, DBD::mysql

Hello. I was having some strange problems with fetchall_arrayref in my code and thought I would share this with the list. The specific problem was when I was conducting multiple prepare/execute(s) and then using fetchall_arrayref to retrieve the data. The really strange part was it seemed as if

Re: DBIx::DBH - Perl extension for simplifying database connectio ns

On Wed, 8 Dec 2004, Michael Peppler wrote: So even if you create a generic mechanism for building DSNs there will be a lot of stuff that won't work, or will need a whole host of exceptions and special handling. I don't think allowing people to define arbitary parameters for their local strange dat

Re: database query

On Tue, 7 Dec 2004 [EMAIL PROTECTED] wrote: I am trying to query an database through a for loop (multiple query).As soon as it goes to second loop the hash (i use for storing sql results) gives a problem.it seems like hash need to be initialized or to be killed . can someone please help me with tha

RE: DBIx::DBH - Perl extension for simplifying database connectio ns

On Wed, 8 Dec 2004, Andy Hassall wrote: The fact still remains that the generic "Host" slot could be used for this purpose quite easily, as could the "DB" slot. I really really object to the DB slot being called DB. Oracle's term "tablespace" is much less overused and confusing than database. But

RE: DBIx::DBH - Perl extension for simplifying database connectio ns

On Tue, 7 Dec 2004, Chris Josephes wrote: On Tue, 7 Dec 2004, Christopher Hicks wrote: I don't care about Oracle or any of the rest. Making this work with PG and MySQL will solve 90% of the world's problems. I don't see why it couldn't be extended to include whatever parame

RE: DBIx::DBH - Perl extension for simplifying database connectio ns

On Tue, 7 Dec 2004, Orton, Yves wrote: I was given the Henrik or some other hypothetical respondant the benefit of the doubt. I figured that out by the end of reading your email. :-) :-] I thought it was clear I think that this is both doable and worth doing. Yes yes. I didn't think there was muc

RE: DBIx::DBH - Perl extension for simplifying database connectio ns

On Tue, 7 Dec 2004, Orton, Yves wrote: To: 'Henrik Tougaard' <[EMAIL PROTECTED]>, 'Martyn J. Pearce' <[EMAIL PROTECTED]>, Tim Bunce <[EMAIL PROTECTED]> Cc: Sam Vilain <[EMAIL PROTECTED]>, Ken Williams <[EMAIL PROTECTED]>, Terrence Brannon <[EMAIL PROTECTED]>, [EMAIL PROTECTED], [EMAIL P

RE: DBIx::DBH - Perl extension for simplifying database connectio ns

On Tue, 7 Dec 2004, Henrik Tougaard wrote: Maybe the number of responses on this thread come from people who have this itch to scratch. Huh? I've only been seeing what got cross-posted on this to module-authors until today, but I just subscribed to dbi-usres n I have heard Tim Bunce (DBI, DBD::Or

Re: null values

Bretz, Ellen wrote: I have a prepare statement for a select using DBI In ORACLE. One of the attributes can be null or can contain data. How do I set up my scalar for the execute? I tried $scalar = 'NULL'; if it was null but didn't work. Thanks I just ran into this problem last wee

Re: Selecting a record froma table where a column might be null

Reidy, Ron wrote: The OP's problem was specific to Oracle and as such, he should use the DB facilities that available. While on the surface, the below solution looks elegant, from an Oracle performance perspective, it is horrific. By building the SQL statement dynamically in this manner, stateme

Re: Selecting a record froma table where a column might be null

[EMAIL PROTECTED] wrote: Chuck, Try to reformat your select to something like this: $strSQL="select dns_id from dmg.do_not_solicit "; $strSQL.="where dns_prospect_id = '".$pro_prospect_id."'"; $strSQL.=" and dns_area_code = '".$dnc_areacode."'"; $strSQL.=" and dns_phone = '".$dnc_phone."'"; $

Re: Selecting a record froma table where a column might be null

Chuck Fox wrote: [EMAIL PROTECTED] wrote: On Thu, 2004-04-29 at 23:20, Chuck Fox wrote: Hmmm, So column != column when the column contains a null. How very unusual. I would have assumed that null = null, but there I go assuming things again. So why does this work ? create table foo( i in

Re: Selecting a record froma table where a column might be null

the DECODE() or NVL() functions. - Ron Reidy Senior DBA Array BioPharma, Inc. -Original Message- From: Christopher G Tantalo [mailto:[EMAIL PROTECTED] Sent: Thursday, April 29, 2004 2:53 PM To: [EMAIL PROTECTED] Subject: Selecting a record froma table where a column might

Selecting a record froma table where a column might be null

I am trying to retrieve a record from a table, and one of the parameters in the where clause happens to be null, and the select I am doing below in my script, the id does not come back, although I can use TOAD and view the record in the table. It just happens that the branch parameter is NULL

Error in make test for Oracle

I am using the latest DBD::Oracle 1.15 and the latest patch of Oracle software (9.2.0.4) on AIX 5.1. My perl is threaded and build with xlc_r . I keep getting the following error no matter how I make the module # make test PERL_DL_NONLAZY=1 /apps/globaldba/bin/perl -Iblib/arch -Iblib/lib

Re: Migrating from ? to Oracle

Hi Wiliam, You will regret it if you take that path. See if you can't (A) use one of the free development ones:- http://otn.oracle.com/software/products/oracle9i/index.html or (B) get your test machine to connect to the real Oracle (using a test schema or database maybe). Your main problems will

Re[2]: DBI bug - trailling blank LINES truncated from bind data

Hi Mac, I'm not talking about spaces - I'm talking about lines. in perl speak - specifically - put this into a bind variable then into a table:- "foo\r\n\r\n" then when you get it out again, you get this:- "foo" ... and even if I *was* talking about spaces, it's still a bug for

DBI bug - trailling blank lines truncated from bind data

Hi, Executing this:- UPDATE BLAH SET TRANSLATION=? WHERE ROWID=? used always to work for me, but after a recent upgrade, I notice that trailing blank lines are getting truncated during this update. Executing this statement instead, and the problem goes away:- UPDATE BLAH SET TRANSLATION

Re: Strange matching problem...

NIPP, SCOTT V (SBCSI) wrote: OK... From what I have read, the "prepare...execute" method is no more acceptable than the "do" method. My understanding is that if you are going to be inserting multiple instances, without looping, then you are better served with using the "prepare...execute

Re: Strange matching problem...

Scott.. this is an example(a very simple one) of a way that i use placeholders my $enroll = Y; my $cpaid = 12345; my $sth = $dbh->prepare(q{ insert into war.rfrl_assn (CPA2BIZ_ENROLLED,CPAID) values (?,?) }) or die $dbh->errstr; $sth->execute($enroll,$cpaid) or die $dbh->errstr; of course, when

Perl with Oracle 9.2

There seems to be an issue with perl when using 9.2 Oracle. We discovered this after upgrade from 8.1.7.4 to 9.2.0.4. Perl programs get Unable to create database handle ERROR OCIEnvInit I am running into a lot of cases on the net via google where people are having the same problem with 9.2 Orac

OT mysql user setup

This is an off-topic question, so please excuse this. I am using a cgi/dbi script to connect to a mysql database that I have set up on my sparc 10, using Debian at home. Now, I want to give people user accounts to the database and not the system, but when I try to connect as the user, it d

Re: DBD-DB2 for Unix

steve hatfield wrote: Can anyone tell me were to find the DBD-DB2 mod for Unix and some instructions on how to install it for Perl 5.8 Goodie! Elementary Perl stuff that even I can answer! If you have CPAN set up, perhaps try # perl -MCPAN -e "install DBD::DB2" at the command line (you may have

Re: Problem w/ $dbh->column_info() using current DBI & DBD::mysql

use DBI qw(:sql_types); Tim Bunce wrote: On Wed, Jul 16, 2003 at 01:35:23AM -0500, Christopher L. Everett wrote: I've been using an alpha version of column_info that Tim Bunce sent the Class::DBI list ages ago in connection with some code to extend Class::DBI. AFAICS,

Problem w/ $dbh->column_info() using current DBI & DBD::mysql

I've been using an alpha version of column_info that Tim Bunce sent the Class::DBI list ages ago in connection with some code to extend Class::DBI.  AFAICS, it's precisely what's in the latest version of DBD::mysql.  I got it to work without any finding bugs except it couldn't handle tablena

Re: How to call a stored procedure

Thank you, that was the problem. Don't know how I missed that. Sometimes the simplest thing will trip you up. Chris - Original Message - From: "Anil Menon" <[EMAIL PROTECTED]> To: "Christopher Mihaly" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECT

Re: undef from get array ref

Thanks all, sorry for the trouble. I think I need to read more clearly next time. Chris -- --- Just Your Friendly Neighborhood _SPIDEY_ Hardy Merrill wrote: Ronald J Kimball [EMAIL PROTECTED] wrote: On Tue, Jun 24, 2003 at 03:42:16PM -0400, Hardy Merrill wrote:

How to call a stored procedure

Okay, this is probably a basic question, but I can't find it. How do you call a stored procedure in Informix. The stored procedures I want to call don't return anything, and take zero to two parameters? I have tried to do a $db->do("execute STOREPROC($arg)") and that gives back a syntax err

undef from get array ref

In the code that follows, I want to return a 1 if there is an error, in this case, my error would be if the select does not return a sri_person_id. I have tried this numerous ways, but have yet ot have it run with without a warning message : "Use of uninitialized value in string eq at ./elead.p

RE: Using perl 5.8.0?

be installed alongside the RedHat default package. Methinks it's at least worth a shot. http://www.activestate.com/Products/Download/Register.plex?id=ActivePerl Christopher S. Cosby SciCare Software Services 770.236.1128 > -Original Message- > From: Thomas Good [mailto:[EMAIL PRO

RE: Problem accessing mysql database using perl script

.conf, run ldconfig The relocation error is Perl telling you that it can't locate the symbol 'mysql_init', meaning that it can't locate the library that exports that function. Christopher S. Cosby SciCare Software Services 770.236.1128 > -Original Message- > From:

An interesting DBD::Oracle OSAuth bug

DBD/Oracle.pm lib/perl/site/DBD/Oracle.pm 208,209c208,209 < if (DBD::Oracle::ORA_OCI() >= 8) { < $dbname = $1 if !$dbname && $user =~ s/\@(.*)//s; --- > if (DBD::Oracle::ORA_OCI() && DBD::Oracle::ORA_OCI() >= 8) { > $dbname = $1 i

RE: Problem occurred when installing DBD::Informix on SCO

A known bug in DBD::Informix. It's easy to fix. Upgrade to DBI-1.32 and your DBD-Informix should then compile. Christopher S. Cosby SciCare Software Services 770.236.1128 > -Original Message- > From: [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 19, 2002 11:31 A

RE: DBD-Informix-1.04.PC1 build errors on Solaris 8

The -KPIC wasn't the problem. Updated my DBI to DBI-1.32 and it now works. Some parse error on line 102 with the "->" operator. Christopher S. Cosby SciCare Software Services 770.236.1128 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTEC

DBD-Informix-1.04.PC1 build errors on Solaris 8

ble-nls Thread model: posix gcc version 3.2 make --version says: GNU Make 3.80 $INFORMIXDIR/bin/esql has (had to do this to get esql to compile anything): COPTS="-m64 -mptr64 -Wa,-xarch=v9 -mcpu=v9" env says: DBD_INFORMIX_DEBUG_ESQLCC=yes DBD_INFORMIX_DEBUG_ESQLLD=yes Christopher S.

Re: how to fetch the result of a select count statement?

Hardy Merrill wrote: >### Need the parenthesis arround $total_rows here since >### we're using fetchrow_array. >my ($total_rows) = $sth->fetchrow_array() > > I didn't use a while loop here since you're only expecting > 1 row to be returned - that being the count. > -- > Hardy Merrill

Re: how to fetch the result of a select count statement?

Stephane Legault wrote: > I do a lot of select in many statement and fetch the result on a array as > needed. But now one of my staement is a "select count() from ...". How can > I get the value of this statement? I do not know what db you are using, etc, but here we are using oracle on a *nix bo

Re: Inserting text into database

Andreas Schmitz wrote: > what about this one? > > my $max_alert = param("max_alert"); >$max_alert =~ s/(['"])/$1$1/g; > > my $sth = qq[insert into alerts (alrt, ncmp, suno, mess, prty, spst, > dnst, crea, cdat) values (\'$max_alert'\, \'$company'\, \'$supplier'\, > \'$message'\, \'$priority'\,

Code review

Ok, I didn't know what list to send this to, since it incorporates a lots of different things, DBI, basic perl stuff, etc., so please excuse this intrusion on your list, if it isnt supposed to be there. If you know a better list for me to submit this to, please let me know. Basically, I am aski

Re: question on null or 0

[EMAIL PROTECTED] wrote: > Why not use the following SELECT statement: > select col1 from jenny where col1<>0 and col1 is not null > > That should do the trick nicely. :) > > Gordon Dewis what if 0 *is* a valid entry for that particular row? chris -- --- Just

Re: Slightly OT - Convert column in Postgres

David Wheeler wrote: > Sorry, bad memory. It's DROP COLUMN that's been added. This is from the > HISTORY file: > > PostgreSQL now supports ALTER TABLE ... DROP COLUMN > functionality. > > But what that means is that you can rename your old column, add a new > column with the new data

Re: FAQ emails now work

on 10/05/2002 3:18 PM, Crown David T. (DNREC) at [EMAIL PROTECTED] wrote: > IMHO, I think an email to the list for every edit to the faq might be a bit > much. > I second that sentiment.

Re: Help on querying between dates

DOH! Yep, I surrender. I didn't notice that slight difference, which makes a *huge* difference. /me slinks away in a corner. Chris Jean-Claude Girard wrote: > Chris, > > your code deals with a varchar2 field (his_call_date) which you translate to > a date using the same mask used in your betwee

Re: Help on querying between dates

just a snippet of code that we would do here... select 'X' from dmg.history h where to_date(substr(h.his_call_date,1,9),'DD-MON-RR') between to_date($begin_date,'DD-MON-RR') and to_date($end_date,'DD-MON-RR'); and th

Re: Help on querying between dates

Jean-Claude Girard wrote: > If you want entries on your $toDate to be included, you should use: > > AND to_date($toDate,'DD/MM/YYY') +1 > > because to_date('01/01/02','DD/MM/YY') is the first of January 2002 at > precisely midnight and 0 seconds. The "+1" gives you until J

Re: Help on querying between dates

"Kipp, James" wrote: > > > You could also use the Oracle to_date function with a format string > > to format your dates. > > Thanks, adam > Something like this??: > > my $sth = $dbh->prepare(" > SELECT * > FROM stats >

Re: need help !!

Ajay Kumar wrote: > Hello all, > > After learning basic perl programming, i learnt > DBI, LDAP by getting some help from this > user group. It was always been helpfull for me. > So, though this is DBI group, i thought > to catch u guys again for something more. > > after getting user verifide fro

DBD:Oracle and DBI stuff

Hello everyone. I am just signed up to this list cause we have a problem with DBI and the DBD:Oracle package. At this company, the admins, DBA's and us programmers are all in separate groups, so it is hard to get things done. I finally broke them down to install perl and a bunch of modules. I

Huge problem with DBD::CSV module

I usually have great success with this module but lately, I am running into all sorts of problems. This is one is killing me. If anyone can tell me what what's wrong, I would really appreciate it. It's possible it's me now though, I have been at this one for 28 hours straight. I have simplified t

Re: [Fwd: CSV SQL Statements]

while (@row=$sth->fetchrow) { $count++; $ProductLineName = $row[0]; $PartNumber = $row[1]; } - Original Message - From: "Jeff Zucker" <[EMAIL PROTECTED]> To: "Simon Oliver" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]&

Re: [Fwd: CSV SQL Statements]

Wow...this is great newsI will try the CLIKE function tonight. - Original Message - From: "Jeff Zucker" <[EMAIL PROTECTED]> To: "Simon Oliver" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; " Christopher J. Crane"

Re: DBI installation problem with DBI 1.20 on linux

On Thu, 27 Dec 2001, Tim Bunce wrote: > On Thu, Dec 27, 2001 at 01:16:40PM -0800, Christopher Solomon wrote: > > On Thu, 27 Dec 2001, Christopher Solomon wrote: > > > > > > > > My setup: > > > > > > linux (2.4.10) > > > perl 5.6.1 (outp

Re: DBI installation problem with DBI 1.20 on linux

On Thu, 27 Dec 2001, Christopher Solomon wrote: > > My setup: > > linux (2.4.10) > perl 5.6.1 (output of perl -V attached) > > Perl works fine (insofar as I've tested it with a few scripts), and I > originally tried to install DBI from CPAN: > > perl -MCPAN -e

DBI installation problem with DBI 1.20 on linux

My setup: linux (2.4.10) perl 5.6.1 (output of perl -V attached) Perl works fine (insofar as I've tested it with a few scripts), and I originally tried to install DBI from CPAN: perl -MCPAN -e shell shell%> install DBI but it didn't take; I can't remember the errors. Then I downloaded the so

help with subclassing the DBI

I've written a couple of subclasses of DBI (after much hair-pulling frustration) -- so far, most everything works like I want it, with the exception of automatic disconnect handling... I'd like to put the disconnect method in a DESTROY, but none of my attempts are working. Here's what I've got s

Extract data from MS Excel Spreadsheets. Can it be done?

Hi, Does anyone know whether it is possible to connect to an Excel spreadsheet and extract data in a way similar one would do with an Access database? If so, how? thanks in anticipation Chris Kutler --

Complex SQL statments - Do they work?

Hello All I've tried the following SQL statement which does work via SQL Server 6.5. However, it does't seem to work when I run the same statment through DBI: select p.pieceref, d.document_id, dd.full_date, grant_description, heading, convert(varchar(255), document_type_description) as document_

Can't install DBI on WinNT - no "make" and PPM doesn't find DBI

Hi, I've fallen at the first hurdle while trying to install the DBI module. I've run Makefile.pl, however my system doesn't recognise the "make" command which the readme.txt states that I should run. I've also tried to install the package via PPM (ActivePerl v 617), however it can't find the DBI

Re: Design a place to open/modify/close a ticket

yes i believe this type of application can be done using DBI and oracle.. will this application be running on the WEB? I've done previous applications that maintains an oracle database through the web. I dont know a good site that shows a demo of this exact application but the DBI documentation

Re: Illegal instruction error with Perl 5.6

on 2/8/01 6:50 PM, Michael A. Chase at [EMAIL PROTECTED] wrote: I neglected to mention in the first post that I did rebuild dbd::msql with the most recent version. I've resorted to tearing out 5.6 for now and re-building 5.004_05, which is a shame, but I thought it easier than redoing the three