Mailing List Archive


Back to the month index Back to the list index
Chris Lambrou (chrislambrou@internetmci.com)
Tue, 04 Nov 1997 00:22:13 -0500 

Message-ID: <345EB0BC.4DA8@internetmci.com>
Date: Tue, 04 Nov 1997 00:22:13 -0500
From: Chris Lambrou <chrislambrou@internetmci.com>
Subject: Re: delete status

George,
You can use $Msql::db_errstr global variable. This holds the last error
message received from the mSQL engine.

For example:

$sql = "delete from supplem where acc_no = '$acc_no'";
$sth = $dbh->query($sql) or print "Can't. Reason: $Msql::db_errstr";

HTH,
Chris

George P. Esperanza wrote:
>
> Hi!
>
> It's me again.....
>
> I just want to know, how do i check the status of the query statement
> especially in deleting record. I'm using MsqlPerl Interface.
>
> ex.
>
> $sth = $dbh->query("delete from supplem where acc_no = '$acc_no'");
>
> How do i know if the record is successfully deleted or if the record does
> not exists.
>
> Thanks.....
>
> George
From ernst@pem.com Tue Nov 4 08:25:25 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id IAA01888
        for <msql-list@services.bunyip.com>; Tue, 4 Nov 1997 08:25:24 -0500 (EST)
Received: from pemcom.pem.com (pemcom.pem.com [193.141.1.250])
        by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id IAA01267
        for <msql-list@Bunyip.Com>; Tue, 4 Nov 1997 08:25:19 -0500 (EST)
Received: (from Received: (from root@localhost)
        by pemcom.pem.com (8.8.5/8.8.5) id OAA20025;
        Tue, 4 Nov 1997 14:25:04 +0100 (MET)
Message-Id: <199711041325.OAA20025@pemcom.pem.com>
Received: from cobra.pem.com(10.1.0.64) by amnesiac via smap (V1.3)
        id sma020016; Tue Nov 4 14:25:03 1997
Comments: Authenticated sender is <ernst@pemcom.pem.com>
From: "Ernesto Baschny" <ernst@pem.com>
To: abbey@cc.gatech.edu, msql-list@Bunyip.Com
Date: Tue, 4 Nov 1997 14:25:05 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: msqlimport problem
Priority: normal
In-reply-to: <01bce7b9$a9889d80$30403d80@r64h48.res.gatech.edu>
X-mailer: Pegasus Mail for Win32 (v2.54)

Hi!

> I have problems with importing ASCII formatted files. I have mSQL
> server version 2.0.3. I use msqlimport:
> msqlimport -s\| database table < filename
> i.e. '|' as delimeter.
>
> This works for tables that have short fields. However, when I try to
> import tables with long fields ( ~ 3 kb long; I define them as
> TEXT(255) ), msqlimport tells me:

The problem is in the msqlimport code. It is limited to 5 Kb total length
of a dataset. Change this is the code, before compiling mSQL:

In ./msql/msqlimport.c change all occurences of "[5 * 1024]" with
"[20 * 1024]" (that would be 20 kb). 

--
Ernesto  <baschneo@trick.informatik.uni-stuttgart.de>
PEM GmbH <ernst@pem.com> 
Stuttgart - Germany
From peter@iainc.com  Tue Nov  4 15:09:42 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id PAA12358
	for <msql-list@services.bunyip.com>; Tue, 4 Nov 1997 15:09:41 -0500 (EST)
Received: from linxwall.autolinx.com (linxwall.autolinx.com [207.164.117.2])
	by mocha.bunyip.com (8.8.5/8.8.5) with SMTP id PAA02852
	for <msql-list@Bunyip.Com>; Tue, 4 Nov 1997 15:09:36 -0500 (EST)
Received: from kalpa.iainc.com (kalpa.iainc.com [199.71.253.194])
          by dynaia.iainc.com (8.8.4/8.8.4) with ESMTP
	  id PAA03059 for <msql-list@Bunyip.Com>; Tue, 4 Nov 1997 15:00:28 -0500 (EST)
Received: (from Received: (from peter@localhost)
          by kalpa.iainc.com (8.8.4/19970121)
	  id PAA24026 for msql-list@Bunyip.Com; Tue, 4 Nov 1997 15:12:11 -0500 (EST)
Date: Tue, 4 Nov 1997 15:12:11 -0500 (EST)
From: Peter Lasota <peter@iainc.com>
Message-Id: <199711042012.PAA24026@kalpa.iainc.com>
To: msql-list@Bunyip.Com
Subject: No Cookies?
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-MD5: KR2zhxY5YVG3rd4vCSk2fg==

I was wondering why w3msql/lite doesn't seem to support cookies?
I'm guessing that w3msql sends out a Content-Type header first before
processing the html/lite script.

Any workarounds?

Regards, Peter.

-----------------------------------------------------------------------
Peter Lasota                 | Interautomation Inc.
Internet: peter@iainc.com    | Ontario, Canada.
From emsjjo@rioja.ericsson.se  Wed Nov  5 01:36:48 1997
Received: from penguin.wise.edt.ericsson.se (penguin-ext.wise.edt.ericsson.se [194.237.142.5])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id BAA03429
	for <msql-list@services.bunyip.com>; Wed, 5 Nov 1997 01:36:47 -0500 (EST)
Received: from rioja (rioja.ericsson.se [164.48.92.5]) by penguin.wise.edt.ericsson.se (8.7.5/8.7.3/glacier-1.12) with SMTP id HAA06104 for <msql-list@services.bunyip.com>; Wed, 5 Nov 1997 07:36:43 +0100 (MET)
Received: from orleans by rioja (SMI-8.6/SMI-SVR4)
	id HAA03680; Wed, 5 Nov 1997 07:35:29 +0100
From: emsjjo@rioja.ericsson.se (Fco. Javier Jimenez Olivares EME/O/V L-1256 Tlf.3180)
Received: by orleans (4.1/client-1.3)
	id AA23752; Wed, 5 Nov 97 07:30:07 +0100
Date: Wed, 5 Nov 97 07:30:07 +0100
Message-Id: <9711050630.AA23752@orleans>
To: msql-list@services.bunyip.com
Subject: dbadmin

	Hi,

	I'm trying to compile dbadmin, downloaded from the "Contributed
 Software Archive".

	But it seems doesn't find the library msql.a

	I get this lines:

jjo en orle [dbadmin_v1.0.1][254]> make
gcc -o dbadmin dbadmin.o -L. -lcgic -L/usr/local/Minerva/lib -lmsql
ld: -lmsql: No such file or directory
collect2: ld returned 4 exit status
*** Error code 1
make: Fatal error: Command failed for target `dbadmin'
jjo en orle [dbadmin_v1.0.1][255]>

	Any solution?

	Thanks in advance.
From crp!crp.riga.lv!gasha@racoon.riga.lv  Wed Nov  5 03:10:19 1997
Received: from racoon.riga.lv (racoon.riga.lv [194.8.12.142])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id DAA05509
	for <msql-list@services.bunyip.com>; Wed, 5 Nov 1997 03:10:15 -0500 (EST)
Received: from stoat.riga.lv (root@stoat.riga.lv [194.8.12.138]) by racoon.riga.lv (8.8.4/8.7.3/OL.cf-2.3) with SMTP id KAA26697 for <msql-list@services.bunyip.com>; Wed, 5 Nov 1997 10:09:18 +0200 (EET)
Received: from crp.UUCP by stoat.riga.lv with UUCP id AA01376
  (5.65.kiae-1  for msql-list@services.bunyip.com); Wed, 5 Nov 1997 10:09:34 +0200
Received: by crp.riga.lv id AA22352
  (5.65.kiae-1  for Multiple recipients of list <msql-list@services.bunyip.com>); Wed, 5 Nov 1997 10:04:21 +0200
Date: Wed, 5 Nov 1997 10:04:20 +0200 (GMT)
From: Gatis Visnevskis <gasha@crp.riga.lv>
Cc: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: msqlimport problem
In-Reply-To: <01bce7b9$a9889d80$30403d80@r64h48.res.gatech.edu>
Message-Id: <Pine.SOL.3.91.971105100204.22321A-100000@crp>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

 Try to change delimiter... or maybe you need to use msqlimport from beta 
version. It is possible that they work well.

Gasha.

Makefile: You shouldn't need to change anything below this line

On Sun, 2 Nov 1997, Aibek Musaev wrote:

> I have problems with importing ASCII formatted files.  I have mSQL
> server version 2.0.3.  I use msqlimport:
> msqlimport -s\| database table < filename
> i.e. '|' as delimeter.
> 
> This works for tables that have short fields.  However, when I try to
> import tables with long fields ( ~ 3 kb long;  I define them as
> TEXT(255) ), msqlimport tells me:
> 
> Importing into table 'rl_essays'
> Field 1 is 'classID' of type char
> ..
> Field 18 is 'essayDetails' of type text
> 
> .Fatal error at line 1 : Invalid number of data fields for specified
> table
> 
> I checked the number of my data fields and it is correct.  It worked
> well with the beta version of mSQL server before.  What went wrong?
> And how can I still import my ASCII files now?
> 
> Thanks in advance,
> Aibek.
> 
> 
> 
> 
From crp!crp.riga.lv!gasha@racoon.riga.lv  Wed Nov  5 03:10:19 1997
Received: from racoon.riga.lv (racoon.riga.lv [194.8.12.142])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id DAA05510
	for <msql-list@services.bunyip.com>; Wed, 5 Nov 1997 03:10:15 -0500 (EST)
Received: from stoat.riga.lv (root@stoat.riga.lv [194.8.12.138]) by racoon.riga.lv (8.8.4/8.7.3/OL.cf-2.3) with SMTP id KAA26702 for <msql-list@services.bunyip.com>; Wed, 5 Nov 1997 10:09:19 +0200 (EET)
Received: from crp.UUCP by stoat.riga.lv with UUCP id AA01380
  (5.65.kiae-1  for msql-list@services.bunyip.com); Wed, 5 Nov 1997 10:09:35 +0200
Received: by crp.riga.lv id AA22371
  (5.65.kiae-1  for Multiple recipients of list <msql-list@services.bunyip.com>); Wed, 5 Nov 1997 10:12:25 +0200
Date: Wed, 5 Nov 1997 10:12:24 +0200 (GMT)
From: Gatis Visnevskis <gasha@crp.riga.lv>
Cc: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: mSQL Performance
In-Reply-To: <345DF25E.1FB5D47C@tks.fh-sbg.ac.at>
Message-Id: <Pine.SOL.3.91.971105100900.22321B-100000@crp>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

 Substring search is slow anyway. Try to remove index...

Maybe there is a way to change algorithm ??

Gasha.

Makefile: You shouldn't need to change anything below this line

On Mon, 3 Nov 1997, Tim Sturm wrote:

> Hi there,
> I have a table with with > 40000 entries and I am running a substring
> search on an indexed column.
> The response time is about 50 seconds on a 32 MB Ram, 100 MHz Linux 2.0
> machine.
> Anybody has same (slow) figures or some performance hints ?
>       ______________________________
>         Dipl.-Ing. Tim Sturm, M.S.
>         On the Net                            Fachhochschule Salzburg
>         tsturm@tks.fh-sbg.ac.at              Jakob Haringer Strasse 5
>         www.tks.fh-sbg.ac.at/~tsturm/          5020 Salzburg, Austria
>         Cooltalk: 193.170.110.51              Tel. +43 662 454888 633
> 
> 
From yuq-msql@wayx.com  Wed Nov  5 07:24:08 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id HAA18727
	for <msql-list@services.bunyip.com>; Wed, 5 Nov 1997 07:24:07 -0500 (EST)
From: yuq-msql@wayx.com
Received: from ns.wayx.com (ns.wayx.com [151.196.88.44])
	by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id HAA05152
	for <msql-list@Bunyip.Com>; Wed, 5 Nov 1997 07:24:05 -0500 (EST)
Received: from yuqiang.wayx.com ([203.93.18.195]) by ns.wayx.com (8.8.5/8.6.12) with SMTP id TAA19873 for <msql-list@Bunyip.Com>; Wed, 5 Nov 1997 19:29:20 +0800 (CST)
Message-Id: <3.0.32.19971105202258.006a03e4@marcus>
X-Sender: yuq#X-Sender: yuq#wayx.com@marcus
X-Mailer: Windows Eudora Pro Version 3.0 (32)
Date: Wed, 05 Nov 1997 20:23:44 +0800
To: msql-list@Bunyip.Com
Subject: about the query result of w3-msql
Mime-Version: 1.0
Content-Type: text/enriched; charset="us-ascii"

hi,all

with w3-msql,how can I display the query result in different pages.

for example,I got the result from a query statement which are of 100 rows
,I want to display them in 10 pages,each time only display 10 rows,then
provide the <underline>privious 10</underline> and <underline>next
10</underline> hyper link in the page.

Does msql(maybe the lite or the w3-msql) support this feature?what I mean
is that the query is only executed once and then save the result
tempory,then display the result in serval step.

any help with highly appreciated.

Johnny.
From mdibella@mediaone.net  Wed Nov  5 14:38:49 1997
Received: from chmls01.mediaone.net (ne.mediaone.net [24.128.1.82])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id OAA00686
	for <msql-list@services.bunyip.com>; Wed, 5 Nov 1997 14:38:49 -0500 (EST)
From: mdibella@mediaone.net
Received: from mdibella.ne.mediaone.net ([24.128.10.97])
          by chmls01.mediaone.net (Netscape Messaging Server 3.01)
           with SMTP id AAA8314 for <msql-list@services.bunyip.com>;
          Wed, 5 Nov 1997 14:38:10 -0500
Message-ID: <3460CAA5.5F64@mediaone.net>
Date: Wed, 05 Nov 1997 14:36:05 -0500
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
To: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Expiration date for mSQL listing??
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

is there a way to set a 30 day ect... expiration date for listings in a
classified ad maneger??

i have the 'date_created' var in the DB, is there a way it can be
automatically deleted after 30 days???

many thanks!!,
mike

anyone seeking help in getting mSQL runnig, visit
http://uboss.com/help/mSQL 

to see examples of a DB working, please see http://uboss.com/ham
or http://uboss.com/bookmarks
From msql@klatt.imt.uwm.edu  Wed Nov  5 22:44:27 1997
Received: from klatt.imt.uwm.edu (msql@klatt.imt.uwm.edu [129.89.123.44])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id WAA11614
	for <msql-list@services.bunyip.com>; Wed, 5 Nov 1997 22:44:26 -0500 (EST)
Received: (from Received: (from msql@localhost)
	by klatt.imt.uwm.edu (8.8.5/8.8.5) id VAA30615
	for msql-list@services.bunyip.com; Wed, 5 Nov 1997 21:44:24 -0600
From: RHS Linux User <msql@klatt.imt.uwm.edu>
Message-Id: <199711060344.VAA30615@klatt.imt.uwm.edu>
Subject: msql2.03 deamon dies under load
To: msql-list@services.bunyip.com
Date: Wed, 5 Nov 1997 21:44:23 -0600 (CST)
Content-Type: text

Hi:
	Details are a little sketchy, but under load the msql2.03 deamon
dies.  Environment is a Dec Alpha running Digital Unix V3.2-0 (Rev. 23.4).

	At the time, there were 6 users connected, each user was inserting
into a different table, with a reference to a common "id" table.  The
rate of insertions by each user was approx. 300 seconds per 10,000 inserts.
All tables being inserted had index's on them, some unique some not. I
suspect a problem with the index's, but have no "proof".  If the users
connected one at a time, the tables would populate correctly.  Has anyone
seen this kind of problem?

	Regards,

	Ken Klatt
	Systems Programmer
	University of Wisconsin - Milwaukee
From matthew@tebbens.idsi.net  Thu Nov  6 13:53:34 1997
Received: from tebbens.idsi.net (root@tebbens.idsi.net [205.232.27.10])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id NAA03680
	for <msql-list@services.bunyip.com>; Thu, 6 Nov 1997 13:53:28 -0500 (EST)
Received: from localhost by tebbens.idsi.net
	 with smtp id m0xTX4r-000ebmC
	(Debian Smail-3.2 1996-Jul-4 #2); Thu, 6 Nov 1997 13:54:49 -0500 (EST)
Date: Thu, 6 Nov 1997 13:54:49 -0500 (EST)
From: Matthew Tebbens <matthew@tebbens.idsi.net>
To: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Upgradeing help
In-Reply-To: <3.0.2.16.19971030222948.21b7bc44@205.138.224.216>
Message-ID: <Pine.LNX.3.96.971106135136.29606A-100000@tebbens.idsi.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

I would like to upgrade from 2.0.1 to the latest version.

Does mSQL upgrade cleanly or will I lose all my databases...etc ?
Whats the procedure for upgradeing ??

Thanks,
Matthew