Mailing List Archive


Back to the month index Back to the list index
Glenn Cooper (gcooper@cdfsga.fnal.gov)
Thu, 13 Nov 1997 21:41:59 -0600 

Date: Thu, 13 Nov 1997 21:41:59 -0600
From: gcooper@cdfsga.fnal.gov (Glenn Cooper)
Message-Id: <199711140341.VAA20888@cdfsga.fnal.gov>
Subject: Re: mSQL web sites

>1)Are there web sites that have more information regarding MSQL?
>I have searched but can not find any.

Sure, there are lots. Some are listed in the FAQ* - have you
tried those? What sort of information were you looking for?

Glenn

* ftp://bond.edu.au/pub/Minerva/msql/faq.txt
  or ftp://bond.edu.au/pub/Minerva/msql/faq.html
From jetman@li.net Thu Nov 13 22:54:39 1997
Received: from linet06.li.net (linet06.li.net [199.171.6.16])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id WAA29762
        for <msql-list@services.bunyip.com>; Thu, 13 Nov 1997 22:54:38 -0500 (EST)
Received: from LOCALNAME (linuser68.li.net [199.173.75.168])
        by linet06.li.net (8.8.7/8.8.7) with SMTP id WAA10009
        for <msql-list@services.bunyip.com>; Thu, 13 Nov 1997 22:54:45 -0500 (EST)
Message-Id: <199711140354.WAA10009@linet06.li.net>
X-Mailer: GNNmessenger 1.3
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Date: Thu, 13 Nov 1997 22:59:11
From: Jethro Wright III <jetman@li.net>
To: msql-list@services.bunyip.com
Subject: Caveat for mSQL/VB Users....

        Folks: A caveat for mSQL/VB users. I've been writing VB CGIs
for the past couple of weeks. I had a slight glitch w/ my very first
and promptly forgot about this, but it reared it head again today,
so I'm passing this observation along.

        I'd been doing all of my CGI testing using Internet Explorer 3.02
and all was well. Today, I started using Netscape bec that's what's
preferred on the Macs in the office. All of the sudden, some of the
o-put from my CGI simply disappeared. I was simply o-putting a <PRE>
tagged list of names and addresses and only the 1st name of each
record was being displayed. Well, when I opened the HTML source for
the dynamically gen'd HTML page from my CGI, I discovered that VB
has been giving me strings from database which have had ASCII NULLs
at the end of the strings. IE didn't care most of the time, but
Navigator had been truncating my HTML o-put bec of the NULLs. This
wouldn't have been the case w/ C, C++, etc. However, since VB explicitly
stores the length of strings, a NULL isn't a delimeter as is the case w/
C, so NULLs that came from the mSQL client DLL were actually making it
into the HTML. actually, the mSQL client DLL appears to be sending
fixed-length strings, so I also get strings that are padded on the
right w/ extra spaces. (This routinely caused one of my SELECT queries
to fail, even though it looked perfect...)

        Just a word to the wise....Jet

=======================================================================
 The continued survival of the human race, despite its own stupidity,
 is the strongest argument for the existence of a benevolent God.
============================================================= Anon ====