Select Statement Array Trouble
I have a newsletter program I'm trying to use a group list like 1,2,3,4 in my database to send email to one or more groups. So I get the groups say 1,2 but when I try to get the email address from a user say in group 1 I get nothing. I believe it not finding the 1 in the list of 1,2,3 if the user is in those groups. Here's what I have:
I *TOLD* you that using a delimited list in a single field WILL NOT WORK.
If this line of code:
It WILL NOT MATCH "1,2,3". It WILL NOT MATCH "1,2,3,4,5". It WILL NOT MATCH "1".
One more time: Your lack of understanding of correct database design has led you into a corner. You can't get out of this one.
|All times are GMT +1. The time now is 06:54 PM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.