strSQLstring = SELECT * FROM users WHERE [Gender] = 'Female' AND [GenderInterests] LIKE '%x%' OR [GenderInterests] LIKE '%1%' OR [GenderInterests] LIKE '%2%' OR [GenderInterests] LIKE '%3%' AND ([age] BETWEEN '18' AND '45') And [country] = 'US' And [state] = 'MD' ORDER BY MembershipType, username
The above string is returning more than it should. It must be in the genderinterest part. What I was trying to do when I searched and this string was built was to Find a Female Interested in the interests that I clicked such as MALE , FEMALE and couple. THE PROBLEM: It is supposed to just select from the FEMALES the ones that have interests in Males or females or couples.......... IT is bringing up ANYONE - male or female or couples that is interested in any of the interests. What can I do I figured that WHERE [Gender] = 'Female' would automatically eliminate the other genders? I am thinking it's the way the string has the genderinterests organized..... it should first grab them only if there female and of those select the ones that have these genderinterests......... But its selecting anyone that has these interests regardless of the state or country or gender......... HELP. ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/VpTY2A/lzNLAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
