----- Original Message -----
From: "Thomas J Keller" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 2:49
Subject: Re: Strange pseudo-coded query
> Rolf Hopkins wrote:
> > This is way off topic and you should seek an MS Access help list.
>
> Excuse me. I am working in MySQL. I see no reference whatever to MS
Access
> in my message. How do you
> figure this is "off topic?"
Because I don't know of any other DB that places square brackets around
table names, column names, field names, etc. If you really are working with
MySQL and you are using that code with MySQL, then you need to make a lot of
changes. For starters, it is not a very good idea to have spaces in your
table and column names even though you can. The square brackets need to be
removed plus many other changes.
>
>
> > [Zip Code Distance Extractor] could refer to any number of diff things
such as a
> > column in a table, a table name, a field on a form.
>
> I suppose it could. There is no such table or column listed in the
> documentation that comes with this product.
Ummmm!! Now I'm confused. Is this code a part of someone else's software
you purchased??? If so then maybe I understand. You are trying to MSAccess
SQL statements with MySQL. This product was designed for MSAccess or even
MSSQL, not MySQL. Sorry, I'm not that familiar with MSSQL.
>
> > The "!" also has several different meanings and you should be able to
find it in help files.
>
> Help files for what? According to the books I have, the "!" means
"NOT" in
> the context of a SELECT clause.
That's exactly what it means and it means that in many programming languages
as well but if you read the MSAccess online help, you'll find that it also
has other meanings.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
