Yes I did,
Dominique
-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: Thursday, October 31, 2002 8:12 PM
To: CF-Talk
Subject: Re: CF MX Query of Query Lower() Function
Raymond Camden wrote:
> It's what I get for posting before coffee. Yes, Lo
Raymond Camden wrote:
> It's what I get for posting before coffee. Yes, Lower() is right, not
> Lcase. So the issue is that it's not handling a null value in the
> column?
Yes. But I presume Dominique has already filled out the bug form.
Jochem
~~
>
> > CFMX Query of Query has an lcase function. You could use
> this to do a
> > non-case sensitive type search. This function did not exist in CF5
> > QofQ however.
>
> LCase() throws an syntax error and is not in the docs [1], whereas
> Lower() is and only throws a null exception when it ge
Raymond Camden wrote:
> CFMX Query of Query has an lcase function. You could use this to do a
> non-case sensitive type search. This function did not exist in CF5
> QofQ however.
LCase() throws an syntax error and is not in the docs [1], whereas
Lower() is and only throws a null exception when
2002 6:20 PM
To: CF-Talk
Subject: Re: CF MX Query of Query Lower() Function
D. Delcomminette wrote:
> by the way what does "the mean time" exactly means ??
It is a typo, it is supposed to be "meantime" :) Which in this case is
the time between submitting the bug to Macrom
o the thing ...
>
> Dominique
>
>
> -Original Message-
> From: Tim Painter [mailto:cftalk@;cfex.com]
> Sent: Thursday, October 31, 2002 5:45 PM
> To: CF-Talk
> Subject: Re: CF MX Query of Query Lower() Function
>
> I believe qoq has a very limited se
D. Delcomminette wrote:
> by the way what does "the mean time" exactly means ??
It is a typo, it is supposed to be "meantime" :) Which in this case is
the time between submitting the bug to Macromedia, for which I posted
the link, and the time Macromedia fixes it.
Jochem
~
@;cfex.com]
Sent: Thursday, October 31, 2002 5:45 PM
To: CF-Talk
Subject: Re: CF MX Query of Query Lower() Function
I believe qoq has a very limited set of functions available. To get around
that, I set the original query to also retrieve the name in lower case and
in my qoq, search on the lower
Hi Jochem,
It is exactly what I meant, the Lower() causes the problem.
In my case, it's not easy to add an intermediate QoQ since my QoQ is
generated dynamically on a lot of criteria entered in a form by a user.
I guess I'll have to use Oracle vues instead of QoQ in the mean time ..
by the way
where
lower_first like '%mat'
HTH,
Tim P.
- Original Message -
From: "DDE" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 7:18 AM
Subject: CF MX Query of Query Lower() Function
> Looks like the usage of
DDE wrote:
> Looks like the usage of Lower() function in a query of query does not
> work as in standard SQL.
> Simple example: if you have a table containing names ( first_name
> middle_name and last_name) the following query of query :
>
>
> select * from myfirstquery where Lower(middle_
Looks like the usage of Lower() function in a query of query does not work
as in standard SQL.
Simple example: if you have a table containing names ( first_name
middle_name and last_name) the following query of query :
select * from myfirstquery where Lower(middle_name) like %mat
gives
12 matches
Mail list logo