Array for "In"?

2003-09-23 Thread Dave Anderson
I am having a heck of a time doing a "SELECT FROM TAB WHERE COL1='val' and COL2 IN ('1','2')" where the '1','2' is coming from an array that is returned from a multi-select box built with CGI $q->scrolling_list with "multiple" set to "true". I see that bind_param_array can take an array as a bi

ORACLE::OCI still in Beta?

2003-09-23 Thread Scott Dial
Greetings! In trying to get started with PERL and Oracle, I thought it encouraging to read that a beta version of Oracle::OCI was made public back in 2000/2001. However, I haven't heard or seen anything of it as of late. Does anyone know what the plans are for the raw OCI driver? Will it just be

re: analysis of stability and reliability of Perl::DBI and DBD::Oracle

2003-09-23 Thread Will_Brennecke
Has anyone done a thorough analysis of the Perl::DBI and DBD::Oracle? Are there any caveats that I should be aware of with Perl 5.8 on unix? Thanks, Will

Re: Request for DBI related module ratings

2003-09-23 Thread mark
In gmane.comp.lang.perl.modules.dbi.general, you wrote: > As you may know, the excellent search.cpan.org site now has a ratings > system. > > You can view the ratings for a specific distribution and add your > own in the form of 1-thru-5 ratings on Documentation, Interface, > Ease of Use, plus an

Re: SQL statement to find and delete double entries

2003-09-23 Thread Ian Harisay
How about if you put a proper constraint on the table. Then it really doesn't matter how elegant you are in cleaning up your data, since the it should only happen once. -Ian Christian Merz wrote: Hello, i am definitely sure that the statement below would mess up your data. The rowid is an in

Re: SQL statement to find and delete double entries

2003-09-23 Thread Jeffrey . Seger
Christian: I'm sure you are right. There is no proper join criteria in the statement I found on google. Anyway, this has wandered far enough off topic for something that is not an urgent need for me right now. Thanks. Jeff Seger Fairchild Semiconductor [EMAIL P

Re: SQL statement to find and delete double entries

2003-09-23 Thread Christian Merz
Hello, i am definitely sure that the statement below would mess up your data. The rowid is an internal (physical) access path to your data and it is fatal to use it as a logical sorting criteria. To delete ALL duplicates: see my suggestion below. To leave the first element in your table, you will

LOBs, PL/SQL and DBD::Oracle (summary)

2003-09-23 Thread Hendrik Fuß
Hi there, This is a summary of some of my efforts to get LOB transfers working with DBI. I've seen several posts in dbi-users about problems fetching LOBs with DBD::Oracle. One case, which I couldn't get to work is an assignment to a bind variable of type CLOB inside a PL/SQL block: DECLARE

DBD::Oracle

2003-09-23 Thread mustafa ocak
Hello When I try to execute a script from the command line here are the messages I get: hpcd03[/www/ca/docs/cgi-bin]$ perl report.pl /usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage: /usr/lib/libcl.2 /usr/lib/dld.sl: Exec format error Can't load '/opt/perl/lib/site_per

Re: Better way to get column names with values?

2003-09-23 Thread Bart Lateur
On Tue, 23 Sep 2003 09:37:42 +1000, Fox, Michael wrote: >If you are not worried about the order in which the columns come back, you >could select straight into a hash and save a few lines of code Or blend the two aproaches, use $sth->{NAME} to get an array of names in the proper order, and use a

DBD-ODBC-1.06 error in Makefile.PL on line 427

2003-09-23 Thread Laurence Hall
after config :: $(changes_pm) @$(NOOP) There should be a tab on the second line, not spaces. Make dies.