RE: arbitrary number of bindings & LIKE statement

> From: Tony Vassilev [mailto:[EMAIL PROTECTED]] > my $sth = $dbh->prepare($sql) || die "couldn't prepate"; What's the sql look like? What results do you expect/get? > $sth->bind_param(1, "%$names[0]%"); > $sth->bind_param(2, "%$names[1]%"); > $sth->execute() || die "error

RE: Help: Raise Error option, can we trust it?

> From: Shao, Chunning [mailto:[EMAIL PROTECTED]] > > But it did not mention that whether it will close the connection with > the database, close the statemnet handle, return the resource to the > operating system, etc. > > Can we trust RaiseError On option? Trust it to do what?? If you want

RE: Maintaining a Cache of Hash References

> From: Hardy Merrill [mailto:[EMAIL PROTECTED]] > > You could do something like this - instead of using hash %uref, > you could create a reference to an anonymous hash, and then use > that reference to 1) refer to hash elements, *AND* 2) to pass > to inc::db::GetUser - something like this: >

RE: Maintaining a Cache of Hash References

From: Tomasi, Chuck [mailto:[EMAIL PROTECTED]] > Yes, that's what I want... > Returning 1 says "I found data". If it is found in the cache, always return 1. > If it doesn't find it in the cache, it goes on to query the database where it returns the number of rows found. > @UserCache; # Pla

RE: Maintaining a Cache of Hash References

> From: Tomasi, Chuck [mailto:[EMAIL PROTECTED]] > > @UserCache; # Place to store data already seen This is an array, not a hash, depending on your range of id numbers, you might want: my %UserCache; # BTW, Are you using 'strict'?? > sub GetUser > { > my ($id, $user)=@_; # record n

RE: problems with prepared and bind_param

> From: Kokarski, Anton [mailto:[EMAIL PROTECTED]] > > my $statement = "select count(*) as viewable from pf_funding where ". >"target_id = ? and amt_allocated > 0.01 > and year = '" . > $self->{year} . "'"; > Is year always the same value or does it only change once a year

RE: Placeholders : in Oracle

> From: Martin Hesse [mailto:[EMAIL PROTECTED]] > > When I prepare an INSERT-Statement that contains :0 in it > (e.g. INSERT > INTO MYTABLE (FOO LONG) VALUES ('xxx:0') ) I get an error that says > Placeholder :0 invalid, Placeholder must be >= 1. I tried to prefix > every : with '\' and this

RE: Value keeps resetting to NULL

> From: Tiele Declercq [mailto:[EMAIL PROTECTED]] > > The data gets inserted by perl's DBI, so it moght have > something to do with > this.. ? Once data is in the database, the database doesn't care how it got there. Are you not committing a transaction?? Sounds like maybe its time for a dat

RE: invoking insert method inside a transaction eval

> From: Hardy Merrill [mailto:[EMAIL PROTECTED]] > $dbh->{RaiseError} = 1; You might want to turn PrintError off when RaiseError is on... > But it seems like it won't work - an eval in an eval - can > someone just confirm for me that this won't work? An eval within an eval is fine. It's the b

RE: How to capture Oracle error messages

> From: Tomasi, Chuck [mailto:[EMAIL PROTECTED]] > > I've got a web based app running on Sun Solaris 2.7, Oracle > 8.1.7.0, Perl > 5.6.0, Apache.1.3.x, and of course, DBI (1.20), DBD (1.12)... > > When Oracle runs in to an error, the error messages only go > to the Apache > error_log. Is the

FW: (Fwd) DBO-Oracle-1.12

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 19, 2001 12:10 PM > To: Wilson, Doug > Subject: RE: (Fwd) DBO-Oracle-1.12 > Importance: High > > > Doug, > > I experienced something similar about a

FW: (Fwd) DBO-Oracle-1.12

Ack, I guess I asked for it :) > -Original Message- > From: Nguyen, Thang [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 19, 2001 11:54 AM > To: Wilson, Doug > Subject: RE: (Fwd) DBO-Oracle-1.12 > Importance: High > > > Hi Doug > > Thank yo

RE: (Fwd) DBO-Oracle-1.12

> - Forwarded message from "Nguyen, Thang" > <[EMAIL PROTECTED]> - > > Delivered-To: [EMAIL PROTECTED] > From: "Nguyen, Thang" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: DBO-Oracle-1.12 > Date: Tue, 18 Dec 2001 18:43:24 -0600 > > Writing Makefile for DBD::Oracle So wh

RE: How to use DBI to do batch upload (BCP)?

> From: Zhao, David [PRI Non J&J] [mailto:[EMAIL PROTECTED]] > > Does Perl DBI have method for batch upload? > Thanks. No, that sort of thing is very database specific, and you'd have to consult the docs for whatever database you're using, then either use perl's 'system' command or not use per

RE: getting selectall_hashref() to work

> From: Janakiram Koka [mailto:[EMAIL PROTECTED]] > > I am trying to get the selectall_hashref() method to work. I > have a table > my $matrix = $dbh->selectall_hashref("SELECT * FROM youthLeader"); > print "value 2 = " . $matrix->[1]{fname} . "\n"; Check the DBI docs again, you don't re

RE: SQL::Statement cannot parse valid Postgresql statement

> From: Terrence Brannon [mailto:[EMAIL PROTECTED]] > > On Monday, December 10, 2001, at 09:16 AM, Jeff Zucker wrote: > > > Terrence Brannon wrote: > >> > >> The following SQL is not parseable by SQL::Statement: > >> > >> INSERT > >>INTO thot_log (thot_fk,thot_type_fk,thot_temporality_fk,

RE: Is this list still alive?

> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > And where might the archives be stored (so I don't jump right > in and ask > the same questions - at least not right away)? There are a couple of archives listed at dbi.symbolstone.org, but alas, they don't seem to work anymore. There's

RE: 1-10, 11-20

> From: Charles Day [mailto:[EMAIL PROTECTED]] > > while (@row = $result->fetchrow_array) > { > $count++; > if ($count >= $start and $count <= $finish) > { > print bla > > From: Bart Lateur [mailto:[EMAIL PROTECTED]] > > Don't forget to "finish", as you wil

RE: HP-UX 11.0

> From: David L. Good [mailto:[EMAIL PROTECTED]] > > Unfortunately, the problem is that there is no generally > known way to build > DBD::Oracle with gcc. There are rumors that it is possible, > but nobody has > published a procedure to get it to work. Are you talking about just on HP-UX spec

RE: /Help Wanted for Perl DBI:: Database Migration Tool

> From: Juergen Sauer [mailto:[EMAIL PROTECTED]] > This is my actual problem in Perl-Source: > Before this there were successfully selected and worked out the > tablestructure using the "COLUMNS" table. I did the same > procedure, using > an other $query String. > The error is $sth->rows cont

RE: Problem with placeholders in DBD::Pg

> From: Todd Nemanich [mailto:[EMAIL PROTECTED]] > I'm having some trouble with the DBD::Pg driver. I'm > tring to insert a > record, and it tells me that I have a invalid placeholder. I'm not > trying to use a placeholder at all, so I'm a little confused > as to where > it came from.

RE: Mail archives

> From: Bart Lateur [mailto:[EMAIL PROTECTED]] > On Thu, 15 Nov 2001 09:33:28 -0800, Tim Harsch wrote: > > >Where are the archives for this list? > > Except there's no search utility for those archives :( Which makes it hard to legitimately say "You should have sear

RE: Example of fetchall_arrayref with @bind_values

> From: David D. Anderson [mailto:[EMAIL PROTECTED]] > > I can't find any examples of fetcall_arrayref that actually use the > @bind_values argument . All I've seen are reference pages > that mention it in > the definition, but no code that actually use it after the call. > > $ary_ref = $db

RE: forking and DBI

> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > So, if I've got a massively parallel database, and I want to run > a batch of queries against it in parallel--let's say five hundred, > six at a time, what would be the best way to do that? My first thought > was a fork/connect for every q

RE: Looping through recordset twice

> From: Don Seiler [mailto:[EMAIL PROTECTED]] > > Basically, when I get to a new group number. The record set > is ordered by > group number, so all records in a group are together. As I'm looping > through records in a group, I do some evaluation and add values to > variables. When I get to

RE: Can't locate loadable object for module DBI in @INC

> From: Jake Hoban [mailto:[EMAIL PROTECTED]] > > Can't locate loadable object for module DBI in @INC (@INC contains: > /usr/local/lib/perl5/5.6.1/i686-linux /usr/local/lib/perl5/5.6.1 > /usr/local/lib/perl5/site_perl/5.6.1/i686-linux > /usr/local/lib/perl5/site_perl/5.6.1 > /usr/local/lib/p

RE: Batch Fetching -> Out of memory Error

> From: Shaozab, Sumera [mailto:[EMAIL PROTECTED]] > tried, I got "Out of memory!" error. The number of records I > am retrieving > is about 3 million records. Is this too much for fetchall_arrayref()? > Should I upgrade DBI and DBD::Oracle? Any recommendation in > speeding up my > program?

RE: my execute is not failing when placeholder values are not sup plied

> From: Wilson, Doug [mailto:[EMAIL PROTECTED]] > > It looks like Postgres has a bug with regard to placeholders ^^^ (I mean DBD::Pg) > in the execute subroutine. it only checks for matching numbers > of placeholders & arguments supplied IF you supply argu

RE: my execute is not failing when placeholder values are not supplied

> From: Terrence Brannon [mailto:[EMAIL PROTECTED]] > and have it $sth->execute(@ARGV) > > but I am able to get DBI to force an instructive error message when I > forget to supply command-line arguments. Instead I get > my $connect = 'dbi:Pg:dbname=mydb'; It looks like Postgres has a bug wit

RE: = NULL vs. IS NULL

> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] > > So if NULL is not defined, what's the difference between "is NULL" and > "=NULL". I guess my disagreement comes from not being able to ask for > undefined field by =undefined, but rather is undefined. It's It is all a matter of being theore

RE: = NULL vs. IS NULL

> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] > Within the where clause of the query that is prepared...' > > where foo = ? > > When binding an undef value when executing, this executes "where foo = > NULL". One solution, though ugly, is: where ((? is null and foo is null) or foo = ?) You

RE: Alzabo

Check the links on Alzabo's home page http://alzabo.sourceforge.net/ especially the link to the Linux Journal article. > -Original Message- > From: David Kirol [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 2:07 PM > To: [EMAIL PROTECTED] > Subject: Alzabo > > > I want to e

RE: How to send parameters from script to scritp?

> From: mas [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 11:11 AM > To: [EMAIL PROTECTED] > Subject: How to send parameters from script to scritp? > > > Hello all, I need some help sending variables from a perl script to > anohter. > I am using HTML,Perl-DBI and Myslq. It wo

RE: Elusive Syntax

> From: Scott Taylor [mailto:[EMAIL PROTECTED]] > Anyone know how I can do this? I can't seem to get past a > syntax error > near the 'while'. (it worked up to the point I tried to put > it into a > table, and the table works fine by itself) You can't have a while block inside of another

RE: mod_perl and DBI

> From: Mark Riehl [mailto:[EMAIL PROTECTED]] > Ilya/Doug - Thanks for the info. Sorry for not being too clear. Our > application will have an upload of a large (~5 MB) XML file, > it will need to > be parsed, and then stored in the database. The database will then be > manipulated by anothe

RE: mod_perl and DBI

abase connection & statement handle preparation time are more significant), it can be beneficial. > From: Wilson, Doug > > All - We're putting together a Web-based application using > > Perl CGI, Apache, > > and DBI to connect to a MySQL database (all running on one >

RE: mod_perl and DBI

> All - We're putting together a Web-based application using > Perl CGI, Apache, > and DBI to connect to a MySQL database (all running on one > machine under > Win2k). Off the command line, I can load a source file populate the > database with ~25000 records in less than 5 seconds, however, >

RE: connect_cached accessibility and persistence question

> 1 - Can different processes using the same login information > access this > cached database handle. No, it has nothing to do with connection pooling or persistance between processes. It's merely a convienience method where, say, you might have two modules which both need a database connecti

RE: Insert

> my $rows_inserted = $dbh->do(q{ > INSERT INTO CMO_MONDAY values ($record[13], > 'ttt', 'sss', 'sss', > 'sss', 'sss', 'sss', 'sss', sysdate, 'sss') > }) || die $dbh->errstr; > exit; Take a look at 'perldoc perlop' and read up on the diffe

RE: DB2 and Stored Procedures

> $ret_code = $stp_cur->execute('$pin'); Well, this is not right. $pin is not being interpolated with the single quotes, and even double quotes would be pointless here. HTH, Douglas Wilson

RE: DBI Version Problem

> From: Alex Kirk [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 6:25 PM > To: [EMAIL PROTECTED] > Subject: DBI Version Problem > > > Pardon me if this has been covered before; I can't reach the > archives, and > I'm the impateint type. ;-) > For some reason, when I ran my "pe

RE: db independent way of detecting duplicates?

> From: Hardy Merrill [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 28, 2001 2:06 PM > To: [EMAIL PROTECTED] > Subject: db independent way of detecting duplicates? > I'm wondering what other people have developed as database > independent way(s) of determining if the insert or update bei

RE: customizable RaiseError behavior

> From: Matthew Wickline [mailto:[EMAIL PROTECTED]] > > Would folks be interested in the option of specifying a > coderef for the > RaiseError option? > > you might then have: > > $dbh = DBI->connect( > $dsn, $user, $password, > { RaiseError => \&bug_out, AutoCommit => 0 }

RE: Freeze on UPDATE, but only from DBI

> my $sth = DBH()->prepare( "UPDATE ldb_ad_t SET > most_recent_print_date = > '30-SEP-01' WHERE lid = 2" ); > $sth->execute(); How big is the table? Is it just not using an index? Are you sure you're accessing the database/table you think you are and is there an index on 'lid'? Are you connect

RE: Struggling with inout on a procedure call

calls. And if you're going to die on any error anyway, > you may as well put {RaiseError=>1} in the connect and > save yourself from all those '|| die ...' clauses. And I forgot to mention, that you're not currently checking the status of the bind_param or execute statements, so RaiseError migh

RE: Struggling with inout on a procedure call

> From: Jones Robert Contr 81 CS/SCK > $dbh=DBI->connect($data, $login, $pw) || die "$dbh->errstr\n"; > "$dbh->errstr\n"; > END;") || die "$dbh->errstr\n"; Probably not related to your specific problem, but: Putting $dbh->errstr inside quotes is wrong. Double quotes will interpolate va

Linux Journal: Alzabo article

Somewhat DBI related news: There's an article on Alzabo in this months Linux Journal. Its also online, just go to http://www.linuxjournal.com and click on the picture of the magazine, then look in the toolbox section of the page.

RE: Help:how to call email function when sees error?

> From: dba dba [mailto:[EMAIL PROTECTED]] > I tried to put the line > > if ($dbh->error) {trap_die("error");} > but it will not work because the perl will exit as soon as it raise > error. catch exceptions with eval: eval { #DBI stuff connect, prepare, execute, fetch, etc. # (with RaiseError

RE: Installing the DBD::Oracle

on the DBI mailing list, and now in syndication: On Fri, Aug 31, 2001 at 03:02:47PM -0700, Wilson, Doug wrote: > > oci8.c: In function `oci_hdtype_name': > oci8.c:100: `OCI_HTYPE_SUBSCRIPTION' undeclared (first use in this function) > oci8.c:100: (Each undeclared identifier is

RE: DBI use with DBD:Oracle module

> > > my $sth= $dbh->prepare($query); > > > $sth->execute(); > > > > > > my $rawRef; > > > > > > while(($rawRef= $sth->fetchrow_arrayref())) { > > > push(@choices, $rawRef->[0]); > > > } It probably won't help, but you could replace this whole section with: my $choices = $dbh->selectcol_array

RE: :Oracle installation fails

it appears in.) > oci8.c:109: `OCI_DTYPE_LOCATOR' undeclared (first use this function) Previously on the DBI list: On Fri, Aug 31, 2001 at 03:02:47PM -0700, Wilson, Doug wrote: > > oci8.c: In function `oci_hdtype_name': > oci8.c:100: `OCI_HTYPE_SUBSCRIPTION' unde

RE: DBI 1.18 Installation help

> From: Wilson, Allen [mailto:[EMAIL PROTECTED]] > I have been attempting to install DBI 1.18 without any success. I was > able to run the Makefile.PL with any problems but when I tried to run > the make I received the following error... > > gcc -c -I/opt/gnu/include -O-DVERSION=\"1.18\" >

RE: selectall_arrayref - how set NAME_uc?

> From: Hardy Merrill [mailto:[EMAIL PROTECTED]] > > I've read the docs and tried a few things, but I can't seem > to figure out how to set the FetchHashKeyName => 'NAME_uc' > and have it work for selectall_arrayref. I've tried setting > it *in* the selectall_arrayref call: > > my $ary_ref = $

RE: fetchrow_hashref question

> From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > If it's not documented in the latest release then send me a patch :) Here ya go (plus a miscellaneous typo fix): "DBI.pm" 4434 lines, 159535 characters stan:~/src/DBI-1.20 >diff -ruN DBI.orig DBI.pm --- DBI.origTue Sep 11 15:45:19 2001 +++

RE: fetchrow_hashref question

> From: Rob Ransbottom [mailto:[EMAIL PROTECTED]] > > On Tue, 11 Sep 2001, Wilson, Doug wrote: > > This I understand. But it seems that the purpose of > fetchrow_hashref is to iterate through the results > without committing to grabbing them all. Right. You can stil

RE: fetchrow_hashref question

> From: Rob Ransbottom [mailto:[EMAIL PROTECTED]] > Could someone explain: > > Why will fetchrow_hashref change in the future > to return the same reference each time? > > I would like to understand the rationale. The idea is that it takes time to create a new hash, and it is quicker to just

RE: Perl DBI Question

> From: Paul Maine Jr. [mailto:[EMAIL PROTECTED]] > > I am writing a Perl/DBI application. I need to initially > issue a select > statement and then determine if any records are returned. > Could someone > provide me with an example of how to determine if no records > are returned > from a se

RE: Problem creating opaque types

> From: Korey Klier [mailto:[EMAIL PROTECTED]] > If I pipe the same file into dbaccess I do not have this problem. > > Did you see this in the docs for DBD::Informix or Informix? In the Informix docs themselves. Somewhere. Under preparing 'multi-statement' something or others (Its been awhile

RE: can't connect to mysql database from web

> From: Ian Feldberg [mailto:[EMAIL PROTECTED]] > It dies on the $dbh->connect(...) line. It dies before the > line returns so I can't check $DBI::err or $DBI::errstr. Can't you check the web logs? If you use RaiseError, the error should be in there. If you don't know what the error is, how do

RE: Problem creating opaque types

> From: Korey Klier [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 06, 2001 6:43 AM > To: [EMAIL PROTECTED] > Subject: Problem creating opaque types > > > I am having a problem with the following SQL > in a single statement: > > my $sql = qq|create opaque type mytype ( > internallength

RE: Documentation of the "fetch" method

> From: Rob McMillin [mailto:[EMAIL PROTECTED]] > > I was looking at the man page for DBI under DBI 1.20 and noticed that > the fetch method is not documented. Is there some reason for this? Its listed as an alias under fetchrow_arrayref. -Douglas Wilson

RE: selectall_hashref()

Forgot the '$sth->execute;'. Whoops. I'm sure you'd figure it out eventually anyway though :) > -Original Message- > From: Wilson, Doug [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 05, 2001 10:12 AM > To: 'Sterin, Ilya';

RE: selectall_hashref()

> From: raptor > I want a litle more extended sytax for selectall_hashref(), > or if u can > tell > me how the achieve this : > > my $Query = qq{SELECT field1, field2, field3}; > my $res = $dbh->selectall_hashref($Query, {field1=>1, > field2=>1}, %attr) > so as a result i get the following Ho

RE: Why and How?

> From: Nguyen, David M [mailto:[EMAIL PROTECTED]] > Why do I get error message "Internal Error" from the web > browser everytime I > input character ( ' ) or ( " ) into comment text field after > pressing SUMMIT > button to summit the form. I use Oracle database and DBI. > How do I fix > t

RE: :Oracle 1.12 needs edit for Oracle 8.0.x

> From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > On Fri, Aug 31, 2001 at 03:02:47PM -0700, Wilson, Doug wrote: > > > > oci8.c: In function `oci_hdtype_name': > > oci8.c:100: `OCI_HTYPE_SUBSCRIPTION' undeclared (first use > in this function) > &

RE: :Oracle 1.12 won't make

> Uhh, I meant 'perl Makefile.PL -8', and it passed the > make test that way. Just wondering if that was the right > thing to do... I should read the instructions more often, but then I wouldn't have so much fun figuring things out :) >From the README: The new enhanced Oracle 8 OCI is now supp

RE: :Oracle 1.12 won't make

> -Original Message- > From: Wilson, Doug [mailto:[EMAIL PROTECTED]] > > Here's the output of 'perl Makefile.PL' and 'make' > (shall I see what happens if I do 'perl Makefile.PL -no8' ??): Uhh, I meant 'perl Makefile.PL -8',

DBD::Oracle 1.12 won't make

Here's the output of 'perl Makefile.PL' and 'make' (shall I see what happens if I do 'perl Makefile.PL -no8' ??): >perl Makefile.PL Using DBI 1.20 installed in /s007/suppression/perl/perl5/lib/site_perl/5.6.1/sun 4-solaris/auto/DBI Configuring DBD::Oracle ... >>> Remember to actually *RE

RE: Oracle specifc DBI question

'col' is a SQL*Plus command to format SQL columns and headers, you will probably get a syntax error when you execute it with DBD::Oracle. I would probably simplify the SQL statement to use it with Perl/DBI. I sort of detest those long ugly SQL statments that just format data (ok for SQL*Plus, bu

RE: "Can't locate loadable object for module DBI "

> Then I installed the DBI.pm as per instructions in the > website.The following > is the result > > Can't locate loadable object for module DBI in @INC (@INC As per what instructions in what website. It still looks like an incorrect installation of DBI. Did you make/make test/make install o

RE: Table aliasing in a SELECT statement

> The SELECT statement pulls from three tables and ten fields, and is in > this format: > > SELECT a.field1, b.field2, b.field3, a.field4, a.field5, alfield6 FROM > tablea a, tableb b, tablec c WHERE a.field7 = b.field7 AND b.field8 = > c.field8 AND b.field9 = '42' and b.field10 = 'Q' > > I get

RE: Help referencing data structure retruned from fetchall_arrayref

> How can I rference an individul data item returned by > fetchall_arrayref? The same way you'd reference an element in any reference to an array of array references :) > > Something like: > > $$records$[$row][$col] ? One too many '$' : $$records[$row][$col] or see perldoc perldata. Cheers,

RE: Perl.exe generating errors when used on Win 2K

> From: Sterin, Ilya > > It's actually use DBI (uppper case) not use dbi. Perl is > case sensitive. Actually, since windows is not case-sensitive when it comes to file names, it will find the DBI.pm file ok, and 'require' it ok, but nothing will be exported from the DBI package (since there

RE: Multiple select statements

> From: Phan, Robert [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 02, 2001 1:08 PM > To: '[EMAIL PROTECTED]' > Subject: RE: Multiple select statements > I *think* the problem lies in the fact that there are two select > statements in the sql file. All the other ones that have multiple >

RE: How do I insert a value from a hash reference into a sybase DB

> my %TotBytes_C = Win32API::Resources::GetDiskFreeSpaceEx("C:\\"); > my %TotBytes_D = Win32API::Resources::GetDiskFreeSpaceEx("D:\\"); > my %TotBytes_E = Win32API::Resources::GetDiskFreeSpaceEx("E:\\"); I might be able to offer better help if I knew what these were returning. Are the keys th

RE: How can I effeciently use Prepared Statement ?

Still, it will probably go faster if you write to a text file, and then use SQL Loader. > -Original Message- > From: Chouda, Prem [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 30, 2001 2:03 PM > To: 'Rajanath Tadikonda'; [EMAIL PROTECTED] > Subject: RE: How can I effeciently use Prepare

RE: Joined Views

> -Original Message- > From: Stacy Mader [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 26, 2001 2:39 AM > To: DBI Users > Subject: Joined Views > > > A while back I asked about querying two tables linked by a > common field > (see > http://www.xray.mpe.mpg.de/mailing-lists/dbi/200

RE: Strange warning message from deep inside DBI

That is a warning (thats supposed to be) issued only when the debug level is set to 9 or higher. > -Original Message- > From: Jeff Boes [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 25, 2001 11:16 AM > To: [EMAIL PROTECTED] > Subject: Strange warning message from deep inside DBI > >

RE: Fetching

Find the code that uses DBI (what you posted does not), find the arguments used for input and output to DBI methods/functions, narrow down your problem, and then repost the (summarized perl/DBI) code here with your problem. Cheers, Douglas Wilson > -Original Message- > From: Eugene Yi (I

RE: Informix - Bind params

> 1) Is it possible to bind params to column names? ie > $sth = $dbh->prepare( "SELECT unique( ? ) FROM mspice" ); No. Though you can build a query dynamically: $sth=dbh->prepare("select unique($column_name) from mspice"); > 2) If it is possible, does it buy me the advertised > performance bene

RE: prepare_cached statement error???

Oops, > $sth->prepare($sql); s/sth/sth=$dbh/ Cheers, Douglas Wilson

RE: prepare_cached statement error???

> You are saying this worked on Unix? I see one statement that > I think should > be causing you problems with matching the numbers of > parameters expected > with the number you have provided: > > $sth->execute(@parm) or die ("$stmt Error\n"); This should be fine (except add $DBI::errs

RE: RE: statement resulting in a core dump

> > > This is not necessarily the reason for the core dump, but you > should not > > call finish() here. See perldoc DBI for what finish is > really for. > > > > Its just that i am trying to make a habit of explicitly freeing > up resources. From what i understand although the statment > w

RE: Group functions & NULL values

I like your second solution. Group functions may ignore null values, but you are still adding 1 to the result, so if max() is returning null, you are adding one to a null value and '+1' is not a group function. And you should still finish() the cursor if you are only fetching one row, although wi

RE: DBD::Informix 1.00 for Win32 platforms.

You probably ought to be using DBD::ODBC anyway for Win platforms. > -Original Message- > From: Mahdi A. Sbeih [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 17, 2001 11:45 PM > To: Michael A. Chase > Cc: Dbi-Users > Subject: RE: DBD::Informix 1.00 for Win32 platforms. > > > Hi Michae

RE: Checking for the existence of a certain row.

> -Original Message- > From: Tim Harsch [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 09, 2001 10:33 AM > To: Ronald J Kimball > Cc: M.W. Koskamp; Thomas A. Lowery; [EMAIL PROTECTED] > Subject: RE: Checking for the existence of a certain row. > > > > > > -Original Message-

RE: getting return messages from non-selects in Informix

Look at the perldoc for DBD::Informix, you have access to the sqlda structure. Or the do() and execute() methods return the number of rows affected. -Original Message- From: Curt Russell Crandall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 9:15 AM To: [EMAIL PROTECTED] Subjec

RE: (Fwd) Perl Error!

There are examples in the DBD::Oracle docs. just type "perldoc DBD::Oracle". If you're still having a problem, it would help to have example code and what exactly the error is. -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 1:30 PM To: [EMAIL PRO

RE: ACK!! Has anybody solved the SEGMENTATION FAULT problem yet????????

-Original Message- From: Tai [mailto:[EMAIL PROTECTED]] > Seems a simple database connection attempt without executing any sql scripts > ends up with a segmentation fault (core dump, if using root). > When executing a simple simple sql select to any table, same thing happens > after yo

RE: Win32::ODBC

This is the DBI mailing list. It is not the Win32::ODBC list. You can't have more than 1 active cursor with Win32::ODBC, but you can with DBI. I'm not sure if there's a limitation with ODBC. You also might want to use the basic ascii character set in the future, I deleted your first post because

RE: Generating queries within sql - no results?

I tried your query w/DBI, and it seems to work ok. Perhaps your problem is in your connect() parameters. What you have resembles the old style parameters, which I don't think supports the attributes at the end. read the perldocs for DBI and use: connect('dbi::', 'user', 'passwd', {attributes...});

RE: DBI.pm eror

DBI needs to be installed. If you think it is installed, it needs to be in the @INC path. Run a program and 'print join(":", @INC)'. Is DBI.pm in any of those directories? No? Where is it? Maybe you can 'use lib qw(/directory/where/DBI.pm/is/);' but its better if DBI is installed correctly. And

RE: select column headers

Either use fetchrow_hashref, or use $sth->{NAME} (or NAME_lc or NAME_uc). See the DBI perldocs. -Original Message- From: traja [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 3:16 PM To: [EMAIL PROTECTED] Subject: select column headers How do I get the headers (column names) w

RE: Strange CHAR/Oracle/DBI issue

>{ora_ph_type} = 96; > > > On 12-Jun-01 Rick Osterberg wrote: >> Nope -- doesn't work either. (I had neglected to mention... we had tried >> that, too.) >> >> -Rick >> >> On Tue, 12 Jun 2001, Wilson, Doug wrote: >> >>> Mayb

RE: Strange CHAR/Oracle/DBI issue

Just curious if it would work if you change '= ?' to 'like ?' and value to '12345%' ??? -Original Message- From: Rick Osterberg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 2:23 PM To: Wilson, Doug Cc: '[EMAIL PROTECTED]' Subject:

RE: Strange CHAR/Oracle/DBI issue

Maybe it is binding as a number. Try: $sth->bind_param(1, $value, { TYPE => SQL_CHAR }); before the execute instead of putting $value in the execute; -Original Message- From: Rick Osterberg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 2:04 PM To: '[EMAIL PROTECTED]' Subject: St

RE: How to execute a stored procedure by using DBI?

Did you look at 'perldoc DBD::Oracle' ? -Original Message- From: Xiaoping Gu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 6:56 AM To: [EMAIL PROTECTED] Subject: How to execute a stored procedure by using DBI? I created a procedure and it can be run on sql command line. Then,

RE: Slow execution

This is not a DBI question. There's no reason that DBI would take any more time than the same query in SQL*Plus. Try the query there, get a query execution plan, see if you have missing indexes, need to create indexes, etc. -Original Message- From: Michelle Gerfort [mailto:[EMAIL PROTECT

RE: fetchall_hashref

Yes, I just installed 1.18. -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 7:05 AM To: 'Wilson, Doug '; '[EMAIL PROTECTED] ' Subject: RE: fetchall_hashref I believe there was a patch though I would think Tim fixed that

fetchall_hashref

fetchall_hashref is in the DBI perldocs, but it doesn't seem to actually be in the code.

  1   2   >