WHERE Membername != '#Cookie.Memebername#'
OR
WHERE Membername <> '#Cookie.Membername#'
See http://www.cfdev.com/resources/discussion/messages.cfm?id=7
For more SQL info
_______________________________________________
Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/
-----Original Message-----
From: Scott M. Berry [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 20, 2000 10:24 PM
To: [EMAIL PROTECTED]
Subject: Basic Query Question
I need to do a query with his logic in it:
WHERE Membername IS NOT '#Cookie.Membername#'
How do I do a NOT in a WHERE?
Scott Berry
- Yahoo!GeoCities Senior Liaison
http://www.geocities.com/~harryhoudini
- Magic Castle Junior Society
http://www.magiccastle.com/Juniors/index.html
- College of the Canyons Web Design
http://www.coc.cc.ca.us
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.