Re: FN-FORUM: One for the SQL Experts

date posted 10th September 2007 23:32

couldn't you append a comma to myVar?

On 10 Sep 2007 22:34:00 -0000, Craig [EMAIL REMOVED] wrote:
>
> Thanks Paul,
>
> But I think that would fail if the numbers were 2,5,22,222,234 and were
> looking for LIKE 2.
>
> Craig
>
> -----Original Message-----
>
> As you might know from my posts I'm no SQL expert, but try:
>
> strSQL = "SELECT COUNT(mailingListID) AS recount FROM tblMailingList
> WHERE IsNull(unsubscribe) AND domainReg = '" & strDomain & "' AND
> mailingGroupID LIKE '" & myVar & "';"
>
> hth
> Paul
>
> On 10 Sep 2007 21:38:48 -0000, Craig [EMAIL REMOVED] wrote:
> >
> > Hi,
> >
> > I'm trying to build a query in classic ASP to fire against a MySQL 5.0
> > server that can look inside a field value.
> >
> > So far I have:-
> > strSQL = "SELECT COUNT(mailingListID) AS recount FROM tblMailingList WHERE
> > IsNull(unsubscribe) AND domainReg = '" & strDomain & "'"
> >
> > There is a tblMailingList.mailingGroupID field that has recently been
> > converted to hold a comma delimited list of mailingGroupID's. I need to
> add
> > something to this query to say "AND the supplied number exists in
> > mailingGroupID" but in SQL of course. In other words, if the
> mailingGroupID
> > field holds: 5,2,6,8,2 and the supplied number is 2 then I want it
> included
> > in the count.
> >
> > Would this be a sub-query, can it be done, am I going about it all the
> wrong
> > way?
> >
> > Any advice gratefully received.
> >
> > Craig
> >
> >
> >
> >
> > --
> > Freelancers, contractors earn more with Prosperity4
> > Call 0870 870 4414 or visit www.prosperity4.com
> > and benefit from Inland Revenue approved expenses today.
> >
> > To advertise here: http://www.freelancers.net/advertising.html
> >
> >
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>