to the mySQL install. I'd
appreciate help in how to troubleshooting the likely cause of the ERROR 1044.
This application was working flawlessly prior to the "upgrade."
John Hughes
-
Before posting, please check:
http:
ables and search all in one pass?
TIA
John Hughes
__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-
Before posting, please check:
Please allow me to broaden this thread to include backup for mySQL
users who have accounts with ISPs.
In my case I have mySQL access on a Web server where I have NO access
to the server-level options. What is my best option of making a
backup of the database and tables that I use?
Also, what i
Sorting by another field (lname, for
instance) produces "Published" in the previously "empty" status. All
of the "bad" records are "Published" and none (as far as I've found
yet) are "Input."
--- John Hughes <[EMAIL PROTECTED]> wro
quot; doesn't return the same results as WHERE status <>
"input".
But here's the rub:
When I do an individual check on each of the "empty" status records,
every one of them has "published" in the stat
I tried using LIKE \"%published%\" and even LIKE \"%ub%\" The
results are the same as when I attempt = \"published\"
Something in the query processing works differently when = is used in
the WHERE.
I can see no explanation in the data stored in the table.
--- Georg Richter <[EMAIL PROTECTED]> wrote:
> On Saturday, 2. March 2002 09:32, John Hughes wrote:
> > I have a table with approximately 600 rows. Two of the fields are
> > "record_date" and "status" Every record has an entry in the
> > "
t; finds 17 rows.
The query WHERE status <> \"input\" finds 33 rows.
The 33 row answer is the correct answer. I checked the individual
records and can find no record with an answer other than "input" or
"published" in the status.
ASSUMING all records are either
0 days.
Is there a way to construct the query so that only one pass is made
at the database, or must I loop through the last 30 days counting how
many records have published status and equal date?
Any suggestions would be appreciated.
John Hughes
___