Re: FW: DBI error math.h

2001-03-14 Thread Jonathan Leffler
"NEWMAN, SCOTT (SBIS)" wrote: > > I'm running Solaris 2.6 / Perl 5.005 / GCC 2.8.1 /DBI 1.14 > > > > I'm recieving the error below--> Any Suggestions??? > > > > # make > > gcc -c -I/usr/local/include -O -DVERSION=\"1.14\" > > -DXS_VERSION=\"1.14\" -fPIC > > -I/usr/local/lib/perl5/5.00503/sun

Combining Oracle Stored Procedures & DBD::Proxy

2001-03-14 Thread Eric Riggers
Hello, I'm trying to pass arguments to an Oracle stored procedure via DBD::Proxy. When connecting via DBD::Oracle, everything's fine. When I switch to Proxy, I get: DBD::Proxy::st execute failed: Server returned error: Failed to execute method CallMethod: Can't bind a reference (SCALAR(0x202d8

FW: DBI error math.h

2001-03-14 Thread NEWMAN, SCOTT (SBIS)
> -Original Message- > From: NEWMAN, SCOTT (SBIS) > Sent: Tuesday, March 13, 2001 2:00 PM > To: '[EMAIL PROTECTED]' > Subject: DBI error math.h > > I'm running Solaris 2.6 / Perl 5.005 / GCC 2.8.1 /DBI 1.14 > > I'm recieving the error below--> Any Suggestions??? > >

Re: Limiting the number of records selected.

2001-03-14 Thread Difalco, Phil
The select statement below, only works if the top 3 salaries are unique. If two (or more) of the top salaried people have similar salaries - this query breaks down (for the intended result). As long as the target column is unique, this is an "great" way to limit selected rows... Thanks... --

Installation problems with DBD::ODBC

2001-03-14 Thread Chris
I am attempting to install DBD::ODBC on a solaris 2.7 system, and I am having trouble with the install. Summary: make test produces core file solaris sparc 2.7 with perl 5.00503. DBI 1.14 gcc unixODBC driver manager easysoft OOB 1.0.0.25 client install in default location. $DBI_DSN, $DBI_USER

Re: DBI on IBM S390(Unix) Oracle8

2001-03-14 Thread Michael A. Chase
You should be able to build Perl, DBI, and DBD::Oracle on nearly any platform that has an ANSI C compiler. I have seen messages here about DBI in AIX, so S390 UNIX should also be possible. Perl 5.004_03 is getting a bit old. This would be a good chance to upgrade Perl to 5.6 as well as installi

RE: Limiting the number of records selected.

2001-03-14 Thread Difalco, Phil
The select statement below, only works if the top 3 salaries are unique. If two (or more) of the top salaried people have similar salaries - this query breaks down (for the intended result). So, as long as the target column is unique, this is an "great" way to limit selected rows... Thanks...

DBI on IBM S390(Unix) Oracle8

2001-03-14 Thread Wayne Bileci
I'm trying to find out if perl DBI works on an IBMS390(MVS) Unix System services - I have Perl 5.004.03 installed and running on the IBM S390(UNIX) but can't find any DBI stuff. I found a website after going to CPAN - I need the ORACLE DBD or DBI . in the DBD::ORACLE info it does not list IBM S39

DBD:Oracle -- cacheing not working?

2001-03-14 Thread Maarten Ballintijn
Hello, Being new to the list I run the risk of posing a FAQ, but I did try to search the archive :-) I am using perl 5.005_3, oracle 8.1.5, and DBD::Oracle 1.06. I do not seem to be able to get the cacheing working. Whatever I do, each 'fetch' results in an access to the DB (which is quite far

RE: InterScan NT Alert

2001-03-14 Thread Tim Harsch
It's nothing that you did, Mitch. I brought it up because I thought it was at least worth a quick discussion to reassure some of our less outspoken members who were wondering the same thing... Also, I wanted to know if the new listserver was stripping attachments. Apparently it is but it will le

Re: [GENERAL] NULL vs. Empty String

2001-03-14 Thread David Wheeler
On Wed, 14 Mar 2001, Oliver Elphick wrote: > You could write a rule for each table/column that would substitute > NULL for ''. > > However, the concept is all wrong. NULL means "I don't know what > this value is". '' means "I know that this value is an empty string". > Furthermore, having NULLs

Re: DBD::Sybase: how to fetch several compute results?

2001-03-14 Thread Michael Peppler
Alexander Farber (EED) writes: > Hi Michael, > > thanks again for your helpful response! > I have just 2 more questions: > > Michael Peppler wrote: > > One, you need to check $sth->{syb_result_type} to see what sort of > > result row you are retrieving. It you "use DBD::Sybase" you'll h

Re: DBD::Sybase: how to fetch several compute results?

2001-03-14 Thread Alexander Farber (EED)
Hi Michael, thanks again for your helpful response! I have just 2 more questions: Michael Peppler wrote: > One, you need to check $sth->{syb_result_type} to see what sort of > result row you are retrieving. It you "use DBD::Sybase" you'll have > the symbolic values available (CS_COMPUTE_RESULT,

Re: Connecting to An Oracle Database

2001-03-14 Thread Ronald J Kimball
On Mon, Mar 12, 2001 at 01:33:25PM -0500, Mitch Clarvit wrote: > I have no problem connecting to an Oracle 8.1.5 database on Netware 5.1 and > viewing the contents of the database, however, add or editing are causing me > problems. > $sql = "INSERT INTO courses (CourseID, Title, Fees, Hours

Re: DBD::Sybase: how to fetch several compute results?

2001-03-14 Thread Michael Peppler
Alexander Farber (EED) writes: > I have the following stored procedure: Ah yes - the "compute by" rows... There are two things that you need to check. One, you need to check $sth->{syb_result_type} to see what sort of result row you are retrieving. It you "use DBD::Sybase" you'll have the sy

Re: -help

2001-03-14 Thread Randy Peterman
I believe that there is an error in the unsubscribers ways... You probably shouldn't send the message in HTML/RTF format. Try sending a completely blank message with unsubscribe in the body to [EMAIL PROTECTED] Randy Peterman Alt-N Technologies www.altn.com Helping the World Communicate. - O

RE: InterScan NT Alert

2001-03-14 Thread Mitch Clarvit
My apologies to everyone...believe me, it scared me as well when I received the alert! -Original Message- From: Henrik Tougaard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 1:06 AM To: 'Michael A. Chase'; Tim Harsch; [EMAIL PROTECTED] Subject: RE: InterScan NT Alert Your s

Re: [GENERAL] NULL vs. Empty String

2001-03-14 Thread Oliver Elphick
David Wheeler wrote: >Is there a way to get Posgres to assume that a '' insert should be a NULL >insert? And if not, does anyone know of a way to get mod_perl to make that >assumption instead? You could write a rule for each table/column that would substitute NULL for ''. However, the conc

RE: InterScan NT Alert

2001-03-14 Thread Henrik Tougaard
Your suspicion is not quite right. It a virus checker, that as default suspects quite short (~50 chars) mime separators as potential vira or trojans or something. The security manager at news.com.au should change the configuration to something reasonable (eg some a tad longer that the solaris ma

Re: -help

2001-03-14 Thread Michelle Gerfort
Did you not get a mail with this header: confirm subscribe to [EMAIL PROTECTED] when you subscribed to this list? In this mail you find the information on how to unsubscribe /Michelle Teligent AB, Sweden BucWheat wrote: > unsubscribe > > me too, for the third time > > Origina

Re: -help

2001-03-14 Thread BucWheat
unsubscribe me too, for the third time Original Message- From: Yumin He <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, March 13, 2001 8:47 PM Subject: -help >unsubscribe > >

DBD::Sybase: how to fetch several compute results?

2001-03-14 Thread Alexander Farber (EED)
Hi guys, I have the following stored procedure: 1> select_man_hours aso1, 2001 2> go KEY NEEDMAN ALLOCMAN --- --- bta1/2001/3 NULLNULL bta1/2001/4 NULLNULL bta1/2001/11N

Re: Limiting the number of records selected.

2001-03-14 Thread Mark Thornber
Bill, Try to find a copy of 'SQL for Smarties' by Joe Celko. Chapter 25 Subsets has example code for the Top N values which I have successfully used in the past to get Next N as well. The final iteration of the code to display top three salaries (taken from the book) is :- select distinct coun