Re: perl/cgi

2001-04-12 Thread Alexander Farber (EED)
Tommy Wareing wrote: On Wed, Apr 11, 2001 at 07:53:03PM +0300, N Sikkandar Dulkarnai wrote: I added the below line into httpd.conf file under Apacheroot/conf SetEnv ORACLE_HOME=/data1/u01/app/oracle/product/8.1.5 Is it correct ??? No it is not, see

Re: perl/cgi

2001-04-12 Thread N Sikkandar Dulkarnai
Thanks a lot to all. It works after I configured ORACLE_HOME in httpd.conf in correct format as mentioned in http://httpd.apache.org/docs/mod/mod_env.html#setenv With thanks, Sikkandar - Original Message - From: "Alexander Farber (EED)" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: DBD::Oracle CLOB insert through a synonym

2001-04-12 Thread Tim Bunce
Many thanks John! Tim. On Wed, Apr 11, 2001 at 08:32:14PM -0500, John Milton wrote: Yes, synonyms are very much like views. Attached is a hacky diff to do synonyms (but not links). I can't do links here, so I can't test it. We have Kerberos here and I couldn't figure out how to properly

Re: can't find selectrow_hashref

2001-04-12 Thread Tim Bunce
On Wed, Apr 11, 2001 at 08:43:21PM -0500, Mark Stosberg wrote: Tim Bunce wrote: On Wed, Apr 11, 2001 at 05:42:03PM -0500, Mark Stosberg wrote: Tim Bunce wrote: I suspect you're not really using the version you think you are. Add warn $DBI::VERSON to the code. I

Re: can't find selectrow_hashref (reinstalled with same result)

2001-04-12 Thread Mark Stosberg
Tim Bunce wrote: Check that the DBI.pm in that directory contains this group of lines: selectrow_arrayref={U =[2,0,'$statement [, \%attr [, @bind_params ] ]'] }, selectrow_hashref={ U =[2,0,'$statement [, \%attr [, @bind_params ] ]'] }, selectall_arrayref={U =[2,0,'$statement [,

Re: DBI and PERLCC

2001-04-12 Thread Roberto Slepetys Ferreira
Hi Neill, I think that we are making progress !!! The executable size rose, and the error changed: Now it's: Undefined subroutine DBI::dr::connect called at /usr/local/lib/perl5/site_perl/5.6.1/i686-linux/DBI.pm line 408. []s Slepetys - Original Message - From: "Neil Lunn" [EMAIL

Re: In text mode Works, but in HTML does'nt

2001-04-12 Thread Paul A. Chernoch
When I am debugging CGI scripts, I follow this simple approach: 1. Manually set the CGI environment parameters to simulate a CGI call. 2. Invoke the CGI script from the command line on the server. 3. Look at the HTML text that is output. If it looks wrong, fix the script. (It helps to create a

Error when inserting large amounts of text

2001-04-12 Thread Scott Phelps
Here's a snippet of my code: my $dbh = DBI-connect('dbi:ODBC:MYDSN', 'user', 'pass',{RaiseError = 1, AutoCommit = 1}); $sth = $dbh-prepare ("INSERT INTO ARTICLES (ARTICLE_TYPE, TITLE, SUBJECT, AUTHOR, SOURCE, SOURCE_URL, COPY, PULLQUOTE) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"); $sth-execute

Re: Error when inserting large amounts of text

2001-04-12 Thread Robert Davis
check these values out. Read the doc about them. Is the column a long varchar? # print "LongReadLen=$dbh-{LongReadLen}\n"; # print "LongTruncOk=$dbh-{LongTruncOk}\n"; $dbh-{LongReadLen}=5000; HTH bob Scott Phelps wrote: Here's a snippet of my code: my $dbh =

RE: Error when inserting large amounts of text

2001-04-12 Thread Scott Phelps
The docs say that those values are for "fetching only", and setting them seems to have no effect on my insert. Is there any character limit on an insert? ScottP -Original Message- From: Robert Davis [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 12:18 PM To: Scott Phelps

Using Perl to eneter a float

2001-04-12 Thread Mitch Clarvit
Hey gang, Once again, I am here with a problem...this is one of the best places to get an answer... I am using Perl 5.003 to connect to an Oracle 8.1.5 Database. I have a field which is set up as NUMBER (4,2) which I assume equlas .99... As soon as I enter a number greater than 9 such as

RE: Error when inserting large amounts of text (update)

2001-04-12 Thread Scott Phelps
Nope, That doesn't seem to make any difference either. I have ASP's that write these same large text fields into the same tables, but I really prefer to do what this page has to do with perl. Thanks for all the help guys! ScottP -Original Message- From: Michael Peppler [mailto:[EMAIL

Re: Problem (and fix) with DBD::Oracle Makefile.PL on DEC UNIX

2001-04-12 Thread Tim Bunce
Yeah. Many thanks Jonathan! Tim. On Thu, Apr 12, 2001 at 01:47:03PM -0400, Jonathan Segal wrote: Hi, I had major linking problems building DBD::Oracle on our DEC platforms, which after a while I diagnosed to a missing -L entry in the link path. I then diagnosed the reason why this was

Mysql and Perl DBI

2001-04-12 Thread Gordon Stewart
I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make. I have enclosed a screen dump of the output I get. I seams to be getting stuck with dbimon. I have installed DBI-1-13.tar.gz. Can any one help Gordon [gordon@fido

make on HP-UX 11.0 Fails

2001-04-12 Thread David Piazza
Hello, I'm trying to install DBI, on HP-UX 11.0 and am getting error messages during the make. I've attached the output from the Makefile, and make. Also, I tried to statically link but it core dumps. Any help would be appreciated. Thanks, /Dave

Re: Perl and Oracle...Help??

2001-04-12 Thread Jonathan Leffler
"Sterin, Ilya" wrote: [...snip...] All languages exept visual basic use the right cases And, of course, SQL. SQL is case-insensitive for keywords and identifiers, but not for strings and delimited identifiers. I can think of a few other (SQL-based) languages that are case-insensitive, too.

Re: In text mode Works, but in HTML does'nt

2001-04-12 Thread Jonathan Leffler
Curt Russell Crandall wrote: You can also set the CGI.pm debug mode to ON, enter the perl debugger, set the appropriate parameters and set through the file. Sometimes the results can be different than running through the browser, but other times it might point out bugs that may not be