What does like '%%' mean

2001-11-29 Thread Richard Colman
The studio drill-down wizard is generating SQL code that has a where clause like: Members.First LIKE '%%' AND Members.Last LIKE '%#lastname#%' AND Members.Company LIKE '%%' AND Members.City LIKE '%%' AND Members.State LIKE '%%' AND Members.Country LIKE '%%' AND Members.MemberType LIKE '%%' I am

Re: What does like '%%' mean

2001-11-29 Thread Douglas L. Brown
quot;CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 8:34 PM Subject: What does like '%%' mean > The studio drill-down wizard is generating SQL code that has a where clause > like: > > Members.First LIKE '%%' AND Members.Last LIKE 

RE: What does like '%%' mean

2001-11-29 Thread Richard Colman
reciated? -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:12 PM To: CF-Talk Subject: Re: What does like '%%' mean It is keying on the fact that you left a field blank on the request. If you have that in there it will pu

RE: What does like '%%' mean

2001-11-29 Thread Jared Clinton
Null values may not be treated the same as empty strings. Jared Clinton. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Friday, 30 November 2001 3:12 PM To: CF-Talk Subject: RE: What does like '%%' mean It is not actually working that way, and I can

Re: What does like '%%' mean

2001-11-29 Thread Don Vawter
My guess is that you have nulls which won't satisfiy any condition - Original Message - From: "Richard Colman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 10:11 PM Subject: RE: What does like '%%