Mailing List Archive


Back to the month index Back to the list index
Ron Simpson (rs@ntconn.com)
Wed, 12 Nov 1997 23:55:48 -0800 

Message-ID: <346AB284.628EBF30@ntconn.com>
Date: Wed, 12 Nov 1997 23:55:48 -0800
From: Ron Simpson <rs@ntconn.com>
Subject: "_seq" anyone know how to make it work?

I'm trying to use the sequence function, but cant seem to get it to
play.

cyrix 6x68 pr150, 32mb ram, linux-2.0.29, msql-2.0.3,protocol 23
help!!!!

thanks,
Ron Simpson 

-- 
Linux!, because reboots are only for upgrades!
From steveh@persimmon.co.uk  Thu Nov 13 06:27:13 1997
Received: from saturn.persimmon.co.uk (saturn.persimmon.co.uk [194.129.133.1])
	by services.bunyip.com (8.8.5/8.8.5) with SMTP id GAA29653
	for <msql-list@services.bunyip.com>; Thu, 13 Nov 1997 06:27:11 -0500 (EST)
Received:  from dione.persimmon.co.uk by saturn.persimmon.co.uk (5.65v3.2/PIPEX simple 1.27)
	id AA11631; Thu, 13 Nov 1997 11:27:21 GMT
Received: by dione.persimmon.co.uk (5.65v3.2/1.1.10.5/07Apr97-0304PM)
	id AA03088; Thu, 13 Nov 1997 11:27:19 GMT
Date: Thu, 13 Nov 1997 11:27:19 GMT
Message-Id: <9711131127.AA03088@dione.persimmon.co.uk>
From: Steve Hunt <steveh@persimmon.co.uk>
To: bill@wileynpt.com
Cc: msql-list@services.bunyip.com
Subject: Re: mSQL NSAPI Question (Threads?)
In-Reply-To: <Pine.SOL.3.96.971111171608.12439A-100000@brandywine.wileynpt.com>
References: <Pine.SOL.3.96.971111171608.12439A-100000@brandywine.wileynpt.com>
Reply-To: steve.hunt@persimmon.co.uk
Mime-Version: 1.0 (generated by tm-edit 7.105)
Content-Type: text/plain; charset=US-ASCII

bill@wileynpt.com writes:
> Included at the bottom is the source code to my mSQL netscape
> authentication plugin...
...
> The only way I can think of to go forward is to try using a lock around
> critical sections.

Yes, you need to get a critical section handle from the appropriate
NSAPI call and use that to lock out other threads during execution of
your MSQL code.

Also, beware of the code in libmsql.c that traps SIGPIPE and closes
the server socket.  If there is a SIGPIPE on some entirely different
socket, it still closes (what it thinks is) the server socket; but
this can happen when the server socket has already been closed and
that fd is being reused for a Netscape connection.  I commented out
the pipeHandler because there is apparently no way to find out which
socket is being reported by a SIGPIPE.

-- Steve
From steveh@persimmon.co.uk  Thu Nov 13 06:28:13 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 GAA29688
	for <msql-list@services.bunyip.com>; Thu, 13 Nov 1997 06:28:12 -0500 (EST)
Received: from saturn.persimmon.co.uk (saturn.persimmon.co.uk [194.129.133.1])
	by mocha.bunyip.com (8.8.5/8.8.5) with SMTP id GAA04760
	for <msql-list@bunyip.com>; Thu, 13 Nov 1997 06:28:19 -0500 (EST)
Received:  from dione.persimmon.co.uk by saturn.persimmon.co.uk (5.65v3.2/PIPEX simple 1.27)
	id AA11760; Thu, 13 Nov 1997 11:28:13 GMT
Received: by dione.persimmon.co.uk (5.65v3.2/1.1.10.5/07Apr97-0304PM)
	id AA05216; Thu, 13 Nov 1997 11:28:12 GMT
Date: Thu, 13 Nov 1997 11:28:12 GMT
Message-Id: <9711131128.AA05216@dione.persimmon.co.uk>
From: Steve Hunt <steveh@persimmon.co.uk>
To: Dug Birdzell <dug@lab.com>
Cc: msql-list@bunyip.com
Subject: Re: NOT keyword..
In-Reply-To: <Pine.GSO.3.93.971111194646.20695E-100000@iron.butterfly.net>
References: <Pine.GSO.3.93.971111194646.20695E-100000@iron.butterfly.net>
Reply-To: steve.hunt@persimmon.co.uk
Mime-Version: 1.0 (generated by tm-edit 7.105)
Content-Type: text/plain; charset=US-ASCII

Dug Birdzell writes:
> Evidently NOT is not present in the current mSQL (2.0.3).  This is ok if
> all you are negating is an equality test; you can just use <>.  However,
> if you want to negate a LIKE, CLIKE, etc. this is a problem. 

You are correct that there is no generic unary NOT operator,
but I think you'll find NOT CLIKE, NOT RLIKE etc are special cases.

-- Steve
From beren@saers.com  Thu Nov 13 07:53:10 1997
Received: from myname.my.domain (ti02a04-0041.dialup.online.no [130.67.17.41])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id HAA01150
	for <msql-list@services.bunyip.com>; Thu, 13 Nov 1997 07:53:08 -0500 (EST)
Received: from localhost (Received: from localhost (beren@localhost)
	by myname.my.domain (8.8.7/8.8.5) with SMTP id NAA00392
	for <msql-list@services.bunyip.com>; Wed, 13 Nov 1996 13:57:29 +0100 (CET)
X-Authentication-Warning: myname.my.domain: beren owned process doing -bs
Date: Wed, 13 Nov 1996 13:57:28 +0100 (CET)
From: Niklas Saers <beren@saers.com>
X-Sender: X-Sender: beren@myname.my.domain
To: msql-list@services.bunyip.com
Subject: msql.h
In-Reply-To: <9711131127.AA03088@dione.persimmon.co.uk>
Message-ID: <Pine.BSF.3.95q.961113135440.387C-100000@myname.my.domain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hi... I've got a small problem here. Tested out the msql-library. As the
manual suggested, I included msql.h and libmsql.a with

 cc sample.c -lmsql -lsocket -lsnl -o sample

(My system is FreeBSD 2.2.5 and MSQL 2.0.1)

My code is quite simple:

#include </usr/local/include/msql.h>

void main(void)
{
   int sock;

   sock=msqlConnect("localhost");
   
   msqlClose(sock);

}

But the command gives me errors in the msql.h:

In file included from sample.c:1:
/usr/local/include/msql.h:120: warning: parameter names (without types) in
function declaration
/usr/local/include/msql.h:121: warning: parameter names (without types) in
function declaration
/usr/local/include/msql.h:134: parse error before `msqlDateToUnixTime'
/usr/local/include/msql.h:134: warning: data definition has no type or
storage class
/usr/local/include/msql.h:135: parse error before `msqlTimeToUnixTime'
/usr/local/include/msql.h:135: warning: data definition has no type or
storage class

Anyone any ideas of why and how to fix this?