>When you figure out the specs on the production server, be sure to post -
>because I've never had this problem and it this is a new issue with 7 (we're
>not there yet), we're going to be in for a world of hurt.
>
Turned out it was an issue with CF5. The server was a W2K server with IIS 5 and
C
Incidentally, you can use [] to escape reserved words in query of
queries. I've had to do that on a few occasions, and I made sure when
I implemented my locale-specific query sorting function that it
escaped the column names being passed in this way since I couldn't
know that it wouldn't be used to
I would bet that if you just
> aliased the region field and grouped by it, it would STILL work on
> both your dev box and the other. :0)
>
Mmm... no, I aliased and "unaliased" (if that word exists) one by one all the
columns in different combinations each time (in Group alone, in Group and
My guess is that "Region" is a reserved word *somewhere* between CF, the OS,
the web server...something. That's probably why aliasing the field names fixed
the problem. In fact, I would bet that if you just aliased the region field and
grouped by it, it would STILL work on both your dev box and
When you figure out the specs on the production server, be sure to post -
because I've never had this problem and it this is a new issue with 7 (we're
not there yet), we're going to be in for a world of hurt.
On 3/4/06, Roberto Perez <[EMAIL PROTECTED]> wrote:
>
> At 11:14 AM 3/4/2006, I myself w
At 11:14 AM 3/4/2006, I myself wrote:
>I tried an alias, but in the end, it would be the same thing (i.e.,
>the alias would point back to the original master query) ...
Ok, it is working now. The solution was:
- use an alias for each column in the query of queries
- do not use the alias in the
At 08:45 PM 3/3/2006, I myself wrote:
>Does anyone know, off the top of their heads, if a GROUP command in
>the output of a query of queries has server-specific issues?
I did more digging and this is what I found: when I do a ColumnList
on my desktop, I get a list like this:
cityID,cityID,cit
Hi all,
Does anyone know, off the top of their heads, if a GROUP command in
the output of a query of queries has server-specific issues?
I'm displaying the results of a query of queries using GROUP in the
cfoutput tag:
It works fine on my desktop (developer server, MX6), but when I
upload t
8 matches
Mail list logo
