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
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
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
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
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 '%%
5 matches
Mail list logo