I noticed that under CF 5 when building a dynamic SQL statement to query an Oracle
database that 1 does not always equal one. I was using this statement in the Where
clause to simplify my logic like I often see on the list. What happened is that in a
query where 273 records were expected,
I am generating an SQL statement partially inside of a CFQuery tag and partially in
CFScript. When I try to execute the query w/ a WHERE clause, it bombs out. If I try
w/o a WHERE clause it is happy. If I try w/o a WHERE clause and w/ an ORDER BY clause
it is happy. The error message I get
, The American Crisis
-Original Message-
From: Snyder, Jason [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 9:57 AM
To: CF-Talk
Subject: weird CFQuery problem
I am generating an SQL statement partially inside of a CFQuery tag and
partially in CFScript. When I try to execute the query w
First job out of high school they had me work with FrontPage 98 and IIS. What was
really funny is that they wanted me to do ASP with these tools and they made it so
that the only way that you could get to the sites on the IIS server was through
FrontPage and they used Front Page extensions.
What I did was to convert the query to an array, use dateformat on the field(s) that I
wanted to be formatted, and then convert back to a query. This is not the most
elegant solution seeing that when the user creates/modifies dates in the grid, there
is no restrictions on what they enter.
I have noticed that CFGRID in CF5 is very buggy. Many of the problems seemed to be
fixed in a 'hotfix' on Alliar's site, but it doesn't list all of the major problems
that I was having with it. One problem is that when modifying a field one has to
select another field in order for those
I am working on parsing a URL string and storing it in an array of structures. I am
to the point where it works to a certain extent, but not to the point where I need it.
To be more specific I am passing a string that should be parsed into two structure
elements in the array. The data seems
It seems that normally in Access and with ASP (VBScript) you access date fields with #
signs around the value. For some reason ColdFusion doesn't like it when I do that.
What I do is to use single quotes instead and it seems to make things happy once again.
-Original Message-
From:
Thanks for all of your input.
I figured out a way to get more consistent results. What I did was to add 0.0 to the
number in hopes that it would force internal conversion to float or double. Once I
did this I started getting consistent results. If any of you are interested here is
the UDF
I am running ColdFusion server 5.0 and when flipping through the docs I do not see any
Math functions to round to a particular number of significant digits. Plus on
Allaire's site I know about the custom tag gallery, but I do not see a UDF (user
defined function) gallery. Then when I
I wrote a UDF that uses the log10 function and I noticed something was a bit fishy.
When I isolated the log10 function and fed it 31 it spit out 1.49136169383. When I
fed it 32 it spit out 3. (I was expecting something more like 1.50514997832.) I went
to cflib like what was suggested in a
11 matches
Mail list logo