You could also add a RowNumber column to your query:
Then, do:
SELECT *
FROM qSomeQuery
WHERE RowNumber >= 21 AND RowNumber < 41
ORDERY BY LastName
Not sure what the performance hit on doing this would be.
Jon
On 1/5/07, Dave Phillips <[EMAIL PROTECTED]> wrote:
> Does
ifferent files, decompile the JIT, and you'll see what I mean. Most
> > of all, turn your debug times on and look at the difference.
> >
> > --Phillip Holmes
>
> I think it's actually a pretty common practice.
>
> Cheers,
> Chris
>
> Jon Gunnip
Chris,
I would be wary of using cfscript just for supposed performance gains
over tags. My understanding is that those gains were eliminated (or
reduced to the point of insignificance) in CF 6.x and 7.x. Here are
what I see as the pros and cons of cfscript. These points are largely
a matter of
Craig,
You can't just merge two XML documents together in CF the way you are
doing it. Spike has an excellent explanation here:
http://www.spike.org.uk/blog/index.cfm?do=blog.cat&catid=8245E3A4-D565-E33F-39BC6E864D6B5DAA.
One simple approach you can take is to turn both the XML documents
into st
We've only support ASCII in our database and so we handle the paste
from Word issue by identifying the most common non-ASCII Word
characters and replacing them with ASCII equivalents:
Replace(Local.Text, chr(8211), "-", "all"); /* short dash from MS Word */
Replace(Local.Text, chr(8212), "--", "al
For the webserver to capture it, I think it would have to be sent with
an HTTP request (e.g. as a CGI variable) which I don't think it is.
We caputre this information via JavaScript by setting the JS variables
screen.width and screen.height into a hidden form variable and then
processing it on the
Snake,
Thanks for the feedback. The charting request does not run in the
correct CF instance because the IIS mapping must hardcode requests to
/CFIDE to a particular CF instance.
I just searched the JRun directory for "CFIDE" and found that I could
get the following to get the charting to work o
Hi,
I have about 15 web applications on a single website. One app
comprises about 75% of the server usage, and I would like to isolate
this app in its own CF instance. I'm using IIS 6.0 on Windows Server
2003.
I have three CF instances and a JRUN connector for each. One instance
is for the def
parent::title matches only if the parent tag of the current node is a .
I would grab title sibling the way you did it.
Jon
On 8/30/06, Ian Skinner <[EMAIL PROTECTED]> wrote:
> Ok I got this to work, but I'm not sure why this way works but my original
> does not.
>
> This works:
>
>
> This does
Ian,
Is the XMLTransform() throwing the "content in prolog" error or is the
XMLParse()?
It looks like your output from the XMLTransform() might not be valid
XML and hence would throw an error in XMLParse().
Jon
On 8/30/06, Ian Skinner <[EMAIL PROTECTED]> wrote:
> Can anybody point out where I h
One major benefit of unit testing is that you can test your Model
before having a functional GUI in place. This lets you isolate
problems in the Model to the Model rather than tracing them through
the View and Controller as well.
I really see the benefits of CFCUnit and unit testing in general in
I posted a couple weeks ago with the same issue. I concluded that
onError() does not fire for webservices. Thanks for submitting a
bug/request to Adobe. That is what I should have done originally.
See: http://houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245568
Jon
On 7/19/06, Ro
e does not return HTML to the requestor, it would not work
either.
Jon
On 7/6/06, Tom Chiverton <[EMAIL PROTECTED]> wrote:
> On Wednesday 05 July 2006 18:28, Jon Gunnip wrote:
> > I've grep'd arround and I can't find it. We could implement o
Hi,
>From my testing, it appears that OnSessionEnd() in Application.cfc is
not called when the CF server has its services restarted. Has anyone
else run into this? Any suggestions for a workaround?
Thanks,
Jon
~|
Message: http
Hi,
We monitor our applications in the production environment by
monitoring various coldfusion logs, like exception.log. When a remote
client calls a webservice on our server and that webservice generates
an exception, is that logged anywhere on our server?
For example, I would hope this is logg
Daniel,
I found that chr(28) is not the actual code for left double quote
copied from Word. It is the resulting code when we try to store the
actual code, chr(8220), to our Oracle DB. To cover new and old data,
we do a replacement on both. The full code we use is below.
Hope that helps,
Jon
This also happened to us once in over a year of generating PDF's using
cfdocument. We traced it down to a PDF request. After that request,
CPU shot up over 50% (it's usually around 10%) and stayed at that
level. No PDF's could be generated until we restarted the CF
services.
Jon
On 4/17/06, D
Oleg,
We have a set of user-defined functions that mimic CF functions not
available in CFScript that we include in many of our applications.
For example, we define throw(), throwType(), and rethrow():
Jon
On 3/29/06, Oleg Gunkin <[EMAIL PROTECTED
Rob,
I believe CF 7 uses xalan 2.5.1 to do its XSLT processing. The
current version of xalan is 2.7.0 (http://xml.apache.org/xalan-j/) but
it still only supports XSLT 1.0.
There might be another XSLT transformer that supports 2.0 and that you
could use in your CF app, but I'm not sure of which o
Sung Woo,
The logfile name is defined by
{jrun.rootdir}/logs/{jrun.server.name}-event.log
If you are running the Server edition, they should be in
coldfusion-event.log, I believe. We change the attribute above to go
to a different directory.
Jon
On 3/28/06, Sung Woo <[EMAIL PROTECTED]> wrote:
Mike,
Under some circumstances, I think a lock around cfsearch is still desirable.
For example, if a user searches a collection while it is being updated
via code, then they will get an error. For this reason, we use a
readonly named lock (e.g. "AppASearchLock") around cfsearch and then
an exclu
We are storing some HTML in our database and I want to ensure it is
valid to insert it into a in an XHTML document.
1) I've tried using XMLValidate(XHTMLText, urlToXHTMLDTD), but I get
an error: 'recursive entity reference "%HTMLlat1". (Reference path:
%HTMLlat1 -> %HTMLlat1 -> %HTMLlat1)'.
2)
Caroline,
I'm not exactly sure what you are asking. If you are asking "How do I
include a form in my cfdocument?" the answer is that the form tag is
not currently supported in cfdocument. When I've tried to use forms
in cfdocument PDF's, I get some funky output.
See
http://livedocs.macromedia
Rick,
We measure memory on our Windows 2000 server in two ways:
1) logging jrun metrics each minute though jrun.xml:
Set metricsEnabled to "true" in jrun.xml and use the following
metricsFormat to get a wealth of interesting statistics including
total and free memory (works for CF7):
Threads (to
I'm using cfcache for a page that takes 30 seconds to generate. This
is the behavior I'm seeing:
Time 0: request #1 comes in, generating page
Time 15s: request #2, starts generating page
Time 30s: request #1 finishes
Time 45s: request #2 finishes
I would think that the second request wouldn't tr
If you are on CF7, then you can use Cast() in the query of queries to
convert a column to a specific type. For example,
SELECT Cast(StringColumn as Integer) as NumberColumn FROM MyQuery
You might not be able to due the order by in the same statement. You
might need an additional query of queri
To control the runtime logs, update the attributes filename,
rotationSize and rotationFiles in
cfusion/runtime/servers/coldfusion/SERVER-INF/jrun.xml and restart the
CF server.
HTH,
Jon
On 7/7/05, Gaulin, Mark <[EMAIL PROTECTED]> wrote:
> Hi
> Is there any way to remove or rename "\cfusionmx\runt
XSLT can be a little bit tricky to get your head around if you are new
to it. For example, variables can only be set once within their scope
and you often use recursion implicitly (apply-templates) or explicitly
(call a template inside of itself) to get things done that you might
you accomplish qu
Chris,
cfdocument does not currently support the form tag and its
subelements. See
http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=1442.htm
In my experience with cfdocument, the input boxes look OK, but the
chec
I think there are probably quite a few bugs with CF's HTML -> PDF
conversion regarding applying CSS properly. Our group has found some
of the following css problems:
1) border-collapse: collapse does not work
2) specifying multiple classes does not work: e.g. should implement both classes but do
Dave,
Thanks for the suggestion, but I don't believe there are any domain
attributes being set in the existing cookies. When I view the cookie
in firefox, it show the host as "mysubdomain.site.com" for one cookie
and "mysite.mysubdomain.site.com" for the other. I think I would see
".mysubdomain.
C-6C958F2F38E1BACD
>
> On 5/6/05, Jon Gunnip <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I have an issue with J2EE session and the incorrect session cookies
> > being sent by IE.
> >
> > I manage a CF site with name like myhost.mysubdomain.site.com.
Hi,
I have an issue with J2EE session and the incorrect session cookies
being sent by IE.
I manage a CF site with name like myhost.mysubdomain.site.com. There
is another CF site named mysubdomain.site.com. We both have J2EE
sessions enabled.
In IE 6 (not Firefox), if a user browses first to my
.
Jon
On 5/4/05, Simon Whittaker <[EMAIL PROTECTED]> wrote:
> Jon,
>
> Thanks - I will give this a try tomorrow, I think it would make sense
> to not require all those directories to be present in every site that
> requires a cfgrid though?
>
> S
>
> On 04/05
Simon,
I have cfgrid working on CF7 with IIS. I have done an IP restriction
to localhost for all directories except classes and scripts. Perhaps
you need to open up the scripts directory too?
Jon
On 5/4/05, Simon Whittaker <[EMAIL PROTECTED]> wrote:
> Hi There,
>
> I have come across somethin
One area where we found significant improvements by moving code from
ColdFusion to Java is where we were creating up to thousands of
objects in high iteration loops. We were modeling an element of lists
with a component and then doing set operations (union, intersect,
difference) on those lists.
Victor,
The docs at
http://ostermiller.org/utils/doc/com/Ostermiller/util/ExcelCSVParser.html
explicitly state that the parser should work as you expect:
Empty fields are returned as as String of length zero: "". The
following line has three empty fields and three non-empty fields in
it. There
Victor,
I'm using the ostermiller CSVWriter, and I am very happy with it. I'm
having trouble understanding exactly what your problem is. Can you
share some relevant code?
Jon
On Apr 4, 2005 12:58 PM, Victor Moore <[EMAIL PROTECTED]> wrote:
> Actually it's a little bit more complicated than thi
, Michael <[EMAIL PROTECTED]> wrote:
> > Have you tried not using the timeout attribute?
> >
> > There are issues with CF not returning the correct results if you have a
> > timeout specified and there are a large number (1000+) results being
> > returned.
>
I'm using CFLDAP against a Novell directory service. Ocassionally, I
am getting the thread hanging even though I have a timeout="60" set on
my cfldap tag. (This is MX and Macromedia docs say that timeout is
actually in milliseconds not seconds
http://www.macromedia.com/cfusion/knowledgebase/index
If using a Jar file on your CF server is an options, you might also
want to take a look at the open-source Java libraries for CV Parsing
and Writing at http://ostermiller.org/utils/CSV.html. The parse()
function in CSVParser throws an IOException if there is an error
parsing.
I use the ExcelCSVPr
Hey all,
I don't like to specify a username or password for datasources when
creating them in the CF administrator..
Anytime I pass through code using a with this setup,
even when a rollback is not executed, I get the following message in
my application.log:
"Warning","jrpp-417","09/30/04","13:
table using
Select string AS myStringColumn1, numeric AS myNumericColumn1, numeric
AS my numericColumn2, etc
FROM QofQTable
The datatypes will be set and you can then populate it reliably. I
thought it was a cool workaround and worth mentioning.
JICIH ;-)
Nando
On Tue, 24 Aug 2004 17:24:58
Is there a public package that supports query of queries-like
functionality in Java? I would assume it would be something like making
a SQL-like query against a Java ResultSet in memory.
I keep coming across QofQ bugs. I would like QofQ functionality
without all of the bugs (not allowing control
Here is a review I wrote for the Salt Lake CFUG
(http://www.slcfug.org/index.cfm?pageID=59):
Jon
"Java for ColdFusion Developers" is great overview of the Java
Programming Language for web developers who already know ColdFusion and
know little or no Java. The book is written for ColdFusion progra
I have an app with 100 forms that are all very similar in structure:
1) filter on some heirarchy of properies on the left: e.g. Year ->
State -> City to find a paricular record
2) edit, delete, or add a new record on the right
I want to streamline the maintenance of writing these CF self-posting
f
TECTED] 7/15/2004 1:06:13 PM >>>
Blackstone does this. You write simple CFFORM/CFINPUT tags and behind
the
scenes it generates XForms (XML standard). Then it uses an XSLT to
transform into HTML. You can use provided XSLT's or make your own.
-----Original Message-
From: Jon Gunni
Rob,
Could you explain why you are creating an XSD from XML? I thought
XSD's were for validation (like a DTD, but more powerful). Are you
using the XSD to validate a form submission?
I would like to use XML/XSLT as a .cfm page builder. The XSLT will
write my cfquery's, cfif's, and forms. Is
I have an app with 100 forms that are all very similar in structure:
1) filter on some heirarchy of properies on the left: e.g. Year ->
State -> City to find a paricular record
2) edit, delete, or add a new record on the right
I want to streamline the maintenance of writing these CF self-posting
f
milar hack for doing random UPDATE's.
Jon
>>> [EMAIL PROTECTED] 5/19/2004 4:28:38 AM >>>
On Tuesday 18 May 2004 19:11 pm, Jon Gunnip wrote:
> PreparedStatement stmt = conn.prepareStatement( "INSERT INTO Users
> VALUES(?,?)");
> User[ ] users = ...;
&g
This is really helpful! I will use something like this in order to
send multiple statements (like 1000 inserts, updates, or deletes) to the
database. Since I am using Oracle, I cannot put multiple SQL statements
inside of a CFQUERY. Looping over CFQUERY does not scale well for many
statements.
erage and save a lot of time (just at the Unit
testing does for the Model layer).
I've been playing around with Canoo WebTest and it is very handy! You
can build up your tests in reusable chunks, all defined in XML using
Ant syntax.
Jon
-Original Message-
From: Jon Gunnip [mai
>> I've started using Canoo WebTest http://webtest.canoo.com which is
an extension of JUnit. It's for testing at the web application level
rather than unit testing. You >> would do this in addition to unit
testing but you can do things like define test scenarios to submit a
form for user registrat
I've also made some modifications to CFUnit. It works great for
testing my Model layer which is written in CFC's. I've got about 40
Tests running about 10 test functions each. It is nice to open a web
page and see whether the recent changes you made have broken your
Model!
I added support for T
Looks to me like you should replace
x.DateReceived = x.DateReceived & REReplaceNoCase(x.xml,
"^.*(.*?).*$","\1");
with
x.DateReceived = x.DateReceived & " " & REReplaceNoCase(x.xml,
"^.*(.*?).*$","\1");
Notice the addition of the " " separator.
Jon
>>> [EMAIL PROTECTED] 03/10/04 04:52PM >>>
>> And that seems to be gobbling as much RAM as before. In any event,
as
>> you said, it's working great when I bypass the CFC so no sense
beating
>> it to death.
Do you have debugging on by any chance? That can really slow down a
CFC-intensive request.
Jon
>>> [EMAIL PROTECTED] 03/09/04 11:2
tialization parameters at the time of object creation, whereby
all objects will automatically be initialzed and each function will not have
to check for initialization.
I didn't see any solutions in the documentation or on the web.
Thanks!
Jon Gunnip
~~
Hello,
I am writing UDF's on MX using , and I would like to know what
the best way to create local variables for use inside my functions that will
not interfere with variables in the caller's scope.
Right now, I have to make sure that my variable names are unique inside and
outside function de
58 matches
Mail list logo