Mailing List Archive


Back to the month index Back to the list index
William R. Mussatto (mussatto@csz.com)
Tue, 20 Apr 1999 09:28:41 -0700 (PDT) 

Date: Tue, 20 Apr 1999 09:28:41 -0700 (PDT)
From: "William R. Mussatto" <mussatto@csz.com>
Subject: Re: # versus 0E0
Message-ID: <Pine.LNX.3.91.990420092759.10845C-100000@cyber16.csz.com>

test for true since 0E0 is true but == 0.

On Mon, 19 Apr 1999, Anthony Baratta wrote:

> 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
>

Sincerely,

William Mussatto
CyberStrategies Systems Engineer
(www.csz.com)
ph. 909-920-9154 ext. 27
FAX. 909-608-7061
From horn@uni-koblenz.de Tue Apr 20 12:32:30 1999
Received: from mailhost.uni-koblenz.de (mailhost.uni-koblenz.de [141.26.64.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id MAA13647
        for <msql-list@services.bunyip.com>; Tue, 20 Apr 1999 12:32:25 -0400 (EDT)
Received: from flens.uni-koblenz.de (horn@flens.uni-koblenz.de [141.26.65.171])
        by mailhost.uni-koblenz.de (8.9.1/8.9.1) with ESMTP id SAA10952;
        Tue, 20 Apr 1999 18:31:49 +0200 (MET DST)
Received: (from Received: (from horn@localhost)
        by flens.uni-koblenz.de (8.8.8/8.8.8) id SAA00716;
        Tue, 20 Apr 1999 18:31:48 +0200
From: Georg Horn <horn@uni-koblenz.de>
Message-Id: <199904201631.SAA00716@flens.uni-koblenz.de>
Subject: Re: msqlimport
In-Reply-To: <Pine.LNX.3.95.990420173643.16249B-100000@dns.alfa.it> from RHS Linux User at "Apr 20, 99 11:49:37 am"
To: msql@dns.alfa.it
Date: Tue, 20 Apr 1999 18:31:48 +0200 (CEST)
Cc: msql-list@services.bunyip.com
X-Mailer: ELM [version 2.4ME+ PL37 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

You wrote:
>
> I'm running msqlimport 2.0.9 and I've a problem. I've to import
> 20k+ data *rows* in a table. It is only 1 filed and the other should be
> null.
>
> ok, the filed is the 3th so I've done *on a test table :)*
>
> msqlimport -m 3:1 animali prova < data
>
> data is like this:
>
> fdsfsd
> 54fdfgsd
> sd63fg
> ...
>
> As you can guess, the data went to the first col.. instead to go
> to the 3th. Any help? :)

Hey, actually someone is using my extensions to msqlimport. ;-)

Try -m 1:3

This should work.

Bye,
Georg