Apache::Session::DBI and Oracle

2002-01-18 Thread Felipe Martínez Hermo
Hi, there. Hope this is not off-topic :) I have been developing for a couple of months with DBI:Oracle against Oracle7.3 and now I need to use the features of Apache::Session::DBI. I have read the manpage and every page I found on Apache.org and Google, but the simplest sample

DBD:Oracle Problem - Windows 98

2002-01-18 Thread Yegneshwar
Hi It is something that is bugging me for a while. I have installed DBI module and DBD-Oracle module, through the ppm utility of ActiveState Perl for Win32. But when I try to connect to the oracle server it gives the following error. --- install_driver(Oracle) failed: Can't

About fetchrow_array

2002-01-18 Thread Ida Sze
Dear Sir/Madam, I have the following coding: line 70: my $sth=$dbh-do(select * from temp where ID = '$Staff_ID' and Date = '$Date' and Time != '$Time' order by Time desc); line 71: while(my @Data=$sth-fetchrow_array) { .. } but when i run it, the following error message was displayed:

DBD::Oracle 1.12 on Irix 64 fails with ld64 error

2002-01-18 Thread Ken Ortiz
Hello all, This is just a note for those of you who may have had problems installing DBD::Oracle 1.12 onto Irix-64 using a 64 bit perl, in my case perl v5.6.1. Although there's plenty of useful mail in this archive about Irix - DBI/DBD problems, there were no solutions for this specific problem.

Re: Fw: RE: MS Access file - accessing from Linux?

2002-01-18 Thread Nick Gorham
About-tw.com §K¶O¤H¤O»È¦æ wrote: You should use the openlink sdk connect to windows.Use the Multi-tie version of oprnlink software and SDK. Download the l3br.taz ,l3ko.taz ,l3kuz.taz ,l3oc.taz and install.sh for linux.And remeber setup the $ENV before you make. Download

Re: About fetchrow_array

2002-01-18 Thread Ronald J Kimball
On Wed, Jan 16, 2002 at 11:54:27PM -0800, Ida Sze wrote: Dear Sir/Madam, I have the following coding: line 70: my $sth=$dbh-do(select * from temp where ID = '$Staff_ID' and Date = '$Date' and Time != '$Time' order by Time desc); line 71: while(my @Data=$sth-fetchrow_array) { ..

Re: ANNOUNCE: SQL::Statement 1.0, pure perl, join-enabled

2002-01-18 Thread Mr. Sunblade
Jeff Zucker wrote: As always, for large apps where speed is critical, users are better off with a real rdbms. For large apps where speed is critical, consider a vector based solution instead. Regards, Mr. Sunblade

Got a queston about OTHERLDFLAGS

2002-01-18 Thread Jay Strauss
In the README.hpux doc it says: --- In my case, LhtStrInsert was undefined. To solve this problem, I had to looked though the Oracle libraries using nm. I found the symbol in 3 separate libraries in $ORACLE_HOME/lib. I then proceeded to as these libraries to the OTHERLDFLAGS makefile macro

Re: Got a queston about OTHERLDFLAGS

2002-01-18 Thread John D Groenveld
Seems like you should be able to do... env LDFLAGS=-L/path/to/lib -R/path/to/lib -lfoo perl Makefile.PL and have it set OTHERLDFLAGS in Makefile to yours. But of course I always get sea sick when I look at Makefile.PL. John [EMAIL PROTECTED]

How to use bind

2002-01-18 Thread Morrison Davis
Hi ALL, Fairly new to DBI but have managed to get an oracle 9.0.1 data base up and running and a web application to access it. I use: my $STATEMENT2 = Insert into REPLIES values( reply_id.nextval, \'$REPLY\', \'$myform{employee_id}\',sysdate,thread_id.currval,

Re: inserting CGI-data into mysql-DB style question

2002-01-18 Thread Michael A Chase
Something very similar came up a couple days ago. See the attached email. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. - Original Message - From:

RE: inserting CGI-data into mysql-DB style question

2002-01-18 Thread Moritz von Schweinitz
yep. i had a function like this myself once, but i was just wondering whether there's a way to tell the DBI to insert a row from a given hash, interpreting the keys as column-names, and preferably ignoring keys that don't appear in the DB as columnsomething like an inversed fetchrow_hashref,

FW: CPAN Upload: J/JU/JURL/DBD-ODBC-0.31.tar.gz

2002-01-18 Thread Jeff Urlwin
Two new updates: Build directly against SAP db Ping fix for Oracle 8. Please let me know if this causes a problem elswehere. Thanks, Jeff -Original Message- From: PAUSE [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 6:49 PM To: Jeff Urlwin; [EMAIL

RE: How to use bind

2002-01-18 Thread Sterin, Ilya
my $sth = $dbh-prepare(select foo1, foo2 from bar where a = ? and b = ?); $sth-execute($a_val, $b_val); You can also use bind_param() Please read docs (perldoc DBI). It is documented there very well. Ilya -Original Message- From: Morrison Davis To: [EMAIL PROTECTED] Sent: 1/18/02

RE: DBI value assigning Question?

2002-01-18 Thread Sterin, Ilya
This is a matter of knowing how to use hash references, since this is what's being returned. Read perldoc perlref for more info. Hint... $hash_ref-{key} (- dereferences) Ilya -Original Message- From: Murali Kanaga To: '[EMAIL PROTECTED]' Sent: 1/18/02 6:12 PM Subject: DBI value