Query help, please...

[admoore]

I have a query selecting records where one enumerative field must be !='N' and any one of six others must be
!='N' like:

$sql_text = ("SELECT * FROM orders  WHERE invoiced != 'Y'
         AND  (
                data_status    != 'N' OR
                art_status     != 'N' OR
                laser_status   != 'N' OR
                print_status   != 'N' OR
                insert_status  != 'N' OR
                mail_status    != 'N' OR
              )
              ORDER BY to_mail_date ASC");

I obviously have something wrong here and am looking for some help on whatever it is I am doing wrong.

TIA for any help,

-Allen

 

[sleipnir214]

I am assuming that the "enumerative field" is the field named "invoiced".

Your question states that the "enumerative field" must be not equal to "N".

Why, then, does your select query require that the field be not equal to "Y"?



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[admoore]

Sorry; the code is correct, typo in post, should be
one enumerative field must be !='N'

Get error upon execution.

-adm

 

[sleipnir214]

What error?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[admoore]

>>> What error?


via php:
Warning: Supplied argument is not a valid MySQL result resource

or via MySQL command line:
ERROR 1064: You have an error in your SQL syntax near '("SELECT * FROM orders WHERE invoiced != 'Y'
AND (
da' at line 1
-adm

 

[sleipnir214]

That PHP error simply means that you aren't trapping enough MySQL errors in your code.


But the MySQL error seems to reveal that you have a spurious character between "da" and "ta_status"

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[r937]

You have an error in your SQL syntax near '("SELECT ...

i'm thinking it doesn't like the parentheses

rudy

http://r937.com/

SQL Consulting

 

[admoore]

Seems to have been:

a spurious character between "da" and "ta_status"