Mailing List Archive


Back to the month index Back to the list index
Warren Killian (killianw@wishard.edu)
Wed, 14 Apr 1999 08:05:22 -0400 

Message-ID: <37148482.86ABF8D1@wishard.edu>
Date: Wed, 14 Apr 1999 08:05:22 -0400
From: Warren Killian <killianw@wishard.edu>
Subject: Query Logging File

Hello List,

My system administrator just installed the latest greatest version of
mSQL for me to use. I have a question about the query log file:
query.log. In the following entry:

14-Apr-1999 07:45:02 nobody UNIX_SOCK hr 41
SELECT deptname FROM dept WHERE deptID=2

what does the "41" and the end of the first line mean? Other entries in
the query log have different numbers. Thanks for the help! 

-- 
Thank you,
Warren Killian
Web Specialist, MIS Dept.
Wishard Health Services
1001 W. 10th St.
Indianapolis, IN 46202
killianw@wishard.edu
Ph: 317.630.8954
From CSM30005@PAT.ITCARLOW.IE  Wed Apr 14 09:21:19 1999
Received: from tyndall.itcarlow.ie (tyndall.itcarlow.ie [149.153.1.5])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id JAA00995
	for <msql-list@services.bunyip.com>; Wed, 14 Apr 1999 09:21:15 -0400 (EDT)
Received: from PAT (pat.itcarlow.ie [149.153.100.8]) by tyndall.itcarlow.ie (8.7.1/8.7.1) with ESMTP id OAA24766 for <msql-list@services.bunyip.com>; Wed, 14 Apr 1999 14:21:22 +0100
Message-Id: <199904141321.OAA24766@tyndall.itcarlow.ie>
Received: from BARROW/SpoolDir by PAT (Mercury 1.44);
    14 Apr 99 14:20:09 GMT+0000
Received: from SpoolDir by BARROW (Mercury 1.44); 14 Apr 99 14:19:39 GMT+0000
From: "CSM30005" <CSM30005@PAT.ITCARLOW.IE>
Organization: Institute of Technology Carlow
To: msql-list@services.bunyip.com
Date: Wed, 14 Apr 1999 14:11:15 UTC
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Validation with HTML
Priority: normal
X-mailer: Pegasus Mail for Win32 (v3.01d)

Hi all,
	I have a database running that is displaying information to a 
web page and also letting people enter information back to the 
database.

I was wondering was there any way throught MSQL or HTML that I 
could stop them from entering text where there should be number 
and vise versa.

Thank
	Brian
From fmaior@upol.com.br  Wed Apr 14 10:26:13 1999
Received: from 200.245.11.130 (ppp-mta-01.montealto.net [200.245.11.130])
	by services.bunyip.com (8.8.5/8.8.5) with SMTP id KAA02218
	for <msql-list@services.bunyip.com>; Wed, 14 Apr 1999 10:26:11 -0400 (EDT)
Received: from upol.com.br
	([200.245.11.157])
	by 200.245.11.130; Wed, 14 Apr 1999 11:28:54 -0300
Message-ID: <37148879.693FAFE3@upol.com.br>
Date: Wed, 14 Apr 1999 09:22:17 -0300
From: Fernando Maior <fmaior@upol.com.br>
X-Mailer: Mozilla 4.51 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
To: CSM30005@PAT.ITCARLOW.IE
CC: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: Validation with HTML
References: <199904141321.OAA24766@tyndall.itcarlow.ie>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi, Brian & List,

I may be wrong, but I only know the old way: programming. I usually
checks out if what users sent is what should be, allways for type of the
fields, sometimes for the contents, too.

Sorry,
Fernando Maior

CSM30005 wrote:

> Hi all,
>         I have a database running that is displaying information to a
> web page and also letting people enter information back to the
> database.
>
> I was wondering was there any way throught MSQL or HTML that I
> could stop them from entering text where there should be number
> and vise versa.
>
> Thank
>         Brian