Mailing List Archive


Back to the month index Back to the list index
John Fulmer (jfulmer@iegroup.com)
Tue, 31 Dec 1996 11:04:47 -0600 

Message-Id: <32C947AF.7D8C5DB8@iegroup.com>
Date: Tue, 31 Dec 1996 11:04:47 -0600
From: John Fulmer <jfulmer@iegroup.com>
Subject: [mSQL] Msql 2.0 bug (solved)

Okay, after playing with it for a while, I narrowed my bug to the UPDATE
command. In using the following code:

if (msqlQuery($connect, "UPDATE support_info SET
company_name='$qcompany_name'
                    WHERE company_id = $company_id") < 0)
          {
                  echo("ERROR1 : $ERRMSG\n");
          }

I can generate a situation where my index (company_id) field gets a NULL
stuck in it if the company_name CHAR(25) field has exactly 25 characters
in it. This causes w3-msql to hang. 24 characters and under works just
fine, and my index doesn't get clobbered.

This is msql 2.0 Beta 1 with the unofficial patch for UPDATE (and the
others), on a Linux 2.0.27 box (RedHat). 

-- 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ John Fulmer                   | "UNIX was not designed to stop     +
+ Secure Network System         |  you from doing stupid things,     +
+ Lawrence, Kansas              |  because that would also stop you  +
+                               |  from doing clever things."        +
+ jfulmer@iegroup.com           |                                    + 
+ http://www.iegroup.com        |                     -- Larry Wall  +
+                                                                    +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!