Mailing List Archive


Back to the month index Back to the list index
Gatis Visnevskis (gasha@crp.riga.lv)
Fri, 7 Nov 1997 11:07:28 +0200 (GMT) 

Date: Fri, 7 Nov 1997 11:07:28 +0200 (GMT)
From: Gatis Visnevskis <gasha@crp.riga.lv>
Subject: Re: dbadmin
Message-Id: <Pine.SOL.3.91.971107110307.1700A-100000@crp>

 Try to copy msql.a to current directory, and change in Makefile location
of this library. Or better execute this modified command by self - make
will skip this next time.

Gasha.

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

On Thu, 6 Nov 1997, Fco. Javier Jimenez Olivares EME/O/V L-1256 Tlf.3180 wrote:

>
> 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 ernst@pem.com Fri Nov 7 09:17:19 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 JAA01137
        for <msql-list@services.bunyip.com>; Fri, 7 Nov 1997 09:17:18 -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 JAA13048
        for <msql-list@Bunyip.Com>; Fri, 7 Nov 1997 09:16:51 -0500 (EST)
Received: (from Received: (from root@localhost)
        by pemcom.pem.com (8.8.5/8.8.5) id PAA14539;
        Fri, 7 Nov 1997 15:16:35 +0100 (MET)
Message-Id: <199711071416.PAA14539@pemcom.pem.com>
Received: from cobra.pem.com(10.1.0.64) by amnesiac via smap (V1.3)
        id sma014536; Fri Nov 7 15:16:19 1997
Comments: Authenticated sender is <ernst@pemcom.pem.com>
From: "Ernesto Baschny" <ernst@pem.com>
To: peter@iainc.com, msql-list@Bunyip.Com
Date: Fri, 7 Nov 1997 15:16:10 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: No Cookies?
Priority: normal
In-reply-to: <199711042012.PAA24026@kalpa.iainc.com>
X-mailer: Pegasus Mail for Win32 (v2.54)

> Date: Thu, 6 Nov 1997 02:46:28 -0500 (EST)
> From: Peter Lasota <peter@iainc.com>

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

Yeah! Try something like this:

 setContentType("text/html\nSet-Cookie: this=value; path=/"); 

--
Ernesto  <baschneo@trick.informatik.uni-stuttgart.de>
PEM GmbH <ernst@pem.com> 
Stuttgart - Germany
From graham@vwv.com  Fri Nov  7 09:23:56 1997
Received: from samantha.vwv.com (root@samantha.vwv.com [196.31.121.5])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id JAA01338
	for <msql-list@services.bunyip.com>; Fri, 7 Nov 1997 09:23:50 -0500 (EST)
Received: from vwv.com (localhost [127.0.0.1])
	by samantha.vwv.com (8.8.5/8.8.5) with ESMTP id QAA14869
	for <msql-list@services.bunyip.com>; Fri, 7 Nov 1997 16:21:57 +0200
Sender: graham@samantha.vwv.com
Message-ID: <34632404.FCC44432@vwv.com>
Date: Fri, 07 Nov 1997 16:21:56 +0200
From: Graham Leggett <graham@vwv.com>
Reply-To: graham@vwv.com
Organization: VWV Interactive
X-Mailer: Mozilla 4.03 [en] (X11; I; Linux 2.0.30 i586)
MIME-Version: 1.0
To: msql-list@services.bunyip.com
Subject: mmap() broken -> how do I fix this?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi all,

I have just tried to build msql v2.03, and received the following
message during ./setup:

	checking mmap().  Your mmap() isn't good enough !!!!

	mSQL 2 needs a working mmap(), it cannot work without it.
	You cannot run mSQL 2 on this machine.  Sorry.

What package/library do I need to get mmap() working?

The system is Linux v1.2.13 (don't know the distribution), libc v5.0.9.

Any ideas?

Regards,
Graham

-- 
-----------------------------------------
graham@vwv.com			"There's a moon
VWV Interactive				over Bourbon Street
						tonight...
From ernst@pem.com  Fri Nov  7 12:35:34 1997
Received: from pemcom.pem.com (pemcom.pem.com [193.141.1.250])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id MAA05779
	for <msql-list@services.bunyip.com>; Fri, 7 Nov 1997 12:35:33 -0500 (EST)
Received: (from Received: (from root@localhost)
	by pemcom.pem.com (8.8.5/8.8.5) id SAA08798
	for <msql-list@services.bunyip.com>; Fri, 7 Nov 1997 18:35:29 +0100 (MET)
Message-Id: <199711071735.SAA08798@pemcom.pem.com>
Received: from cobra.pem.com(10.1.0.64) by amnesiac via smap (V1.3)
	id sma008769; Fri Nov  7 18:35:11 1997
Comments: Authenticated sender is <ernst@pemcom.pem.com>
From: "Ernesto Baschny" <ernst@pem.com>
To: msql-list@services.bunyip.com
Date: Fri, 7 Nov 1997 18:35:02 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: FORM with checkboxes
Priority: normal
X-mailer: Pegasus Mail for Win32 (v2.54)

Hello!

I just had an idea to solve a problem that I had which I just want to 
share, maybe it helps someone:

If you have checkboxes (or multiple selectable items) in a FORM, 
and send the results to a w3-msql script, you will end up with:

1) a single variable, if only one checkbox was marked
2) an array, if there were two or more marked items

This leads to the problem where you cannot identify if you have the one
or the other (or is there any way?). If you try to access it as an array
and it is a single variable, you get an error, if you try to access a
single variable with something like $var[0], you will get "(NULL)". The
"#" operator also behaves differently with both types, so this cannot be
used to differentiate them.

So what I did is to guarantee that it is always an array, by having 
TWO hidden bogus entries at the beginning of the form, so that it will 
always be an array. Example:

<FORM METHOD=POST ACTION="test.msql">
 <INPUT TYPE=hidden NAME=add VALUE=bogus>
 <INPUT TYPE=hidden NAME=add VALUE=bogus>
 <INPUT TYPE=checkbox NAME=add VALUE=10> 10<BR>
 <INPUT TYPE=checkbox NAME=add VALUE=11> 11<BR>
 <INPUT TYPE=checkbox NAME=add VALUE=12> 12<BR>
 <INPUT TYPE=submit VALUE="Submit">
</FORM>

This will *always* create the "add" array, where the two first entries 
are "bogus". Beginning with $add[2] are the actual values. $add[2] will 
be "(NULL)" if none were checked.

I can't see any implication with this, maybe there is a better sollution, 
if there is, I would be glad to hear about it.

--
Ernesto  <baschneo@trick.informatik.uni-stuttgart.de>
PEM GmbH <ernst@pem.com> 
Stuttgart - Germany
From peter@iainc.com  Fri Nov  7 15:33:26 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 PAA08862
	for <msql-list@services.bunyip.com>; Fri, 7 Nov 1997 15:33:24 -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 PAA15085
	for <msql-list@Bunyip.Com>; Fri, 7 Nov 1997 15:33:04 -0500 (EST)
Received: tid PAA15673; Fri, 7 Nov 1997 15:15:56 -0500
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 PAA17362; Fri, 7 Nov 1997 15:23:29 -0500 (EST)
Received: (from Received: (from peter@localhost)
          by kalpa.iainc.com (8.8.4/19970121)
	  id PAA12433; Fri, 7 Nov 1997 15:35:05 -0500 (EST)
Date: Fri, 7 Nov 1997 15:35:05 -0500 (EST)
From: Peter Lasota <peter@iainc.com>
Message-Id: <199711072035.PAA12433@kalpa.iainc.com>
To: ernst@pem.com, msql-list@Bunyip.Com
Subject: Re: No Cookies?
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-MD5: 6utwEAxzMILMhaLu1H9QbA==

> From: "Ernesto Baschny" <ernst@pem.com>
> Date: Fri, 7 Nov 1997 15:16:10 +0100
> 
> > Date:          Thu, 6 Nov 1997 02:46:28 -0500 (EST)
> > From:          Peter Lasota <peter@iainc.com>
> 
> > 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?
> 
> Yeah! Try something like this:
> 
>  setContentType("text/html\nSet-Cookie: this=value; path=/");
> 

Works great! Thanks. 

setContentType is documented in the user manual with a note that there
may be no other output preceding the call to it.

Regards, Peter.

-----------------------------------------------------------------------
Peter Lasota                 | Interautomation Inc.
Internet: peter@iainc.com    | Ontario, Canada
From dug@lab.com  Fri Nov  7 22:38:11 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 WAA15267
	for <msql-list@services.bunyip.com>; Fri, 7 Nov 1997 22:38:10 -0500 (EST)
Received: from iron.butterfly.net (iron.butterfly.net [206.138.112.2])
	by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id WAA16234
	for <msql-list@Bunyip.Com>; Fri, 7 Nov 1997 22:37:43 -0500 (EST)
Received: from localhost (Received: from localhost (dug@localhost) by iron.butterfly.net (8.8.5/8.8.3+virtual) with SMTP id WAA21925 for <msql-list@Bunyip.Com>; Fri, 7 Nov 1997 22:38:06 -0500 (EST)
Date: Fri, 7 Nov 1997 22:38:06 -0500 (EST)
From: Dug Birdzell <dug@lab.com>
X-Sender: dug@iron.butterfly.net
To: msql-list@Bunyip.Com
Subject: Re: [mSQL] keywords to convert case of a string?
In-Reply-To: <Pine.GSO.3.93.971107184305.20995A-100000@iron.butterfly.net>
Message-ID: <Pine.GSO.3.93.971107223737.21162E-100000@iron.butterfly.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hello..

Is there an equivalent of ORACLE's UPPER() and LOWER() in mSQL?
I am aware of CLIKE() but I am working on a product which must operate
with both ORACLE and mSQL back-ends.

TIA..

Yours,

Dug Birdzell                   Software Engineer                      HuskyLabs
dug@lab.com                  www.butterfly.net/~dug                 www.lab.com 
1 888 HUSKY US, x239                   ||           1 800 SKYPAGE, pin 419 7381