Mailing List Archive


Back to the month index Back to the list index
Eric Suchomski (kingfoo48@hotmail.com)
Mon, 19 Apr 1999 19:16:22 PDT 

Message-ID: <19990420021622.43297.qmail@hotmail.com>
From: "Eric Suchomski" <kingfoo48@hotmail.com>
Subject: w3-msql and lite error
Date: Mon, 19 Apr 1999 19:16:22 PDT

I am moving some software I had written from one server to another.
It works great on the current server. When I moved it to the new
server the index.msql page does not load. It just asks you where you
want to save the file.

I am running -
Running apache 1.2.6, redhat 5.1, Kernel 2.0.35 on an i686.

I have tried every version of msql 2.x I could find, no luck.

Any help would be great.

Eric Suchomski

_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com
From Anthony@Baratta.com Mon Apr 19 23:29:17 1999
Received: from smtp4.jps.net (smtp4.jps.net [209.63.224.57])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id XAA03787
        for <msql-list@services.bunyip.com>; Mon, 19 Apr 1999 23:29:17 -0400 (EDT)
Received: from Baratta.com (209-142-54-117.stk.jps.net [209.142.54.117])
        by smtp4.jps.net (8.9.0/8.8.5) with ESMTP id EAA02314
        for <msql-list@services.bunyip.com>; Tue, 20 Apr 1999 04:30:34 -0700 (PDT)
Message-ID: <371BF498.477605A9@Baratta.com>
Date: Mon, 19 Apr 1999 20:29:28 -0700
From: Anthony Baratta <Anthony@Baratta.com>
Organization: Time-Slice Network/Computer Services
X-Mailer: Mozilla 4.51 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
To: msql-list@services.bunyip.com
Subject: # versus 0E0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have a "query handle" that seems to vary between returning the number
of rows selected by the query and '0E0'.

According to what I've been able to glean from the list archives and
FAQs: 0E0 is returned on queries with insert, delete (a few others) but
number of rows is supposed to be returned on a Select.

Here is some of the code. (I am using Perl with DIB)

        $DatabaseString = "DBI:mSQL:database=foo-db;hostname=";
        $DatabaseConnection = DBI->connect($DatabaseString, undef, undef);
        $QueryString = "<statement here>";
        $QueryFind = $DatabaseConnection->prepare("$QueryString");
        $RetValue = $QueryFind->execute;

when $QueryString = SELECT * FROM customers WHERE zip_code='33412' ORDER
BY customer_number
then $RetValue = 0E0

when $QueryString = SELECT * FROM customers WHERE zip_code='95376' ORDER
BY customer_number
then $RetValue = 8

Why??

I am testing $RetValue > 0 for Query Success. Should I just add ||
$RetValue eq "0E0" ?? 

-- 
Anthony Baratta
President
KeyBoard Jockeys
                    South Park Speaks Version 3 is here!!!
                       http://www.baratta.com/southpark
                              Powered by Tsunami
From r.bouma@let.rug.nl  Tue Apr 20 04:29:07 1999
Received: from mailhost.rug.nl (mailhost.rug.nl [129.125.4.6])
	by services.bunyip.com (8.8.5/8.8.5) with SMTP id EAA06626
	for <msql-list@services.bunyip.com>; Tue, 20 Apr 1999 04:29:06 -0400 (EDT)
Received: from let.rug.nl (actually host hagen.let.rug.nl) by mailhost.rug.nl 
          with local-SMTP (MMTA) with ESMTP; Tue, 20 Apr 1999 10:29:00 +0200
Sender: s0940712@mailhost.rug.nl
Message-ID: <371C3ACA.5F2574D9@let.rug.nl>
Date: Tue, 20 Apr 1999 10:29:00 +0200
From: Robert Bouma <r.bouma@let.rug.nl>
Organization: RuG
X-Mailer: Mozilla 4.5 [en] (X11; I; HP-UX B.10.20 9000/735)
X-Accept-Language: nl, en
MIME-Version: 1.0
To: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: Socket error
References: <Pine.BSF.3.96.990420090515.7583B-100000@fawn.Hughes.com.au>
Content-Type: multipart/alternative; boundary="------------AAE849B9EE50D56025D90CBF"

--------------AAE849B9EE50D56025D90CBF
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> In 2.0.4, the server by default allowed connections from remote machines.
> In 208 and 209 it isn't.  If you _must_ use a remote connection (i.e. if
> the server is not on the local machine) edit the config file and set
> Remote_Access=True.

This was indeed the problem. After changing the value it did work.
Thanks a lot, we are now back online.

Robert

--

"You're dispicable"
        - Daffy Duck -

--------------AAE849B9EE50D56025D90CBF
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">



In 2.0.4, the server by default allowed connections
from remote machines.

In 208 and 209 it isn't.  If you _must_ use a remote connection
(i.e. if

the server is not on the local machine) edit the config file and set

Remote_Access=True.

This was indeed the problem. After changing the value it did work.

Thanks a lot, we are now back online.

 

Robert

 

-- 

"You're dispicable"
        - Daffy Duck -

 

--------------AAE849B9EE50D56025D90CBF--