Problem seems to be solved.
After reading through the docs i can accross
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_35.htm
Handling null values
That did the trick.
Just to note, that withoug using the fix "AND NOT NULL" that is
mentioned in the docs, if i changed the LIKE "%va
I am beginning to think that there is a limit in the size of the query
that can be used in a QoQ? can anyone confirm this?
The server dosen't struggle at all processing it... i'm totally lost
on this one.
The query dosen't contain any null values and the sql can be
processed, but I am still getti
If i dump out the SQL i get the following:
SELECT *
FROM clientlistTable
WHERE field2 LIKE "%S%"
OR field3 LIKE "%S%"
OR field16 LIKE "%S%"
ORDER BY field3
ASC
Because of the way that cf handles data types in QoQ's i have
converted all values to a string. This is a bitch of a workaround, bu
The way Queries of Queries have been designed makes them almost useless.
CF tries to guess the the of each column from the first record and uses this type in
tests for ordering, grouping, etc.
For instance, if you have a text column, but the first column contains only digits,
the column is suppos
Dave Watts wrote:
>The library "org.apache.oro.text.regex.Perl5Matcher.matches" is simply a
>Java class used by CF to provide Perl 5-compatible regular expression
>support.
>
FYI many other languages include this and usually call it PCRE - Perl
Compatible Regular Expressions.
--
*Damien McKenna*
> after some googling i found that this is a known bug with
> org.apache.oro.text.regex.Perl5Matcher.matches but from what
> was in the thread it was not fixed because they couldn't
> produce a test case? Can anyone confirm this?
The library "org.apache.oro.text.regex.Perl5Matcher.matches" is s
what is in your where clause?... I would agree with what Jochem said
about the Perl style syntax. Since CF converts everything NULL
striaght to blank entries I wouldn't think that would cause a
problem...but hows the data integrity (maybe not the best wording
but..) of the query you are querying? I
Unless ... maybe it's the ASC or DESC? Can we see that whole query block?
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 7:45 AM
To: CF-Talk
Subject: Re: Coldfusion Uses Perl for QoQ ?
doesn't an order by statement ne
Ricardo Russon wrote:
>
> after some googling i found that this is a known bug with
> org.apache.oro.text.regex.Perl5Matcher.matches but from what was in
> the thread it was
> not fixed because they couldn't produce a test case? Can anyone confirm this?
> java.lang.NullPointerException
> at
I think URL.DIR probably stores ASC/DESC
Ricardo, if you CFDump the URL struct before your CFQuery, are column
and dir defined?
-joe
On Wed, 27 Oct 2004 07:45:02 -0400, Michael Dinowitz
<[EMAIL PROTECTED]> wrote:
> doesn't an order by statement need a comma between each clause? Your statement b
doesn't an order by statement need a comma between each clause? Your statement below
looks like it is missing a comma and would fail normally.
> 111 :
> 112 : ORDER BY #url.column# #url.dir#
> 113 :
> 114 :
11 matches
Mail list logo