|
| |
|
|
ACEDISH
Posts: 176
Joined: 9/30/2002
From: Manassas, Virginia
Status: offline
 |
NOT EQUAL or NOT LIKE query - 6/27/2003 23:00:18
what am i doing wrong?
I am trying to query the database and not show results for act_status of " RATED" or " NORATING" when i use this it still shows them..
I alo replace <> with NOT LIKE and had same results
fp_sQry=" SELECT * FROM Results WHERE (username = ' ::username::' AND install_status = ' ::install_status::' AND (act_status <> ' ::RATED::' OR act_status <> ' ::NORATING::' )) ORDER BY install_date DESC"
_____________________________
" Anyone who can only think of one way to spell a word obviously lacks imagination"
|
|
|
|
ACEDISH
Posts: 176
Joined: 9/30/2002
From: Manassas, Virginia
Status: offline
|
RE: NOT EQUAL or NOT LIKE query - 7/1/2003 22:08:15
Thanks, That works fine
_____________________________
" Anyone who can only think of one way to spell a word obviously lacks imagination"
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
.
